Datastream PostgreSQL Replication to BigQuery| Google Cloud Platform(GCP)|Professional Data Engineer
What you'll do
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
Prerequisites
Familiarity with standard Linux environments
Familiarity with change data capture (CDC) concepts