BigQuery LiveQuery Limitations
Use BigQuery LiveQuery to run Cloud Native workflows that use BigQuery 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.
Note
BigQuery LiveQuery is available in Private Preview. Functionality and availability might change before general release. Find out more about BiqQuery LiveQuery if you are interested in joining the Public Preview.
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 BigQuery LiveQuery 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
All input and output datasets in a LiveQuery workflow must be in the same region. BigQuery doesn't support cross-region datasets in a single job execution.
For more information, go to BigQuery Locations.