Skip to main content
To homepage To homepage
Solved

Snowflake as data source

B
Contributor
Forum|alt.badge.img
  • bjorn
  • Contributor
  • 5 replies

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.

Best answer by bjorn

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

 

View original
Did this topic help you find an answer to your question?

6 replies

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
  • Thomas Lind
  • Community Manager
  • 1029 replies
  • March 20, 2025

Hi ​@bjorn 

I have two different setups.

The difference is that I added a Role

B
Contributor
Forum|alt.badge.img
  • bjorn
  • Author
  • Contributor
  • 5 replies
  • Answer
  • 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
  • Thomas Lind
  • Community Manager
  • 1029 replies
  • March 20, 2025

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. 

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

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

B
Contributor
Forum|alt.badge.img
  • bjorn
  • Author
  • Contributor
  • 5 replies
  • March 25, 2025

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 :-)

Christian Hauggaard
1 person likes this
  • Christian Hauggaard
    Christian Hauggaard

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