Live Query for Google BigQuery
Use Live Query for Google BigQuery to run Cloud Native workflows that use data directly in BigQuery. Running workflows directly in BigQuery can improve performance and reduce costs. However, some limitations apply when you run jobs with the BigQuery engine. This page outlines the current limitations.
Google BigQuery Tool Palette
Use the Google BigQuery tool palette to apply AI directly to your BigQuery data. These tools use Live Query to run in place, so you can score, classify, summarize, translate, and extract insights from your data without moving it.
Important
Review your results before using them downstream. Due to the non-deterministic nature of AI, outputs such as scores, labels, or classifications might vary across runs.
BigQuery File Size Limits
BigQuery imposes a limit of 1 MB for all submitted SQL queries.
Unsupported Tools and Functions
Some tools and functions aren't supported in the Live Query for Google BigQuery Private Preview. These tools and functions are disabled in the UI and will be enabled when support becomes available.
External Input (Non-BigQuery Sources)
When you use external input sources other than BigQuery, make sure that column names follow BigQuery’s naming conventions. BigQuery doesn't support special characters in column names.
For more information, go to Specifying a Schema in BigQuery.
Note
Only CSV file input has been tested at this time. Other file types might not be compatible or supported.
Multiple BigQuery Connections
You can include inputs from multiple BigQuery connections in the same workflow if all connections share the same projectId.
To use connections from different projectIds:
The Workspace Admin must enable the BigQuery billing project for the workspace.
You must configure a billing project in User Preferences.
SQL Transform Tool
Unaliased columns aren't supported. Each new column in the SQL Transform tool must include an explicit alias. For more information, go to Query Syntax in BigQuery. These are examples of unsupported and supported queries:
Unsupported:
SELECT * FROM (SELECT DATE(2025, 09, 09), LAST_DAY('2025-12-09'))Supported:
SELECT * FROM (SELECT DATE(2025, 09, 09) AS c1, LAST_DAY('2025-12-09') AS c2)Cross-Region Datasets
BigQuery doesn't support cross-region execution. Ensure that your dataset, remote model, and connection are in the same region as the schema selected during LiveQuery setup to avoid execution errors.
For more information, go to BigQuery Locations.