Bigquery AI ML vs Bigquery basics
Bigquery AI ML is an open-source agent skill for databases. Bigquery basics is an open-source agent skill for databases.
- Bigquery AI ML is best for forecast next quarter's sales from a historical table in bigquery.
- Bigquery basics is best for create a new bigquery dataset and table from a schema file.
- What it is
- Bigquery AI ML is an open-source agent skill for databases.Bigquery basics is an open-source agent skill for databases.
- Best for
- Forecast next quarter's sales from a historical table in BigQueryCreate a new BigQuery dataset and table from a schema file
- Kind
- SkillSkill
- Pricing
- Open sourceOpen source
- Platforms
- Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf, GooseClaude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf, Goose
- GitHub stars
- 24.4K24.4K
- Last commit
- Nov 2026Nov 2026
- License
- Apache-2.0Apache-2.0
- Open source
- Good for
- Forecast next quarter's sales from a historical table in BigQuery; Find outlier rows in a daily metrics time series; Classify support tickets into predefined categories using SQLCreate a new BigQuery dataset and table from a schema file; Run a SQL query against a BigQuery table or public dataset; Load and inspect data in BigQuery from the command line
What Bigquery AI ML does
Time-series forecasting
Covers zero-shot forecasting, backtesting evaluation, seasonality and trend extraction for historical series.
Anomaly and change detection
Finds isolated outliers and sustained structural shifts in time-series data.
Driver and causal analysis
Attributes metric changes to dimensional segments and measures post-intervention effects.
Semantic search and embeddings
Covers embedding generation, vector search and similarity scoring over text or multimodal data.
Generative AI in SQL
Runs per-row text generation, structured extraction, classification and semantic filtering in queries.
Descriptive statistics
Produces column statistics, distribution profiles and correlation coefficients for tables.
What Bigquery basics does
Dataset and table management
Covers creating datasets and tables with the bq tool and defining table schemas in JSON.
SQL query execution
Shows how to run standard SQL queries against BigQuery, including public datasets.
Incremental change tracking
Explains how to query table changes using APPENDS and CHANGES.
Client library reference
Provides usage notes for BigQuery client libraries in Python, Java, Node.js and Go.
MCP and Terraform guidance
Covers the BigQuery remote MCP server and Terraform examples for datasets, tables and reservations.
IAM and governance notes
Summarizes roles, permissions and data governance practices for BigQuery.
Bigquery AI ML vs Bigquery basics: questions
Is Bigquery AI ML or Bigquery basics cheaper?
Both are open source. Compare current plans on each official site.
What is the difference between Bigquery AI ML and Bigquery basics?
Bigquery AI ML is an open-source agent skill for databases. Bigquery basics is an open-source agent skill for databases.
