Skip to main content
Note: Snowflake will no longer support the username and password authentication mechanism as of November 2025. As a result, this connector will be retired in November 2025 and will no longer function. Please consider using one of the following connection methods instead:

​
Intro

Snowflake is data warehouse that makes it easy to bring together all your data and make it available to all of the users and systems that need to analyze it. You can use Domo’s Snowflake connector to retrieve data from a specified warehouse, database, and database schema by inputting an SQL query. For more information about the Snowflake API, go to https://docs.snowflake.net/manuals. The Snowflake connector is a “Database” connector, meaning it retrieves data from a database using a query. In the Data Center, you can access the connector page for this and other Database connectors by clicking Database in the toolbar at the top of the window. This topic discusses the fields and menus that are specific to the Snowflake connector user interface. For general information about adding DataSets, setting update schedules, and editing DataSet information, see Adding a DataSet Using a Connector.

​
Prerequisites

To connect to a Snowflake database and create a DataSet, you must have the following:
  • The full name of your account (provided by Snowflake). This is the portion of your Snowflake URL immediately following https://. Note that your full account name may include additional segments that identify the region and cloud platform where your account is hosted. The following table provides account name examples by cloud platform/region. For each row, it assumes your account name is “xy12345.”
    snowflake_account_names.png
  • The username and password for your Snowflake account.

​
Connecting to Your Snowflake Account

This section enumerates the options in the Credentials and Details panes in the Snowflake Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Connector.

​
Credentials Pane

This pane contains fields for entering credentials to connect to your Snowflake account. The following table describes what is needed for each field:

Field

Description

Account Name

Enter the name of your account (provided by Snowflake). For US West Region account_name , and All other regions account_name.region_id .

Host

Enter the Host name (provided by Snowflake). For example, snowflakecomputing.com , snowflakecomputing.cn

Username

Enter the username associated with your Snowflake account.

Password

Enter the password associated with your Snowflake account.

Role

Enter your role.

After you have entered valid Snowflake credentials, you can use the same account in Domo any time you create a Snowflake DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Manage Connector/Adapter Accounts.

​
Details Pane

This pane contains a number of fields and menus for entering your SQL query and specifying the location of the data you want to retrieve.

Parameter

Description

Query Type

Select the query type.

Enter Query It enables an option to enter the user defined query.
Query History It will fetch the data from the Snowflake query history for the last 70 days using the predefined query.
Table Information It will fetch the metadata information about the objects created in your account.
Warehouse Metering History It will fetch the warehouse usage and metering information for the last 70 days.

Query

Enter the SQL query to use to retrieve your data. You can use the Query Helper parameter to help you write a usable SQL query. To use the Query Helper , do the following:

  1. Select your desired warehouse, database, database schema, database table, and table columns in each menu.

  2. Copy the SQL statement that appears in the Query Helper field.

  3. Paste the copied SQL statement into the Query field.

Warehouses

Select the warehouse containing the data you want to retrieve. The list populates with all of the warehouses you have access to based on your credentials.

Databases

Select the database containing the data you want to retrieve. The list populates with all of the databases you have access to based on your credentials.

Database Schema

Select the database schema containing the data you want to retrieve. The list populates with all of the schemas you have access to based on your credentials.

Database Objects

Select the database object from the drop-down list.

Database Tables (Optional)

Select the database table you want to retrieve. The list populates with all of the tables you have access to based on your credentials. If you do not select a database table, the connector retrieves your entire database schema.

Table Columns (Optional)

Select the table columns you want to retrieve. The list populates with all of the columns you have access to based on your credentials. If you do not select a table column, the connector retrieves your entire selected database table.

Query Helper (Optional)

When you select warehouses, databases, schemas, tables, etc. from the above menus, a usable SQL query is built for you in this field. Copy and paste the SQL statement in this field into the Query field. For more information, see the entry for Query , above.

Database Views

Select the database view.

View Columns

Select which view columns you want to include in your report.

Fetch Size (Optional) Enter a fetch size for memory performance. If this field is left blank, the default value of 1000 will be used. If the DataSet throws an “Out of memory” error, try decreasing the fetch size.
Convert BIGINT to LONG Select this checkbox if you want to convert BIGINT columns to LONG.
Disable NetWork Timeout Select this checkbox if you observe errors regarding network timeout.
Query Tag This is an optional parameter that can be used to tag connector SQL executions in Snowflake as a Query Tag .
Convert Columns to String Enter the column names separated by comma to convert the columns to string. For example, column1, column2, column3.

​
Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Connector.

​
FAQs

This connector allows you to import your data into Domo from Snowflake using Snowflake’s JDBC drivers. Use this connector with a Snowflake Account Name, local username, and password to ingest small to large datasets from Snowflake.
You need the CREATE TABLE, COPY INTO, PUT, CREATE FILE FORMAT, REMOVE, and LIST permissions on Snowflake.
You need the account name (provided by Snowflake), your Snowflake username, and private key. If you are creating an encrypted private key then you will need a passphrase used to encrypt the private key file. You can also provide your role name.
Yes
Your Domo input dataset ID is in the URL of the dataset you are exporting data from. For example: https://customer.domo.com/datasources/aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee/details/settings
This depends on your server configuration.
DataSets can run as often as every 15 minutes. However, depending on the runtime of the query, DataSets may need to run less frequently.
Make sure that all the words, table names, and field names are correctly spelled. Refer to the Query Helper field for query help.
Before you can connect to a Snowflake database, you must also whitelist a number of IP addresses on your database server on the port you want to connect to. For the full list of IP addresses, see Whitelisting IP Addresses for Connectors & Federated Adapters.
Yes. This connector is designed for all-sized DataSets.
You only see content that you have access to based on the user role entered for your account in Snowflake. If you aren’t seeing something you are expecting, make sure that role has access to that warehouse, database, and table. etc.If you do not enter a role in Snowflake, the SYSADMIN role is used by default.
This connector uses Snowflake’s built-in OAuth service. To get a client id and secret to use with this connector, you will need to create a security integration in Snowflake as described here: https://docs.snowflake.com/en/user-guide/oauth-custom.When creating the integration, use the following for the OAUTH_REDIRECT_URI: https://oauth.domo.com/api/data/v1/oauth/providers/snowflake-oauth/exchange.
Yes, this connector requires each user who powers up the connector to provide the client id and secret. An alternative to this connector is the Snowflake Enterprise OAuth Connector. This connector enables Major Domos to save a client id and secret pair, which users can reference when powering this connector.