Customer.io

Import people from Snowflake

Data / Integrations Api / Developers
Import people from Snowflake

When you set up a sync, you provide a query determining exactly what information you want to reflect as attributes on people in Customer.io. You’ll also set the frequency of import operations from your Snowflake instance.

Your query can use a {{last_sync_time}} variable, making it easy for you to limit each import operation to changes made since the previous interval.

You must map Snowflake columns to attributes

Snowflake columns are all caps, but attributes in Customer.io—at least the id and email identifiers are not. Your snowflake query must use AS to map the all-caps to lowercased attributes (i.e. Select ID AS "id" ).

Go to the docs →