* The username and password used to connect to your Snowflake host.
* Your AWS access key. This is available in the AWS Console in the **Security Credentials** section (unless you are using IAM, in which case it is under **Users**).
* Your AWS secret key. This was provided when you created your access key. You can generate a new key in the AWS Console.
* The name of the AWS S3 bucket in which Snowflake data will be unloaded.
* The following Permissions are required:
| Permission Field | Description |
Create Stage | Creates a new stage to unload data from tables into files. |
| Copy into \ | Command to unload all the rows from a table into one or more files into the stage. |
| Create file format | Create file format. |
| LIST | Returns a list of files that have been staged. |
| GET | Downloads data files from the above created Snowflake stage. |
| REMOVE | Removes files that have been staged - unloaded from a table. |
Field | Description |
|---|---|
Account Name | Enter your Snowflake account name. For more information, see "Prerequisites." |
Username | Enter the username you use to connect to your Snowflake host. |
Password | Enter the password you use to connect to your Snowflake host. |
Access Key | Enter your AWS access key. For information about obtaining an access key, see "Prerequisites," above. |
Secret Key | Enter your AWS secret key. For information about obtaining a secret key, see "Prerequisites," above. |
Bucket | Enter the name of the AWS S3 bucket. |
Region | Select your S3 bucket region . |
Role | Enter your role. |
Menu | Description | ||||||
|---|---|---|---|---|---|---|---|
| How would you like to import data into Domo? | Select whether you want to import your data by using the standard update method (replace/append), by using partition, or upsert mode. | ||||||
| How would you like to build your Query? |
| ||||||
| Warehouses | Select the warehouse containing the data you want to retrieve. The list populates all warehouses you have access to based on your credentials. | ||||||
| Databases | Select the database containing the data you want to retrieve. The list populates all databases you have access to based on your credentials. | ||||||
| Schemas | Select the database schema containing the data you want to retrieve. The list populates all schemas you have access to based on your credentials. | ||||||
| Tables | Select the database table you want to retrieve. The list populates all tables you have access to based on your credentials. If you do not select a database table, the connector retrieves your entire database schema. | ||||||
| Table Column Name | Select the partition column name. | ||||||
| Table Query Helper | A query is generated based on the selected fields. Copy and paste this text into the QUERY field. You may edit this query, if desired. | ||||||
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 meta query. | ||||||
| Select Partition Date Key Column Name | Select the partition column name. Only date fields will be shown in this discovery. | ||||||
| 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. Example: 30. | ||||||
| Date Format | Please select/enter proper date format according to the date format present in partition column. By default yyyy-MM-dd will be used. | ||||||
| Custom Date Format | Enter the custom date format. | ||||||
| Select Partition Non Date Key Column Name | Select a non-date key column name to partition the data. All fields excluding Date fields will appear in this dropdown. | ||||||
| Enter Partition Non Date Key Column Name | Enter a non-date key column name to partition the data. | ||||||
| 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 | ||||||
| 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 . |
* If you select 'Upsert' in the Details section, then you need to select 'Merge' update mode in the Scheduling section.
### 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](/s/article/360042926274).
## FAQs