Datastream: PostgreSQL Replication to BigQuery

This self-paced lab in the Google Cloud console guides you through replicating data from a PostgreSQL database to BigQuery. You'll learn to prepare a Cloud SQL instance, create Datastream connection profiles, start replication, and validate data accuracy in 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