Maintained with ☕️ by
IcePanel logo

AlloyDB real-time data access to BigQuery (in Preview) now offers limit pushdown and runtime projects

Share

Services

## Feature Feature AlloyDB real-time data access to BigQuery (in [Preview](https://cloud.google.com/products#product-launch-stages)) now offers limit pushdown and runtime projects: * Limit pushdown: when you query foreign tables, some `LIMIT` and `OFFSET` clauses are automatically pushed down to BigQuery, reducing network transfer and improving query response times. For more information, see [Access to real-time data in BigQuery overview](https://cloud.google.com/alloydb/docs/access-real-time-data-overview). * Runtime projects: you can specify an optional runtime project at either the foreign server or foreign table level to execute queries and manage compute costs independently of the project that stores your data. For more information, see [Configure access to real-time data in BigQuery](https://cloud.google.com/alloydb/docs/configure-access-real-time-data). Consider using least-privilege security controls to restrict foreign server usage. For more information, see [Secure BigQuery data access using the foreign data wrapper](https://cloud.google.com/alloydb/docs/security-best-practices#secure-bq-fdw).