Snowflake integration

This integration allows you to connect and pull data from Snowflake into your data notebooks.

In this guide:

• Prerequisites
• Connecting Snowflake
• Pulling data from Snowflake

Prerequisites

To connect Snowflake with your data notebooks you need to have the following:

• Snowflake account and ownership permissions
• Intersect account and owner access level

Connecting Snowflake

You can add the Snowflake integration from the Dashboard  > Integrations > Add integrations > Add Snowflake.

One-click on the Snowflake box and the connection portal will open. These are the fields that are required for the connection to be successful:

• Integration name
• Username
• Account
• Warehouse
• Database
• Schema
• Password

Here are more details on how to find the needed information for this integration:

1. The Integration name is your name for the integration in Intersect. Name it as you wish.
2. In the username field, you should add the username that you use to login into Snowflake
3. The account value is the hostname you received from Snowflake. Your account name is the full/entire string to the left of snowflakecomputing.com. In the screenshot below, the account name is “hqa02240”.
   
   
   
   
4. The warehouse field should contain the name of the warehouse you are connecting to Intersect.
   
   
   
   
5. The database field should contain the name of the database you are connecting to Intersect.
   
   
   
   
6. The schema field should contain the name of the schema that belongs to the database you are connecting.
   
   
   
   

   You can then proceed to fill the connection portal in Intersect. If the connection is successful, you should be able to see your new Snowflake integration on your Integrations page. 

Pull data from Snowflake

After you configure your Snowflake integration, you can import your performance data into your notebook. To do that, click Import data > Data Warehouse > Read from Snowflake (Add).

Once you select the integration, a new “Read from Snowflake” step will be added to your data notebook. To successfully pull data you will need to select your Snowflake integration (in our case it’s called: My Snowflake Integration). Then, a drop-down list with schemas will appear, allowing you to choose the one you want to import. Finally, you can add a custom SQL query to fetch a specific part of your data.

If the step is successfully configured you will see an output with your sourced table.