Connect Snowflake to your
customer knowledge graph
Overview
If your product usage, billing, or support data lives in Snowflake, it belongs in your customer knowledge graph. Today you can connect a Snowflake warehouse directly to Sonora and pull structured customer data straight from your tables — no exports, no scripts, no waiting on data eng for a one-off pull.
What syncs
Connecting Snowflake lets you bring in any table that has a customer identifier, and resolves rows to the right account automatically:
- Account and usage tables: any table keyed by customer ID, account ID, or domain, matched to a Sonora customer
- Product usage metrics: feature adoption, login frequency, seat counts, or whatever your product team already tracks in the warehouse
- Billing and revenue data: ARR, invoice history, and contract data pulled straight from your finance models
- Support and ticket volume: if your support data lands in Snowflake before it hits a BI tool, it can land in Sonora too
- Custom tables: anything else your team has modeled, mapped during setup and queried in chat and Canvas
Everything lands on the same unified customer record as your CRM and support tool data, so chat, Canvas, and playbooks can reason across product usage and lifecycle stage in one place instead of two.
Secure, read-only connection
We connect using a dedicated service account with a read-only role, scoped to only the schemas you approve. No credentials are stored in plaintext, and Sonora never writes back to your warehouse.
Set it up once from Settings, point us at a warehouse and schema, and the first full sync kicks off automatically. After that, syncs run on a schedule you control, pulling only new and changed rows.
Custom field mapping
Map any column to the attributes Sonora tracks. During setup, you’ll pick the join key (customer ID, account ID, or domain) and then map the columns that matter:
- ARR and usage tier
- Renewal and contract dates
- Product usage fields (whatever your team already models)
- Health score inputs, if you’re calculating one upstream
Anything Sonora doesn’t track natively can be added as a custom field and shows up in chat and Canvas right alongside the rest of your customer data.
Table and schema filters
You don’t need to sync your whole warehouse. Tell us which schemas and tables are in scope, and we’ll only query those. This keeps the sync fast, keeps your warehouse costs predictable, and keeps the data in Sonora limited to what your CS team actually needs.
Get started
Head to Settings → Data Sources → Snowflake and connect your warehouse. For the full setup walkthrough and column reference, see the Snowflake integration docs.


