Import people from Snowflake

Released

You can connect your Snowflake data warehouse to Customer.io, and import or update people on a regular interval. This integration helps ensure that your workspace always reflects the latest information about your audience.

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" ).

Learn more

Copied to clipboard!