JSON schema validation failed - Oracle to Snowflake

Connector Questions & Issues
,
1

→

  • Is this your first time deploying Airbyte?: No
  • OS Version / Instance: Windows
  • Memory / Disk: 16gb/30gb
  • Deployment: Docker Desktop
  • Airbyte Version: 0.35?
  • Source name/version: Oracle
  • Destination name/version: Snowflake
  • Step: Json schema validation failed
  • Description: Remove this with the description of your problem.

I’m performing an integration between Oracle (source) and Snowflake (target).
All settings were successfully made.

The airbyte even creates the raw tables, however, when starting the normalization process, the following error appears:

2022-07-31 20:40:24 INFO i.a.v.j.JsonSchemaValidator(test):56 - JSON schema validation failed.
errors: $.access_token: is missing but it is required, $.refresh_token: is missing but it is required

I use username and password to connect to Snowflake.

I analyzed the entire log and the only thing I find error is the one above.
logs-64.txt (2.8 MB)

Attached is the complete log.

Thanks or help!

2

Hello, @Rogerio! Which version of the Snowflake connector are you using? I found an issue that might be related to the error you’re getting:
https://github.com/airbytehq/airbyte/issues/14389

Let me know if you’re using snowflake-0.4.30, then I’ll connect that issue to your post internally.

3

I am using snowflake-0.4.24.
The version Snowflake-0.4.30 i didn’t find.

4

I was not able to replicate your issue, could you please update your Airbyte to the latest version (0.39.41) and the Snowflake destination to 0.4.34?
https://docs.airbyte.com/integrations/destinations/snowflake/#changelog