Skip to main content
waffle.svg
Domo Knowledge Base

Snowflake Writeback Connector

  1. Last updated
  2. Save as PDF
Version 3

 

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 Writeback connector to push data from a Domo DataSet into a Snowflake database. For more information about the Snowflake API, go to https://docs.snowflake.net/manuals.

This topic discusses the fields and menus that are specific to the Snowflake Writeback 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:

  • The full name of your account (provided by Snowflake). This is the portion of your Snowflake URL immediately following https://.

    Note that your full account name may include additional segments that identify the region and cloud platform where your account is hosted. The following table provides account name examples by cloud platform/region. For each row, it assumes your account name is "xy12345."

    snowflake_account_names.png  

  • The username and password for your Snowflake account.

  • A Domo Client ID and Client Secret. To obtain these credentials, do the following:

    1. Log into your Domo developer account at https://developer.domo.com/login. 

    2. Create a new client. 

      Note: When creating a new client, if you utilize multiple Domo instances, make sure you're logged into the Developer Portal using the correct instance.  

    3. When creating the client, select the Data and User scopes.


      snowflake_writeback_new_client.png
       

    4. Click Create.

Configuring the connection

This section enumerates the options in the Credentials and Details panes in the Snowflake Writeback 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 your Domo developer account as well as 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. 

Username

Enter the username associated with your Snowflake account.

Password

Enter the password associated with your Snowflake account.

Role

Enter your role.

Domo Client ID

Enter your Domo client ID.

Domo Client Secret

Enter your Domo client secret.

After you have entered valid credentials, you can use the same account in Domo any time you create a Snowflake Writeback 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

Input DataSet ID

Enter the DataSet ID (GUID) for the DataSet you want to copy to Snowflake. You can find the ID by opening the details view for the DataSet in the Data Center and looking at the portion of the URL following datasources/. For example, in the URL https://mycompany.domo.com/datasources/845305d8-da3d-4107-a9d6-13ef3f86d4a4/details/overview, the DataSet ID is 845305d8-da3d-4107-a9d6-13ef3f86d4a4. 

Select Table Name

Select how you want to name the table where data will be copied. 

  • Use Input DataSet GUID. The table name will be the number you entered for Input DataSet ID.

  • Use Input DataSet Name. The table name will be the same as that of the input DataSet.

  • Enter Table Name. You will give the table a custom name in the Custom Table Name field.

Enter Table Name 

Enter the name of the Snowflake table you want your data copied to (spaces and special characters will be replaced with underscores). 

Warehouses

Select the warehouse containing the table you want to send data to.

Databases

Select the database containing the table you want to send data to.

Database Schema 

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

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.