Skip to main content

​
Intro

Snowflake is a cloud-based data warehouse designed to support all your data and users. If you need to execute very large queries and move the results to Domo, use the Snowflake Key Pair Domo Managed Connector.
  • This connector first unloads data from your Snowflake instance into an Amazon S3 bucket.
  • The unloaded files are then automatically imported from Amazon S3 into Domo.
Note: Choose this connector as the preferred method over the standard Snowflake connector when processing extremely large query result sets. You can connect to your Snowflake Key Pair Domo Managed Unload account in the Data Center. This topic discusses the fields and menus that are specific to the Snowflake Key Pair Domo Managed Unload connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Connector.

​
Prerequisites

To connect to your Snowflake Key Pair Domo Managed Unload account and create a DataSet, you need the following:
  • Account Identifier
  • Username
  • Private Key

​
Connecting to Your Snowflake Key Pair Domo Managed Unload Account

This section enumerates the options in the Credentials and Details panes on the Snowflake Key Pair Domo Managed Unload Connector page. The components of the other panes on 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 Connector.

​
Credentials Pane

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

Field

Description

Account Identifier

Specify the name of your Snowflake account based on its region:

  • US West Region: Use the format account_name .

  • All Other Regions: Use the format account_name.region_id .

Username Enter the username to connect to your Snowflake host.
Private Key Enter the Private Key.
Passphrase

If you choose to create an encrypted private key, OpenSSL will prompt you to enter a passphrase . This passphrase is used to encrypt the private key file. Enter the required passphrase when prompted.

Role

Enter your role.

Once you have entered valid Snowflake Key Pair Domo Managed Unload credentials, you can use the same account at any time to create a new Snowflake Key Pair Domo Managed Unload DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Manage Connector Accounts.

​
Details Pane

Menu

Description

How would you like to import data into Domo?

Select any one of the methods below to import your data into Domo.

  • Standard Update
  • Use Partition
  • Use Upsert
Query Type

Select the query type from the drop-down list.

QueryType Description
Custom Query Enter the SQL query you want to execute.
Query Builder Select a table and the 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 you want to include in your report.

View Column Names

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

Table Query Helper

Enter the generated query based on the selected fields.

View Query Helper

A query is generated based on the selected fields.

Query

Enter the SQL query you want to execute.

Partition Criteria

Select whether you want to partition your data using the date keys, non-date keys, or a 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 will be displayed.

Enter Partition Date Key Column Name

Enter the partition column name.

Past Days

Enter the number of past days for which you want to retrieve the data. This value must be a positive integer (e.g., 30).

Date Format

Select the required date format. By default, yyyy-MM-dd will be used.

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, will be displayed.

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 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 the 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 Connector.