Skip to main content

​
Intro

By combining the power of Domo with your Snowflake data warehouse, you can unlock more data value and make your data accessible to everyone in your business. The Domo Snowflake OAuth connector makes it easy to bring data from your Snowflake data warehouse into Domo securely. If you are already using Snowflake as a data warehousing solution, this connector helps you use Domo in conjunction to get the most from your data. With the OAuth connector for Snowflake, you can use your existing Snowflake account to access your data, including your Client ID and the Client Secret provided by Snowflake when you were registered. Once your Snowflake data is in Domo, you can combine it with all other Domo data to get a centralized view of the most mission-critical data.. You can connect to your Snowflake Enterprise OAuth account in the Data Center. This topic discusses the fields and menus that are specific to the Snowflake Enterprise OAuth connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Connector.

​
Prerequisites

To connect to your Snowflake Enterprise OAuth account and create a DataSet, you must have the following:
  • You need to select the OAuth Configuration
  • Enter the Account Name provided by Snowflake
  • You need to enter the Role

​
Connecting to Your Snowflake Enterprise OAuth Account

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

​
Credentials Pane

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

Field

Description

OAuth Configuration

OAuth Configurations has the service credentials stored by your administrator that automatically logs you in so that only your personal OAuth login is required. Your administrator may create and edit configurations in the Data Center, in the Accounts tab.

Account Name

Enter the full name of your account (provided by Snowflake).

Role

Enter your role.

Once you have entered valid Snowflake Enterprise OAuth credentials, you can use the same account any time to create a new Snowflake Enterprise OAuth DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Manage Connector Accounts.

​
Details Pane

Menu

Description

Query Type Select the query type.
Warehouses Select the warehouse.
Databases Select the database.
Database Schema Select the schema.
Query Enter a custom query.
Database Objects Choose the database object.
Tables Select the table.
Table Columns You can select the table columns that you would like to include in your report.
Table Query Helper This field shows the query generated based on the selected fields.
Views Select the view.
View Columns Select the view columns that you would like to include in your report.
Query Helper This field shows the query that is generated based on the selected fields.
Fetch Size Enter a fetch size for the memory performance. If this field is blank, by default the value 1000 will be used. If the dataset throws an out of memory error, then try to decrease the fetch size.
Convert BIGINT to LONG Select this check box if you want to convert the BIGINT columns to LONG.

​
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 Connector.

​
FAQs

To enable the connector to use the OAuth configuration, follow the below steps:
  1. Create a security integration in Snowflake. Use https://oauth.domo.com/api/data/v1/oauth/providers/snowflake-oauth-config-standard/exchange for the OAUTH_REDIRECT_URI value, and save the generated client id and secret.
  2. Create the OAuth Configuration by doing the following:
    1. Navigate to the Integration Accounts section of the Data Center using https://.domo.com/datacenter/accounts.
    2. On the top right corner, from the Add New drop-down, select OAuth Configuration.
      Add New Drop Down
    3. In the modal that appears, provide a name for the configuration.
    4. Select Snowflake OAuth Config from the Configuration Type drop-down and then enter the client id and secret obtained from step 1.
    5. Click Connect to create the configuration.
  3. Share the new OAuth Configuration with the users who need to power up this connector.
    1. Navigate to the OAuth Configurations tab in the Integrations Accounts section of the Data Center.
    2. Search for the OAuth Configuration created in Step 2.
    3. Click the wrench menu on the right side and select Share Account.
      Share Account
Now, you can share this configuration by selecting groups or individual users.
There are 2 possibilities:
  • An OAuth configuration does not exist yet. Contact your Domo admin to determine if an OAuth configuration exists.
  • An OAuth configuration exists but has not been shared with you. Contact your Domo admin to ensure that the OAuth Configuration you need has been shared with you.