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 to Snowflake Databases

Use the following server name format for Snowflake:

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

Here is a sample of the connection:

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

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

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