Serverless replication from operational databases to BigQuery | C2C Community

Serverless replication from operational databases to BigQuery

  • 21 September 2022
  • 3 replies
  • 22 views

Userlevel 7
Badge +20

 

 

Google Cloud always updates its applications and infrastructure for its customers' needs. Recently Google Cloud updates on Google Cloud Spanner and Datastream. Here are a couple of updates on Google Cloud Spanner and Datastream. To read it in detail click on the links below.

Datastream for BigQuery is in Public Preview:
Datastream for BigQuery leverages the same serverless architecture and Change Data Capture (CDC) capabilities. Now with a direct BigQuery destination, customers can easily and seamlessly replicate data from their source databases into BigQuery, saving time and resources.


There is also the public preview of Datastream support for PostgreSQL sources

For Cloud Spanner there is General Availability launch of the open-source Google Cloud Spanner driver for database/sql in Go! (https://lnkd.in/gYmmbNWa)

and in public preview fine-grained access control for Cloud Spanner which provides table- and column-level protection for Spanner databases.

 

Extra Credit:

 


3 replies

Userlevel 7
Badge +58

Datastream is becoming better and more useful.

Thanks for sharing this post with all these details @malamin 😀

Userlevel 7
Badge +20

You’re welcome @ilias .  It represents a significant advancement in the data management system. I recall using dBase, Lotus, and Foxpro databases from 1991 to 1995.

How I design database schema using a command prompt and a shortcut key. In a matter of seconds, we can now manage a large database. It's an incredible feeling. I speak from firsthand experience.

 

 

Userlevel 7
Badge +58

LOL

You reminded me the… Stone Ages 😂 @malamin 

True. It’s a lot easier now!

Reply