--- title: "Configure Snowflake as a Source" slug: "configure-snowflake-as-a-source" description: "Set up Snowflake as a data source in RevSure to unify GTM data pipelines and enable scalable full-funnel analysis." updated: 2026-05-12T15:22:51Z published: 2026-05-12T15:22:51Z canonical: "documents.revsure.ai/configure-snowflake-as-a-source" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.revsure.ai/llms.txt > Use this file to discover all available pages before exploring further. # Configure Snowflake as a Source #### Overview: Snowflake can be used as a source for users who have high security demands and apprehensions regarding sharing credentials or providing access to the CRM data. You can integrate Snowflake as a source and set up workflows in which you can decide what tables/data you want to import into Revsure for ingestion. #### Steps to Setup 1. Navigate to **Revsure** App Instance ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(375).png) 1. Click "**Data Hub**" ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(378).png) 1. Click "**Data Sources**" ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(380).png) 1. In a new tab, navigate to [**https://app.snowflake.com/**](https://app.snowflake.com/) 2. Navigate to a SQL Worksheet and run the following command to add Revsure Integration **US :** ***CREATE SECURITY INTEGRATION REVSURE TYPE = OAUTH ENABLED = TRUE OAUTH_CLIENT = CUSTOM OAUTH_CLIENT_TYPE = 'CONFIDENTIAL' OAUTH_REDIRECT_URI = 'https://gw.revsure.cloud/data-hub/v1/oauth/callback' OAUTH_ISSUE_REFRESH_TOKENS = TRUE OAUTH_REFRESH_TOKEN_VALIDITY = 7776000;*** EU : ***CREATE SECURITY INTEGRATION REVSURE TYPE = OAUTH ENABLED = TRUE OAUTH_CLIENT = CUSTOM OAUTH_CLIENT_TYPE = 'CONFIDENTIAL' OAUTH_REDIRECT_URI = 'https://gw.revsure-eu.cloud/data-hub/v1/oauth/callback' OAUTH_ISSUE_REFRESH_TOKENS = TRUE OAUTH_REFRESH_TOKEN_VALIDITY = 7776000;*** ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(384).png) 1. Execute the Query ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(385).png) 1. After Integration is created, run the following command ***SELECT PARSE_JSON(SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('REVSURE')):OAUTH_CLIENT_ID::STRING AS client_id, PARSE_JSON(SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('REVSURE')):OAUTH_CLIENT_SECRET::STRING AS client_secret;*** ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(386).png) 1. Retrieve **Client ID** ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(387).png) 1. **Client Secret** ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(388).png) 1. Next, we also need the custom Instance URL for the connection. Execute the following query : SELECT 'https://' || CURRENT_ORGANIZATION_NAME() || '-' || CURRENT_ACCOUNT_NAME() || '.[snowflakecomputing.com](http://snowflakecomputing.com)' AS custom_instance_url; ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(390).png) 1. Back onto the Revsure App Data Hub, Click **Add New** ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(389).png) 1. Select **Snowflake** from the list of Sources ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(392).png) 1. Set the "**Connection Name**" field. ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(395).png) 1. Fill your instance URL in the "**Custom URL**" field. ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(397).png) 1. Set the "**Warehouse**" field. ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(407).png) 1. From the Snowflake, use the retrieved information to set the "**Client Id**" and "**Client Secret**" fields. ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(409).png) 1. Click "**Connect**" ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(416).png) 1. This takes you to "**Sign in to Snowflake to authorize REVSURE**" ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(419).png) 1. Click **here**. ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(422).png) 1. Use your credentials to authorize the same. ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(423).png) 1. A message of "**Authorization successful**" would be received 2. The Connection is created. The details can be seen on the Configuration Tab. Move to the **Workflow** tab to set up the workflows for the Extraction of Tables ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(425).png) 1. Click "**New Workflow**" ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(426).png) 1. Choose the **Database Schema**. ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(429).png) 1. Select the **Tables** you wish to pull ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(430).png) 1. Select the **Columns** of the table you wish to pull ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(431).png) 1. Select the **Primary Key** (Essential for Delta Syncs) ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(432).png) 1. Under Sync Setting, **Full** and **Delta** Options are Available. ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(440).png) 1. If **Delta** is selected, a Date/Timestamp Column for Delta should be selected ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(441).png) 1. Click on the **Dropdown** and choose the Column ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(443).png) 1. Give the Workflow a Name. Set Historical Date from the Date Widget - From where you want data to be pulled. Also Frequency for the time for Sync. ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(462).png) 1. Type "Daily Workflow" 2. Click "Save" ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(473).png) 1. At Save, there would be 2 Options - Sync Now and Sync Later. Sync Now - Triggers a Sync right away. Sync Later - The next Sync would start at the Selected Frequency. ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(499).png) 1. You can check the Status and Other Live information at the Workflow Summary now. ![](https://cdn.document360.io/1ba0d15e-f1ca-43db-aba7-8e6b7d8766f9/Images/Documentation/image(500).png)