Skip to main content

​
Intro

Snowflake is a data warehouse built for the cloud that stores all your data and users. Use Domo’s Snowflake Unload V2 Connector to unload data from your Snowflake into Amazon S3. Unloaded files are imported from Amazon S3 into Domo. Choose this connector instead of the Snowflake connector if you are executing very large queries. 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 OAuth Internal Unload V2 connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Connector.

​
Prerequisites

To connect to your Snowflake database account and create a DataSet, you must have the following:
  • Client ID
  • Client Secret
  • Full name of your account (provided by Snowflake)
  • Snowflake Host name
  • AWS S3 Access Key
  • AWS S3 Secret Key
  • Name of the AWS S3 Bucket
  • Amazon S3 Region

​
Connecting to Your Snowflake Account

This section enumerates the options in the Credentials and Details panes in the Snowflake OAuth Internal Unload V2 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 Data 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

Client ID Enter your Client ID (provided by Snowflake when the client is registered).
Client Secret Enter your Client secret (provided by Snowflake when the client is registered).
Account Name Enter the full name of your account (provided by Snowflake).
Host Enter the snowflake host name.
Role Enter your Snowflake role.
S3 Access Key Enter your AWS access key. It is available in the AWS Console in the Security Credentials section or under Users if you are using IAM.
S3 Secret Key Enter your AWS secret access key. It is available when you create your Access Key. You can generate a new one in the AWS Console.
S3 Bucket Name The name of the AWS S3 Bucket.
S3 Region Select the Amazon S3 Region.
Once you have entered valid Snowflake credentials, you can use the same account any time you go to create a new Snowflake OAuth Internal Unload V2 DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

​
Details Pane

This pane contains a primary Reports menu, along with various other menus which may or may not appear depending on the report type you select.

Menu

Description

How would you like to import data into Domo? Select how you want to import your data.
Query Type
QueryType Description
Custom Query Enter the SQL query to execute.
Query Builder Select a table and fields to autogenerate your query.
Warehouses Select the warehouse.
Databases Select the database.
Schemas Select the schema.
Database Objects Choose the database object.
Tables Select the table.
Views Select the view.
Table Column Names Select which table columns you would like included in your report.
View Column Names Select the view columns that you would like to include in your report.
Table Query Helper Generated query based on the selected fields.
View Query Helper A query is generated based on the selected fields.
Query Enter the SQL query to execute.
Partition Criteria Select whether you want to partition your data using the date keys, non-date keys, or meta query.
Select Partition Date Key Column Name Select the partition column name.
Partition Column Name Select the partition column name. Only date fields will be shown in this discovery.
Enter Partition Date Key Column Name Enter the partition column name.
Past Days Enter the number of past days that you want to get data for. Value can be X, where X is a positive integer. For example: 30.
Date Format Select the required date format. By default, yyyy-MM-dd will be used.
Custom Date Format Enter the custom date format.
Select Partition Non Date Key Column Name Select the partition column name.
Partition Non Date Key Column Name Select a non-date key column name to partition the data. All the fields excluding Date fields will be shown in this discovery.
Enter Partition Non Date Key Column Name Enter the partition column name.
Partition Query to determine partition tags Enter the partition query to determine the distinct partition tags. The column containing the Date data is your partition column. Example: Select the Date from Table_Name.
Upsert Key Column(s) Enter the upsert key column name or a comma-separated list of upsert key column names. Required only when Update method is Merge.

​
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 Data Connector.