BigQuery can re-execute instructions (queries) to try to proactively detect performance, correctness, or functional regressions
Share
Services
## Announcement
Announcement
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 `bigquery-adminbot@system.gserviceaccount.com` when BigQuery re-executes an instruction.
## Feature
Feature
[Python UDFs](https://cloud.google.com/bigquery/docs/user-defined-functions-python) are now[Generally Available](https://cloud.google.com/products/#product-launch-stages)(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)](https://pypi.org/) and let you access external services using a [Cloud resource connection](https://cloud.google.com/bigquery/docs/create-cloud-resource-connection).
## Feature
Feature
You can now use the[AI.AGG function](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-ai-agg)to semantically aggregate unstructured input data based on natural language instructions. This feature is in[Preview](https://cloud.google.com/products#product-launch-stages).