Skip to main content
To homepage To homepage

Hi,

I need to connect to Snowflake as a data source.

I have downloaded the latest odbc version for windows from https://www.snowflake.com/en/developers/downloads/odbc/ and installed the provider.

From XPilot I get an answer how to configure the odbc data source, but I cant find the “Private Key” field in no 4. That field seem to be “missing” in the config dialog. 
 

Step 3: Configure the ODBC Data Source with the Private Key

  1. Open the ODBC Data Source Administrator Application and go to the System DSN tab.
  2. Press "Add" and select SnowflakeDSIIDriver. Click Finish.
  3. In the Snowflake Configuration Dialog, provide a name for the data source.
  4. Enter the connection details:
    • User: The Snowflake user name.
    • Private Key: The path to the rsa_key.pem file.
    • Database, Schema, Warehouse: Specify the database, schema, and warehouse.
    • Tracing: Set to 0.
  5. Test the connection to ensure it is successful. Press OK.

 

Any suggestion on this? Where should I to put the filepath?

regards,
Bjørn A.

Hi ​@bjorn 

I do not think a private key is necessary in this case.

I was able to connect to my snowflake db using the ODBC driver using these details:

Then create a ODBC data source similar to below

 

Hi ​@bjorn 

I have two different setups.

The difference is that I added a Role

Hi,

From Snowflake’s knowledge base:

https://community.snowflake.com/s/article/How-to-set-up-ODBC-Driver-with-key-pair-authentication-to-connect-to-Snowflake-on-Windows

 

Hi ​@bjorn 

I did not find that I needed to go through all that to use this option, but it is probably something we should reference in our guide for this.

It is a thorough guide that’s for sure. 

Hi ​@bjorn does the above help answer your question? If so please help us by marking a best answer above. Please let us know if you have any follow up questions

Hi again,

An update on the Snowflake as a data source...

I did get a connection with the Snowflake as a data source using ODBC, but I couldn’t import the metadata.

What I needed to do was this…

  1. Select “Edit Data Source”
  2. Advanced Settingings
    • remove the “a” letter in TABLE_SCHEMA to TABLE_SCHEM 

 

That solved it, for me :-)

Reply


Terms and ConditionsCookie settings