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