> ## Documentation Index > Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # Snowflake Key Pair Domo Managed Unload connector ## 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](https://domo-support.domo.com/s/article/360042926274?language=en_US "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](https://domo-support.domo.com/s/article/360042926274?language=en_US "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](https://domo-support.domo.com/s/article/360042926054?language=en_US "Manage Connector Accounts"). ## Details Pane

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](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Connector").