Google Introduces BigQuery-Managed AI Functions For SQL
Google announced the public preview of BigQuery-managed AI functions on its cloud platform, providing three new SQL functions—AI.IF, AI.CLASSIFY, and AI.SCORE—that embed generative AI directly into queries. The functions handle prompt optimization, model selection, and parameter tuning while BigQuery optimizes query plans to reduce calls and costs. The preview aims to simplify semantic filtering, classification, and ranking within standard SQL workflows.
Key Points
- 1Adds three SQL functions (AI.IF, AI.CLASSIFY, AI.SCORE) to run generative AI inside BigQuery
- 2Reduces developer overhead by handling prompt optimization, model selection, and parameter tuning automatically
- 3Enables mixing AI with WHERE/JOIN/ORDER BY to simplify semantic filters, classification, and ranking in queries
Scoring Rationale
Official Google feature release with broad applicability and direct usability, limited by preview status and incremental innovation.
Sources
Public references used for this report.
Practice with real Logistics & Shipping data
90 SQL & Python problems · 15 industry datasets
250 free problems · No credit card
See all Logistics & Shipping problems
