Comment on Faster PostgresSQL to BigQuery TransfersparentComments−mritchie7123ydo you already have an ETL pipeline to BQ? You could use Airbyte[0] for pg to bq. It's pretty heavy if this is your only source, but should work well if you need to query the pg data in bq frequently.0 - https://airbyte.com/connections/PostgreSQL-to-BigQuery−rockostrich3yThey said "the other way" so BQ to Postgres.−muspimerol3yBigQuery and Postgres are both sources and destinations in Airbyte, the data can flow either way.−api3yAirbyte looks nice! thanks.
Comments
do you already have an ETL pipeline to BQ? You could use Airbyte[0] for pg to bq. It's pretty heavy if this is your only source, but should work well if you need to query the pg data in bq frequently.
0 - https://airbyte.com/connections/PostgreSQL-to-BigQuery
They said "the other way" so BQ to Postgres.
BigQuery and Postgres are both sources and destinations in Airbyte, the data can flow either way.
Airbyte looks nice! thanks.