Can I sync my Customer.io data directly to Postgres if I use the data warehouse sync feature?
Postgres sync?
Best answer by SuperNat
While we don't have a way to export data from Customer.io directly into a Postgres database, we do have an integration that allows you to send Customer.io data about messages, people, metrics, etc., to your data warehouse by way of an Amazon S3 or Google Cloud Project (GCP) storage bucket. From there, you can ingest the data into a data warehouse such as Redshift or BigQuery. Please allow me to share that documentation with you here:
If you were interested in exporting all the People and their respective attributes and then importing this data into Postgres, you could achieve this by navigating to People >> Export to CSV >> All attributes. This will generate a CSV file of all the People in your workspace that you could import into Postgres:
Reply
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.