Google launched Federated Query for BigQuery and AlloyDB

Better Integration of the two Google Cloud Services

Photo by Joseph Corl on Unsplash

Google let you now query data in AlloyDB using a federated query[1]. Which let you query data in real-time, without copying or moving data. This Zero-ETL approach What gives you the same benefits and to overcome some shortcomings of the traditional ETL approach. Such as:

• More data freshness (up-to-date insights for your business, no hours or even days old data).
• Not paying twice for the storage of the same data (customers normally store Terabytes or even more in BigTable).
• Less monitoring and maintaining of the ETL pipeline.

Using Cloud Spanner federated Queries in BigQuery

AlloyDB is a fully managed, PostgreSQL-compatible database service developed by Google Cloud. It is designed to deliver high performance, scalability, and reliability while offering the familiar PostgreSQL interface that many developers and organizations prefer. AlloyDB combines the benefits of open-source PostgreSQL with Google’s infrastructure innovations, making it an ideal…