Import people from Snowflake
ReleasedYou 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.
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