Skip to main content

​
Intro

Snowflake enables organizations to collaborate, build AI-powered data apps, and unlock data insights—all within a secure and scalable AI Data Cloud. Leverage Snowflake’s unload technology into internal staging, and Domo’s advanced update methods such as partitioning on all column types, to quickly and reliably ingest your data into Domo. You can connect to your Snowflake Key Pair High Bandwidth Advanced Partitions account in the Data Center. This topic discusses the fields and menus that are specific to the Snowflake Key Pair High Bandwidth Advanced Partitions 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 High Bandwidth Advanced Partitions account and create a DataSet, you need the following:
  • Account name (provided by Snowflake)
  • Username associated with your Snowflake host.
  • Private Key

​
Connecting to Your Snowflake Key Pair High Bandwidth Advanced Partitions Account

This section enumerates the options in the Credentials and Details panes on the Snowflake Key Pair High Bandwidth Advanced Partitions 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 High Bandwidth Advanced Partitions 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 .
Username Enter the username associated with your Snowflake host.
Private Key Enter the Private Key.
PassPhrase If you create an encrypted private key, then OpenSSL prompts for a passphrase which is used to encrypt the private key file. Enter that PassPhrase here.
Role Enter your role.
Once you have entered valid Snowflake Key Pair High Bandwidth Advanced Partitions credentials, you can use the same account at any time to create a new Snowflake Key Pair High Bandwidth Advanced Partitions 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

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 Please choose the database object.
Tables Select the table.
Table Columns Select the table columns that you would like to include in your report.
Table Query Helper Generated query based on the selected fields.
Views Select the view.
View Columns Select the view columns that you would like to include in your report.
View Query Helper Generated query based on the selected fields.
Query Enter the SQL query to execute.
Partition Criteria Select the Partition Criteria.
Partition Query to determine partition tags Enter the partition meta query to determine the distinct partition tags(or keys). The column containing the Date data is your partition column. Example: SELECT DISTINCT(DATE_COLUMN_NAME) FROM TABLENAME
Partition Support Format Select the partition format.
Partition Column Name Select the partition column name.
Past Years Enter the number of past years that you want to get data for. Value can be X, where X is a positive integer. For example: 30.
Future Years Enter the number of future years that you want to get data for. Value can be X, where X is a positive integer. For example: 30.
Past Months Enter the number of past months that you want to get data for. Value can be X, where X is a positive integer. For example: 30.
Future Months Enter the number of future months that you want to get data for. Value can be X, where X is a positive integer. For example: 30.
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.
Partition Non Date Key Column Name Select the partition column name.
Partition Column Name Enter the partition column name.

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