Systems | Development | Analytics | API | Testing

BigQuery has three new categories of advanced aggregation functions: group by extensions, user-defined and approximate aggregate functions.

The new ObjectRef data type helps to integrate unstructured data like images and audio into existing BigQuery tables.

BigQuery applies enhanced vectorization to aspects of query processing such as filter evaluation and data encodings and optimization techniques.

Google Cloud Serverless for Apache Spark, now available in BigQuery is an open-source, zero-ops, high performance, and unified analytics platform.

Updates to BigQuery workload management help optimize workloads and resource allocation, preventing performance issues and resource contention.

New BigQuery features support near-real-time, transactional-style operations, letting you perform common data management in your data warehouse.

Apache DataSketches in BigQuery enable approximate analytics with minimal memory or computational overhead, and with a single pass through the data.

AI.GENERATE_TABLE() in BigQuery lets you convert unstructured data into a structured table based on the provided prompt and table schema.

BigQuery ML contribution analysis models, now GA, automate insight generation and output key change drivers from multidimensional data.

Earth Engine in BigQuery capability allows SQL users to analyze geospatial data, even if they don't have remote sensing experience.