CODEWITHSUNDEEP
postgresqlgoogle-bigquerystream
Han Chris
Han Chris

Reputation: 37

Google BigQuery stream to PostgresSQL

I'm using Google BigQuery for OLAP, and plan to provision Google Cloud SQL (Postgres) for OLTP. My plan is to direct stream data from Google BigQuery to Postgres. I try googling the solution, but the option is only using batch file .

Is it possible for the streaming solution from Google BigQuery to PostgreSQL?

Upvotes: 0

Views: 487

Answers (1)

Sakshi Gatyan
Sakshi Gatyan

Reputation: 2126

Currently there is no streaming read mechanism for accessing bigquery data as mentioned in this Stackoverflow post.

Hence, you'll have to go for reading data through batch process. You can also setup manual ETL process to integrate BigQuery to PostgreSQL using Cloud Data Fusion as mentioned in this article.

Upvotes: 1

Related Questions