Connect Snowflake to WasteNot to pull data directly from your warehouse. Write simple queries to define exactly what data you need for building audiences.

Prerequisites

• A Snowflake account
• Someone with permission to create roles and users in Snowflake
• Your Snowflake account identifier (your organization and account name, e.g., myorg-myaccount)

Connecting Snowflake

Setup has two steps: creating the data source in WasteNot, then configuring access in your Snowflake account.

Step 1: Create the data source

1. Add a new Snowflake data source in WasteNot
2. Enter a Name
3. Click Save

Step 2: Set up access and connect

After creating the data source, go to its detail page. You will see a form and setup instructions.

Fill in the following fields:

• Snowflake Account Name — Your account identifier including organization (e.g., myorg-myaccount)
• Snowflake Warehouse — The warehouse WasteNot should use to run queries
• Snowflake Database — The database WasteNot should query
• Snowflake Role — The role WasteNot will use for access (e.g., WASTENOT_ROLE)
• Snowflake Username — The user WasteNot will log in as (e.g., WASTENOT_USER)

The page also shows SQL commands to run in Snowflake. These will:

1. Create a dedicated role for WasteNot
2. Grant it read access to your warehouse and database
3. Create a dedicated user and assign the role
4. Configure secure authentication so WasteNot can connect without storing passwords

Your engineering or data team can copy and run these commands in the Snowflake console.

Once Snowflake is set up and the fields are filled in, click Connect.

Custom streams

Once connected, you can create streams to define what data WasteNot pulls from Snowflake. Each stream is a SQL query that returns rows matching WasteNot's expected format.

See the Writing Custom Queries guide for full details on how to structure your queries, required columns, and event types.

1. Go to your Snowflake data source detail page
2. Click New Stream
3. Give the stream a name, select an event type, and enter your SQL query
4. Save the stream

WasteNot will run the query on a schedule and sync the results automatically.

Frequently asked questions

Who on my team should set this up?

Anyone with admin access to your Snowflake account who can create roles and users. This is typically someone on your engineering or data team.

Can I change the warehouse or database later?

Yes. Edit the data source from its detail page to update connection settings.

My data source shows "Failed" status

Common causes include the Snowflake user or role being disabled, or the authentication not being configured correctly. Check with your data team, or reach out to support@wastenot.io for help.