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


Reply