BigQuery AI Features

Free features include SQL code assist (Gemini suggestions in console), Data Canvas (visual data exploration), and basic data preparation assistance. BigQuery ML enables model training and inference directly in SQL: built-in models (linear/logistic regression, k-means clustering, ARIMA forecasting, TimesFM for time series) run at standard query pricing. ML.GENERATE_TEXT enables direct Gemini calls within SQL queries for text analysis, summarization, and classification. External model support connects to Vertex AI endpoints for custom models. Duet AI features (renamed to Gemini) assist with query writing, optimization suggestions, and error explanation. BigQuery Studio provides notebook-style environment with Python, SQL, and Spark in unified interface. No additional licensing for core AI features, usage billed at standard BigQuery rates plus model-specific costs for ML.GENERATE_TEXT calls.