Hi everyone! I keep getting the “JSON Schema valid...
# ask-community-for-troubleshootingh
Home Kralych
11/08/2022, 7:02 AMHi everyone! I keep getting the “JSON Schema validation failed” when syncing a MySQL table with BigQuery using default settings
• sync mode: Incremental | Append
• normalization and transformation: Raw data, no normalization
s
Sunny Hashmi (Airbyte)
11/09/2022, 1:59 AM🤔 can you double check that you're using the latest connector and airbyte version?
h
Home Kralych
11/09/2022, 8:56 AMI’m still on
• 0.33.11-alpha
But when I try to run the same sync with the same configuration on a test table (the same table but smaller size) everything works out fine, so I wonder if the table size (it’s around 400 GB) has anything to do with.
Home Kralych
11/09/2022, 10:23 AMI actually found a similar issue although the source and the destination are different in my case. It works on a smaller size test table but raises the error when trying to replicate the production table of much bigger size
https://github.com/airbytehq/airbyte/issues/10047
Home Kralych
11/09/2022, 10:27 AM Copy code
2022-11-06 02:22:34 INFO () JsonSchemaValidator(test):56 - JSON schema validation failed.
errors: $: null found, object expectedHome Kralych
11/09/2022, 10:29 AMIs there a way to disable validation of this kind when syncing tables? Maybe it would solve my problem
s
Sunny Hashmi (Airbyte)
11/09/2022, 12:29 PMHey, this may be due to outdated Airbyte platform and connectors. Can you try upgrading? Airbyte is at v0.40.18 now
6 Views