This integration with Snowflake allows the user to send Data Packs (f.k.a. Standardized File Export (SFE)) data directly to your organization’s Snowflake instance via Data Loading to an Internal Named Stage.
Additional resources on Data Packs:
Prerequisites:
You must be a 6sense Data Packs customer.
Your organization must be using Snowflake internally.
You must contact your CSM, PC or Support to turn on this integration if eligible.
Once Snowflake has been configured as your organization’s Data Pack destination, by default we will no longer send the data to the SFTP server if you were previously using it.
To integrate Snowflake, navigate to Settings and select Snowflake from the list of integrations, under “Data Warehouse”.
.png)
In the top right of the integration page, click the Connect button.
Enter your Snowflake login information and click Sign in with Snowflake.
Property | Description |
|---|---|
Username | The username created to allow 6sense to access the database. Example: |
Password | The password associated with the username. |
Account Identifier: |
After successfully signing in, click Save & Next to configure the integration.
Configure the integration by entering the Snowflake metadata in the fields displayed. This information allows 6sense to validate and confirm the exact Snowflake endpoint location to send export data.
Property | Description |
|---|---|
The role created for 6sense to access Snowflake.Must have WRITE permissions to internal stage. Example: | |
The name of the warehouse to be used. Example: | |
The name of the database to be used. Example: | |
The name of the schema to be used. Example: | |
The name of the stage to put the data in. |
If needed, complete the optional step Table Sync. Here you have the ability to define which tables in Snowflake you would like to copy specific file data into.
The Purge checkbox to the right will remove the file from your Snowflake Internal Stage upon successfully syncing the data into the table.
Please note that the Snowflake tables specified within 6sense must already exist in Snowflake. We do not create the tables on your behalf. In addition, the number of table columns present in a given table must match that of the 6sense file. For example if a given 6sense file has 9 columns, the corresponding table must also have 9 columns for the copy to be successful. Finally, please ensure that the role created for 6sense also has WRITE permissions to the necessary tables.
Click Finish in the bottom right of the page to complete your integration.