Integrating Gong data with Snowflake
Who can do this?
Your Gong data contains a rich set of analytical data which you may want to utilize for your own analytics and reporting. The data is available to you in a Snowflake database which you can connect to using Snowflake Secure Sharing. Once connected, you can make the data available to employees who don't use Gong, and allow integrative analysis with other systems such as Salesforce. You must have a Snowflake data warehouse in order to access the Gong Snowflake database.
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:
-
Click Company settings > Data Cloud > Snowflake.
-
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:
-
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.
-
-
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.
-
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 <ORG_NAME.ACCOUNT_NAME.CUSTOM_SHARE_NAME> GRANT IMPORTED PRIVILEGES ON DATABASE GONG TO ROLE <customer_role_name>;