Snowflake Writeback Connector
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."
-
The username and password for your Snowflake account.
-
A Domo Client ID and Client Secret. To obtain these credentials, do the following:
-
Log into your Domo developer account at https://developer.domo.com/login.
-
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.
-
When creating the client, select the Data and User scopes.
-
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.
|
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.