Snowflake integration

Connect TheyDo to Snowflake to pull warehouse data into your metrics. Once set up, you can write SQL queries to define your metrics and have them update automatically from your Snowflake data.

Before you start

  • You need integration-management permission in TheyDo.
  • You should have a Snowflake service account with at least USAGE privileges on the database.
  • TheyDo uses key pair authentication to connect to Snowflake. Confirm this method is compliant with your company's security policies.
  • Your data team should whitelist TheyDo's IP addresses (see below).
  • Have your Snowflake data team on hand during setup — you'll need to run a command in Snowflake as part of the process.

Tip: Before starting, prepare a table in Snowflake that follows TheyDo's data format requirements (see "Prepare your data" below). This will make the setup process smoother.

How to set up the Snowflake integration

Step 1: Enter your Snowflake connection details

  1. Go to Settings > Integrations in TheyDo.
  2. Find Snowflake under Data integrations and select Enable.
  3. Fill in the following fields (your data team can help retrieve these):
    • Instance Name — a name for this connection in TheyDo
    • Host
    • Database Name
    • Warehouse Name
    • Account
    • Username

Step 2: Generate a public key

  1. Once all fields are filled, click Generate public key.
  2. TheyDo will display an RSA Public Key and a command to run in Snowflake.

Step 3: Authorize in Snowflake

  1. Open Snowflake and go to Query Data.
  2. Copy the SQL command from TheyDo and run it in the Snowflake editor.
  3. Once you receive a success message, return to TheyDo.
  4. Check the box "I have run the ALTER USER command in Snowflake".
  5. Click Test & Authorize to complete the connection.

Whitelist TheyDo's IP addresses

Your data team needs to whitelist the following IP addresses so TheyDo can connect to Snowflake:

Region IP addresses
US (us-west-2) 35.84.98.216, 54.244.86.126, 35.80.222.253
Europe (eu-west-1) 54.195.123.180, 108.128.79.6, 99.80.158.204

Prepare your data in Snowflake

Your Snowflake tables must return the correct columns for each metric type:

Metric type Required columns
CSAT date, positives, negatives, respondents
CES date, respondents, value
NPS date, detractors, promoters, respondents
RATIO date, numerator, denominator
OTHER date, value

Supported data types:

  • Date columns: DATE
  • Metric value columns: INTEGER, FLOAT, or NUMERIC

Column aliasing: If your table uses different column names, you can use SQL aliasing in your query. For example:

sql

SELECT det AS detractors, ... FROM project_id.dataset_id.your_table_name

For enterprise teams with stricter security requirements, TheyDo supports connecting via Snowflake PrivateLink. This keeps data traffic off the public internet.

  • Requires a Business Critical Snowflake edition or higher.
  • Involves additional setup on both the Snowflake and cloud infrastructure side.

If you're interested in PrivateLink, reach out to your Customer Success Manager.

Security and storage

  • Data is stored on Azure (EU).
  • TheyDo stores partial Snowflake data for up to 60 days to display metrics.
  • Data is encrypted at rest.
  • More information is available at trust.theydo.com.