BigQuery Enhances Query Execution and Python UDFs
BigQuery can now re-execute queries to proactively detect performance or correctness regressions at no extra cost. Python User-Defined Functions (UDFs) are now generally available, allowing integration with PyPI libraries and external services. Additionally, a new AI.AGG function is available in preview for semantic aggregation of unstructured data using natural language.
Features (2) ›
- BigQuery
Python UDFs are now Generally Available (GA). You can use Python UDFs to implement a scalar function in Python and use it in a SQL query. Python UDFs let you install third-party libraries from the Python Package Index (PyPI) and let you access external services using a Cloud resource connection .
- BigQuery
You can now use the AI.AGG function to semantically aggregate unstructured input data based on natural language instructions. This feature is in Preview .
Notes (1) ›
- BigQuery
BigQuery can re-execute instructions (queries) to try to proactively detect performance, correctness, or functional regressions. These re-executions will have no side effects and will happen with no additional cost or resource consumption. Data access logs may show [email protected] when BigQuery re-executes an instruction.
https://docs.cloud.google.com/release-notes#May_20_2026