Connecting to Snowflake

Connecting to Snowflake

The SaveToDB add-in allows connecting to Snowflake tables, views, and stored procedures.

The SaveToDB add-in supports the following data providers:

  • Snowflake ODBC Driver
  • Snowflake .NET Data Provider

The add-in ships the .NET data provider compiled from sources with added features. You can use it from the box.

You can download and install Snowflake ODBC drivers at https://docs.snowflake.com/en/user-guide/odbc-windows.

Microsoft Excel supports Snowflake ODBC drivers and does not support .NET data providers.

Here is a sample of the Database Connection Wizard page where you can select the data provider:

Connecting Excel to Snowflake - Selecting Provider

Connecting to Snowflake Databases

Use the following server name format for Snowflake:

<account>.<location>[.<host>]

Here is a sample of the connection:

Connecting Excel to Snowflake

Here is a sample of the connection without the host part:

Connecting Excel to Snowflake

We recommend using the .NET Data Provider as it supports configuring additional properties using the Properties button:

Connecting Excel to Snowflake, .NET Provider Properties

Configuring such properties is not necessary. However, it can be useful.

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.