Skip to main content
waffle.svg
Domo Knowledge Base

Snowflake Unload Connector

Intro

Snowflake is a cloud-based analytic data warehouse system. You can use Domo's Snowflake Unload Connector to unload data from your Snowflake database into Amazon S3. The files are then downloaded from S3 into Domo. You should use this connector instead of the standard Snowflake connector if you are executing very large queries. To learn more about the Snowflake API, visit their page (https://docs.snowflake.net/manuals).

You connect to your Snowflake account in the Data Center. This topic discusses the fields and menus that are specific to the Snowflake Unload connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.

Prerequisites

To connect to your Snowflake account and create a DataSet, you must have the following:

  • Your Snowflake account name.

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

Connecting to Your Snowflake Account

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

Credentials Pane

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

Field

Description

Account Name

Enter your Snowflake account name.

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.

Once you have entered valid Snowflake credentials, you can use the same account any time you go to create a new Snowflake 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

Query

Enter the SQL query to use to retrieve your data. You can use the Query Helper parameter to help you write a usable SQL query. To use the Query Helper, do the following:

  1. Select your desired warehouse, database, database schema, database table, and table columns in each menu.

  2. Copy the SQL statement that appears in the Query Helper field.

  3. Paste the copied SQL statement into the Query field.

Warehouses (Optional)

Select the warehouse containing the data you want to retrieve.

Databases (Optional)

Select the database containing the data you want to retrieve.

Database Schema (Optional)

Select the database schema containing the data you want to retrieve.

Database Tables (Optional)

(Optional) Select the database table you want to retrieve. If you do not select a database table, the connector retrieves your entire database schema.

Table Columns (Optional)

(Optional) Select the table columns you want to retrieve. If you do not select a table column, the connector retrieves your entire selected database table.

Query Helper (Optional)

(Optional) Copy and paste the SQL statement in this field into the Query field. For more information, see Query, above.

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.