Snowflake Integration

Zero-copy ingestion and secure data sharing.

Overview

SpendSignal connects directly to your Snowflake warehouse to ingest revenue data, offline conversions, and custom event streams. We support standard user/password authentication as well as Key Pair authentication for enhanced security.

Prerequisites

A Snowflake account with ACCOUNTADMIN or SECURITYADMIN privileges (to create a dedicated user).
A warehouse (e.g., COMPUTE_WH) for compute resources.
Database and Schema containing the tables you wish to sync.

Setup Guide

Create a Dedicated User

Run the following SQL in a Snowflake Worksheet to create a specific user for SpendSignal.

-- Create role
CREATE ROLE SPENDSIGNAL_ROLE;

-- Create user
CREATE USER SPENDSIGNAL_USER 
  PASSWORD = 'your_strong_password_here' 
  DEFAULT_ROLE = SPENDSIGNAL_ROLE 
  DEFAULT_WAREHOUSE = COMPUTE_WH;

-- Grant role to user
GRANT ROLE SPENDSIGNAL_ROLE TO USER SPENDSIGNAL_USER;

Grant Privileges

Grant read access to the specific tables you want SpendSignal to see.

-- Grant usage on warehouse
GRANT USAGE ON WAREHOUSE COMPUTE_WH TO ROLE SPENDSIGNAL_ROLE;

-- Grant usage on database and schema
GRANT USAGE ON DATABASE ANALYTICS TO ROLE SPENDSIGNAL_ROLE;
GRANT USAGE ON SCHEMA ANALYTICS.PUBLIC TO ROLE SPENDSIGNAL_ROLE;

-- Grant select on tables
GRANT SELECT ON TABLE ANALYTICS.PUBLIC.REVENUE_EVENTS TO ROLE SPENDSIGNAL_ROLE;

Connect in Dashboard

Go to Integrations and select Snowflake. Enter the Account Identifier, User, Password, Warehouse, Database, and Schema details.

Next Steps

Need Help?

Check out Snowflake's official documentation on user management or contact our support team.