I am creating new source connection from Ataccama ONE and I need help on how to connect Snowflake.
From below screenshot I am trying to understand JDBC connection looks like.
For e.g. I am using jdbc:snowflake://myorganization-myaccount.snowflakecomputing.com/, but it is not working.
Any help is greatly appreciated.
Best answer by Adrian Anderson
Hi ​
The Snowflake JDBC documentation might be useful here:
https://docs.snowflake.com/en/developer-guide/jdbc/jdbc-configure#label-jdbc-connection-string
Please note the section on Connection Parameters and the following detailed descriptions:
https://docs.snowflake.com/en/developer-guide/jdbc/jdbc-parameters
Typically, we would want to specify the warehouse, db, schema and/or role parameters, e.g.:
jdbc:snowflake://myorganization-myaccount.snowflakecomputing.com/?warehouse=mywh&db=mydb&schema=public&role=myrolePlease let us know if this helps.
Kind regards,
Adrian
Hi ​
The Snowflake JDBC documentation might be useful here:
https://docs.snowflake.com/en/developer-guide/jdbc/jdbc-configure#label-jdbc-connection-string
Please note the section on Connection Parameters and the following detailed descriptions:
https://docs.snowflake.com/en/developer-guide/jdbc/jdbc-parameters
Typically, we would want to specify the warehouse, db, schema and/or role parameters, e.g.:
jdbc:snowflake://myorganization-myaccount.snowflakecomputing.com/?warehouse=mywh&db=mydb&schema=public&role=myrolePlease let us know if this helps.
Kind regards,
Adrian
+3Hi ​
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
