Skip to main content
Solved

Postgres sync?

  • October 15, 2023
  • 1 reply
  • 54 views

Can I sync my Customer.io data directly to Postgres if I use the data warehouse sync feature?

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:

View original
Did this topic help you find an answer to your question?

1 reply

  • Community Manager
  • 40 replies
  • Answer
  • October 15, 2023

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings