Snowflake is an analytic data warehouse provided as Software-as-a-Service (SaaS). Snowflake provides a data warehouse that is faster, easier, and flexible to use.
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)