Skip to main content
New Introducing Orchestrator Learn more
Data Warehouse integration

Snowflake + Conversion

Sync contacts, custom objects, and events from Snowflake with SQL you write, on a schedule you set.

Snowflake
Into Conversion
Conversion

How Conversion works with Snowflake

Conversion syncs data from Snowflake into its data model on a schedule you choose. You write a SQL query for each sync, and the rows become contacts, custom objects with their relationships, or events that can trigger workflows. Conversion reads from Snowflake and never writes back to it.

What syncs

Data Direction Details
Contacts Into Conversion Create or update contacts, matched by userId or email. Columns map to fields by name.
Custom objects Into Conversion Products, subscriptions, usage, or any model you define, with relationships to contacts.
Events Into Conversion Rows become timestamped events on contacts, deduplicated by eventId.

How to connect Snowflake

  1. 1 Create a dedicated Snowflake warehouse, role, and user for Conversion, with read access to the databases you want to sync.
  2. 2 Generate an unencrypted PKCS#8 key pair and assign the public key to the Conversion user.
  3. 3 Allowlist Conversion's IP addresses if you use a Snowflake network policy.
  4. 4 Add the connection in Conversion settings, then create a sync for each destination with its SQL query and schedule.

See Conversion with Snowflake

Book a demo and we'll walk through the Snowflake integration on a stack that looks like yours.