Connect Gong to Snowflake

Who can do this? Tech admin

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. Click Company settings > Data Cloud > Snowflake.

2. 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 ap_south_1

     • AWS ap-southeast-1

     • AWS ap-southeast-2

     • AWS ca-central-1

     • AWS eu-central-1

     • AWS us-east-1

     • AWS us-east-2

     • AWS us-west-2

     • AWS eu-west-1

     • AWS eu-west-2

     • AWS eu_west_3

     • AZURE azwestus2

     • AZURE centralus

     • AZURE europewest

     • AZURE northeurope

     • AZURE useast2

     • GCP europe-west4

     • GCP us-central1 

   • Snowflake admin email (optional): 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.

3. 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.

4. 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 ;