BigQuery introduces three managed AI functions (AI.IF, AI.CLASSIFY, and AI.SCORE) that integrate generative AI capabilities directly into SQL queries. These functions enable semantic filtering and joining, text/image classification, and natural language-based ranking without requiring prompt tuning or model selection. BigQuery automatically optimizes prompts, query plans, and model parameters to minimize costs while processing unstructured data like text and images alongside traditional structured data analysis.
Sort: