Skip to main content

​
Intro

By combining the power of Domo with your Snowflake data warehouse, you can unlock even more data value and democratize data for your business. The Domo Snowflake Enterprise OAuth connector makes it easy to securely bring your data from your Snowflake data warehouse into Domo. 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 Enterprise 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 your other Domo data to get a centralized view of your 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 Data Connector.

​
Prerequisites

To connect to your Snowflake Enterprise OAuth account and create a DataSet, you must have the following:
  • Account Name
  • Role

​
Connecting to Your Snowflake Enterprise OAuth Account

The Snowflake Enterprise OAuth Connector uses the new Enterprise OAuth Configurations feature to complete the Enterprise OAuth process. To know more about the Enterprise OAuth Configurations process, see Enterprise OAuth Process. This section enumerates the options in the Credentials and Details panes in the Snowflake Enterprise OAuth 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 great detail in Adding a DataSet Using a Data 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

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 Managing User Accounts for Connectors.

​
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 Please choose the database object.
Tables Select the table.
Table Columns Select the table columns that you would like to include in your report.
Table Query Helper This field shows the query that is 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 memory performance. If this field is blank, by default 1000 will be used. If dataset throws an out of memory error, try decreasing 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 Data Connector.