Overview
This guide walks you through connecting Triple Whale to your Snowflake account using your Snowflake username and password. Once connected, you can use Snowflake as a destination in Workflows to export your Triple Whale data for analysis and custom reporting. This is the simplest of the three connection methods. If you prefer a token or key-based setup, see the related articles at the end.
Before you begin
A Snowflake account with a username and password you can sign in with.
The warehouse, database, and schema you want Triple Whale to write to.
Step 1 — Gather your details from Snowflake
Before opening the Triple Whale form, collect each of the following from your Snowflake account. You will paste these into Triple Whale in the next step.
Field | Where to find it in Snowflake |
Account ID | Open the Account Settings menu and copy your Account URL. It resembles |
Warehouse | The Snowflake warehouse you want to use to process the data. [VERIFY: confirm where users locate available warehouses, for example the Warehouses list or SHOW WAREHOUSES.] |
Database | The database into which Triple Whale may pass data. |
Schema | The schema within the selected database. |
Username | Your Snowflake account username. |
Role | The role used (e.g. ACCOUNTADMIN) |
Password | Your Snowflake account password. |
AccountId
Locate your Account URL from the Account Settings menu. It will resemble something like
PF05357.us-central1.gcp.snowflakecomputing.com)
Warehouse
Select the Snowflake warehouse you would like to use for processing the data
Database
Select which of your Databases in Snowflake into which Triple Whale may pass data.
Schema
Select which Schema within the selected Database you would like to use.
Username
This is your Snowflake account username
Password
This is your Snowflake account password
Step 2 — Enter your details in Triple Whale
In Triple Whale, go to Data > Integrations.
Locate Snowflake and click Connect.
Keep the default Username/Password option.
In Account ID, paste the Account URL you copied earlier.
Select your Warehouse.
Select your Database.
Select your Schema.
Enter your Username.
Enter your Role.
Enter your Password.
Click Save.
