Skip to main content

​
Intro

Snowflake is a data warehouse built for the cloud for all data and users. Use Domo’s Snowflake Unload V2 Connector to unload data from your Snowflake account 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. To learn more about the Snowflake Domo Managed High Bandwidth API, see (https://docs.snowflake.com/en/api-reference ). You can connect to your Snowflake Domo Managed High Bandwidth account in the Data Center. This topic discusses the fields and menus specific to the Snowflake Domo Managed High Bandwidth connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Data Connector.

​
Prerequisites

To connect to your Snowflake Domo Managed High Bandwidth account and create a DataSet, you must have the following:
  • Snowflake Account Name
  • Username
  • Password

​
Connecting to Your Snowflake Domo Managed High Bandwidth Account

This section enumerates the options in the Credentials and Details pane in the Snowflake Domo Managed High Bandwidth Connector page. The components of other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in great detail in Adding a DataSet Using a Data Connector.

​
Credentials Pane

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

Field

Description

Snowflake 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 .

Username

Enter the username associated with your Snowflake host.

Password

Enter the password associated with your Snowflake host.

Role

Enter your role.

Once you have entered valid Snowflake Domo Managed High Bandwidth credentials, you can use the same account any time to create a new Snowflake Domo Managed High Bandwidth 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 the way you want to import your data.
Query Type
Query Type Description
Custom Query Enter the SQL query to execute.
Query Builder Select 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 the table columns to be included in your report.
View Column Names Select the view columns to be included in your report.
Table Query Helper Generates the 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 if you want to partition your data using the date keys, non-date keys, or meta query.
Partition Date Key Table Column Name Select the partition column name.
Partition Date Key View Column Name Select the partition column name. Only date fields appears.
Enter Partition Date Key Column Name Enter the partition column name.
Past Days Enter the number of past days that you want to fetch the data for. Value can be X, where X is a positive integer. For example, 30.
Date Format Select the required date format. The default format is (YYYY-MM-DD) .
Custom Date Format Enter the custom date format.
Partition Non Date Key Table Column Name Select the partition column name.
Partition Non Date Key View Column Name Select a non-date key column name to partition the data. All the fields excluding Date fields appears.
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. For example, select Date from Table_Name.
Upsert Key Column(s) Enter 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.