Skip to main content

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.

 

 

Hi ​@jaygsk .

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=myrole

Please let us know if this helps.

Kind regards,
Adrian


Hi ​@jaygsk! Did ​@Adrian Anderson’s solution help with your question? If yes, could you please kindly mark it best answer and don’t hesitate to let us know if you have any follow up questions in the comments!


Reply