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

AlloyDB real-time data access to BigQuery (in Preview) 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. • 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.

Consider using least-privilege security controls to restrict foreign server usage. For more information, see Secure BigQuery data access using the foreign data wrapper.