Skip to main content
To homepage To homepage
Question

Snowflake as data source

B
Starter
Forum|alt.badge.img

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.

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

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

 

B
1 person likes this
  • B
    bjorn
Thomas Lind
Community Manager
Forum|alt.badge.img+5

Hi ​@bjorn 

I have two different setups.

The difference is that I added a Role

B
Starter
Forum|alt.badge.img
  • bjorn
  • Starter
  • March 20, 2025

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

 

Thomas Lind
1 person likes this
  • Thomas Lind
    Thomas Lind
Thomas Lind
Community Manager
Forum|alt.badge.img+5

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. 

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings