Saltar al contenido principal
waffle.svg
Domo

Snowflake Connector

Version 2

 

Important: When referencing this page outside of Knowledge Base, use this link: http://knowledge.domo.com?cid=snowflake

Intro

Snowflake is data warehouse that makes it easy to bring together all your data and make it available to all of the users and systems that need to analyze it. You can use Domo's Snowflake connector to retrieve data from a specified warehouse, database, and database schema by inputting an SQL query. For more information about the Snowflake API, go to https://docs.snowflake.net/manuals.

The Snowflake connector is a "Database" connector, meaning it retrieves data from a database using a query. In the Data Center, you can access the connector page for this and other Database connectors by clicking Database in the toolbar at the top of the window.

This topic discusses the fields and menus that are specific to the Snowflake connector user interface. For general information about adding DataSets, setting update schedules, and editing DataSet information, see Adding a DataSet Using a Data Connector.

Prerequisites

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

  • Your Snowflake account name (domain). This is the portion of your Snowflake URL immediately following https://, e.g. https://[mycompany].snowflakecomputing.com.

  • The username and password for your Snowflake account.

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 the account name for your Snowflake account. For information about finding your account name, see "Prerequisites," above.

Username

Enter the username associated with your Snowflake account.

Password

Enter the password associated with your Snowflake account.

After you have entered valid Snowflake credentials, you can use the same account in Domo any time you create a 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 number of fields and menus for entering your SQL query and specifying the location of the data you want to retrieve.

Parameter

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.