Maintained with ☕️ by
IcePanel logo

Support for the AI.AGG function preview has been temporarily disabled

Share

Services

## Feature Feature Support for the `AI.AGG` function [preview](https://cloud.google.com/products/#product-launch-stages)has been temporarily disabled. We are working to restore this feature as soon as possible. ## Feature Feature To reduce LLM token consumption and query latency when processing large datasets, enable [optimized mode](https://cloud.google.com/bigquery/docs/optimize-ai-functions)using the following [managed AI functions](https://cloud.google.com/bigquery/docs/generative-ai-overview#managed%5Fai%5Ffunctions): * [AI.IF](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-ai-if) * [AI.CLASSIFY](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-ai-classify) This feature is in[Preview](https://cloud.google.com/products/#product-launch-stages). ## Feature Feature The following [managed AI functions](https://cloud.google.com/bigquery/docs/generative-ai-overview#managed%5Fai%5Ffunctions)use Gemini to help you filter, join, rank, and classify your data: * [AI.IF](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-ai-if): Filter and join text and unstructured data (such as images, PDFs, audio, or video) based on a condition described in natural language. * [AI.SCORE](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-ai-score): Rate text and unstructured data (such as images, PDFs, audio, or video) to rank your data by quality, similarity, or other criteria. * [AI.CLASSIFY](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-ai-classify): Classify text and unstructured data (such as images, PDFs, audio, or video) into user-defined categories. These functions are [generally available](https://cloud.google.com/products#product-launch-stages)(GA). ## Feature Feature You can use [visualization cells](https://cloud.google.com/bigquery/docs/create-notebooks#cells) to automatically [generate a visualization](https://cloud.google.com/bigquery/docs/visualize-data-colab)of any DataFrame in your notebook. You can customize the columns, chart type, aggregations, colors, labels, and title. This feature is [generally available](https://cloud.google.com/products#product-launch-stages)(GA).