Error connecting Snowflake source

Connector Questions & Issues
1
  • Is this your first time deploying Airbyte?: No
  • OS Version / Instance: MacOS
  • Memory / Disk: you can use something like 16Gb / 1 Tb
  • Deployment: Are you using Docker deployment?
  • Airbyte Version: What version are you using now? 0.35.55-alpha
  • Source name/version: Snowflake
  • Destination name/version: N/A
  • Step: The issue is happening during creating a new source?

When attempting to connect a Snowflake reader role to Airbyte running locally on my MacBook Pro, I get the following error :

Could not connect with provided configuration. Error: Cannot create JDBC driver of class 'net.snowflake.client.jdbc.SnowflakeDriver' for connect URL 'jdbc:snowflake:

I have removed the URL for account privacy, following the jdbc:snowflake. I have verified the database, schema, and warehouse are all create.

Has anyone seen this error before? How did you fix it? What was the root cause?

Many thanks for the help.

Cheers,
Jason

3

Are you running in a Mac M1 chip?

4

Hey Marcos,

No, i7 Intell Mac.

I think the issue was more about the source (Snowflake) and less about AIrbyte. I am also working with the Snowflake folks and I think I have it working. It is running now.

Cheers,
Jason

5

Nice to hear that, if possible share here what what the problem/solution :smiley:

6

Hey Marcos,

The issue was with Snowflake data sharing and how my client configured authentication. When we followed the script in the docs (to create an Airbyte user) Snowflake was saying no user exists in Auth0. The workaround was to grant an existing user, say SYSADMIN all the rights need for Airbyte, then provide my user account access to use the SYSADMIN account. This solved the issue, and we are now pulling data without issue.

Thank you again for all the help.

Cheers,
Jason

7

Hi there from the Community Assistance team.
We’re letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you’re having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we’ll follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.