Backfill and incremental exports handled
Customer.io writes historical backfill files and ongoing incremental files to your bucket. Polytomic processes both automatically without manual file management.
Customer.io Warehouse Exports
Polytomic syncs your Customer.io warehouse export data into your data warehouse, databases, and analytics tools with reliable ETL. Pull people, deliveries, engagement metrics, and campaign data out of Customer.io and into the systems your team already runs on, without writing code.
Perfect pairings
Duplicate records discarded automatically
Customer.io's export files can overlap within a run. Polytomic discards duplicate records before they reach your destination.
Message sends and engagement events
Sync message deliveries and content alongside opens, clicks, bounces, and other engagement metrics, plus customer profiles and custom objects.
Example workflows
Report on message engagement and deliverability next to revenue and product data
What you can sync
Sync data out of Customer.io's warehouse export files into your data warehouse, databases, and analytics tools with full control over which objects to include.
From Customer.io Warehouse Exports
People profiles with custom attributes and email addresses
Message deliveries with content and metadata
Engagement metrics including opens, clicks, and bounces
Campaigns, actions, broadcasts, and custom objects
How it works
Connect Polytomic to the S3 bucket where Customer.io writes its warehouse export files, then choose which of Customer.io's exported objects to sync into your data warehouse, databases, or other destinations.
Each run reads only the export files written since the last sync. Polytomic also discards duplicate records left by overlapping files, so your destination stays accurate.
- Reads Customer.io warehouse export files straight from your S3 bucket
- Supports AWS access keys or an IAM role for bucket access
- Processes only export files written since the last sync
- Separates historical backfill files from ongoing incremental exports automatically
- Discards duplicate records left by overlapping export files
- Covers profiles, deliveries, engagement metrics, campaigns, and custom objects
How to set up
Customer.io Warehouse Exports reads the Parquet files that Customer.io's warehouse sync feature writes to your S3 bucket. Point Polytomic at that bucket with an AWS access key and secret, or an IAM role. Polytomic keeps reading new export files as they arrive.
How to get connected
- 1In Polytomic, go to Connections, click Add connection, and select Customer.io Warehouse Exports
- 2Choose an authentication method and enter your AWS access key and secret, or your IAM role ARN
- 3Enter the S3 bucket name and region that receives your Customer.io warehouse exports, then click Save
Frequently asked questions
Why teams choose Polytomic
No engineering required
Set up and manage syncs without writing code.
Flexible data modeling
Use SQL to define exactly what data gets synced.
Handles scale automatically
Supports large datasets with incremental syncs and bulk APIs.
Start syncing your data with Customer.io Warehouse Exports in minutes
No credit card required. Free trial available.