Datastream: PostgreSQL Replication to BigQuery
Prepare a Cloud SQL for PostgreSQL instance using the Google Cloud Console. Import data into the Cloud SQL instance
Create a Datastream connection profile for the PostgreSQL database. Create a Datastream connection profile for the BigQuery destination
Create a Datastream stream and start replication
Validate that the existing data and changes are replicated correctly into BigQuery