We recently published a tutorial where you can learn how we created an ELT pipeline to sync data from Postgres to BigQuery at Airbyte, using Airbyte Cloud! You can follow these steps to create your own.
https://airbyte.com/tutorials/postgres-to-bigquery