Connect Gong to Snowflake

Who can use this: Tech admin
Available on: Data Cloud

To connect Gong to Snowflake, you need to provide your account details in Gong, wait for the connection to be confirmed and then set up the database in Snowflake.

To set up the integration in Gong:

1. Go to Admin center > Settings > Data cloud > Data cloud settings.

2. Select Snowflake.

3. Enter your Snowflake credentials:

   • Account locator: the identifier for the Snowflake account you want Gong data to be available from.

   • Account region: available from your Snowflake admin. If the account region is not included in the list, the region is not currently supported. You can ask us to add the region and we will let you know when your region is supported.

     Supported regions are:

     • AWS_US_WEST_2

     • AWS_US_EAST_1

     • AWS_AP_SOUTHEAST_2

     • AWS_EU_WEST_1

     • AWS_AP_SOUTHEAST_1

     • AWS_CA_CENTRAL_1

     • AWS_EU_CENTRAL_1

     • AWS_US_EAST_2

     • AWS_AP_SOUTH_1

     • AWS_EU_WEST_2

     • AWS_EU_WEST_3

     • AZURE_EASTUS2

     • AZURE_WESTEUROPE

     • AZURE_WESTUS2

     • AZURE_SWITZERLANDN

     • AZURE_CENTRALUS

     • AZURE_NORTHEUROPE

     • GCP_US_CENTRAL1

     • GCP_EUROPE_WEST4

     • GCP_EUROPE_WEST3

   • Snowflake admin email: The email address of the Snowflake administrator in your company. We will send instructions to be done in Snowflake to complete the integration to this email address.

4. Click Connect. It may take a few hours to complete the connection. You and your Snowflake admin will get an email when the connection is complete.

5. Once the connection is confirmed, generate the command query and run it.

   Note:

   By running this query, you are agreeing to Snowflake's terms and conditions.

   use role accountadmin;
   CALL SYSTEM$ACCEPT_LEGAL_TERMS('DATA_EXCHANGE_LISTING','GZT0Z123IQGM');show shares like '%GONG%';
   
   set database_name = 'GONG';
   show shares like '%GONG%';
   //Generates the command
   SELECT ‘CREATE DATABASE ' || $database_name || ' FROM SHARE ' || "owner_account" || '.' ||
   "name" FROM TABLE(RESULT_SCAN(LAST_QUERY_ID())); 
   
   The generated command: 
   CREATE DATABASE GONG FROM SHARE 
   GRANT IMPORTED PRIVILEGES ON DATABASE GONG TO ROLE ;