Snowflake: Enabling the Integration
IMPORTANT - Articles Impacted due to 6.34 October NXT Release
Due to the v6.34 October, 2022 release, this article has been impacted. Steps, images, and playable GIFs in this article will soon be updated to reflect the latest changes.
For more information about the latest UI changes, click here.
IMPORTANT NOTE: Gainsight is upgrading Connectors 2.0 with Horizon Experience. This article applies to tenants which are yet to be upgraded to the Horizon Experience of Connectors 2.0. If you are using Connectors 2.0 with Horizon Experience, you can find the documentation here.
Snowflake is an analytic data warehouse provided as Software-as-a-Service (SaaS). It allows corporate users to store and analyze data using cloud-based hardware and software.
This article explains how to integrate Gainsight with Snowflake database. When a Snowflake connection is established from Gainsight, you can add Snowflake as a data source and use source data from the Tables to analyze and create Dataspaces in Data Designer, and also you can create Usage Reports in Adoption Explorer. For more information, refer to the Use Data from Snowflake in Data Designer and Configure Adoption Explorer Objects articles.
Business Use Case: If your organization’s IT infrastructure uses Snowflake to store business data, this connection helps you build reports on this data in Gainsight and combine this data with other customer information and create datasets in Data Designer.
Create Snowflake Connection
To create a Snowflake connection:
- Navigate to Connectors 2.0 > CONNECTORS.
- Click the Snowflake Connection widget.
- Click Create Connection. Add Connection dialog appears.
- Enter details in the following fields:
IMPORTANT: Contact your Database Administrator to obtain the following details.
- Connection Name
- Database Name
- SSL Enabled (Checkbox)
Note: Gainsight limits the data we get from the above details, by adhering to any Access Controls defined in Snowflake.
- Click TEST CONNECTION to confirm whether the connection works.
Note: If there are any errors in the entered connector details, the system displays the respective error message.
- Click CREATE.
Note: You can establish as many Snowflake connections as you need.
You can click View Connection Logs to see logs of the already established connections. You can see the following details of each connection:
- Connection Name
- Modified on
- Old Value (of the Attribute)
- New Value (of the Attribute)