skills.rest
interflownex
interflownexCOMMUNITY
Explore all skills by this author →
GitHub

bigquery

Generate optimized BigQuery SQL and BQML queries for data analysis.

2|1|Updated May 25, 2026
Search Tags:#machine learning#sql#bigquery#data optimization#gql#graph analytics#bqml
One-click install
npx skills add https://github.com/interflownex/All-in-One --skill bigquery-interflownex
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: bigquery
Source: https://github.com/interflownex/All-in-One/tree/main/.gemini/skills/bigquery
Command: npx skills add https://github.com/interflownex/All-in-One --skill bigquery-interflownex

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This skill streamlines complex data operations in BigQuery by providing standardized, optimized patterns for SQL queries, machine learning functions, and property graph analysis, reducing development time and query costs.

Core Features & Use Cases

  • Query Optimization: Provides mandatory rules for SQL performance, including column pruning and predicate pushdown.
  • AI & ML Integration: Offers syntax and best practices for BQML functions like AI.FORECAST, AI.GENERATE, and AI.DETECT_ANOMALIES.
  • Graph Analytics: Supplies strict GQL standards for property graph pattern matching and semantic graph operations.
  • Use Case: Use this skill to generate an optimized SQL query for time-series forecasting using TimesFM or to construct a GQL query for identifying relationships between accounts in a property graph.

Quick Start

Use the bigquery skill to generate an optimized SQL query that detects anomalies in my sales data using the AI.DETECT_ANOMALIES function.

Frequently Asked Questions about bigquery

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize BigQuery SQL queries to reduce processing costs?▼

Optimize BigQuery SQL by applying mandatory performance rules like column pruning and predicate pushdown. This skill provides standardized patterns to reduce development time and query costs for efficient cloud-scale data processing.

What is the best way to run time-series forecasting in BigQuery?▼

Time-series forecasting in BigQuery is handled using BQML AI functions like AI.FORECAST. This skill offers syntax and best practices to implement these models directly within your data warehouse.

How does BigQuery property graph pattern matching work with GQL?▼

Property graph pattern matching in BigQuery uses strict GQL standards to identify relationships, such as connections between accounts. This skill supplies the logic for executing semantic graph operations.

Can I detect anomalies in my dataset using BigQuery ML?▼

You can detect anomalies in BigQuery using the AI.DETECT_ANOMALIES function. This skill provides the specialized logic required to generate queries that apply this BQML AI function to your data.

Does BigQuery support semantic search and BigFrames data manipulation?▼

BigQuery supports semantic search and BigFrames data manipulation for complex analysis. This skill delivers the implementation standards for BQML AI functions and BigFrames workflows within the ecosystem.

Related Skills

Explore More Data & Analytics Skills→
agentuityagentuity
1

agentuity-cli-cloud-storage-upload

Upload local files to cloud storage buckets with custom keys and content types.

Official
Intermediate
weirdgmeweirdgme
4

platform-engineering

Design and implement scalable platform engineering patterns for internal developer platforms.

Community
Advanced
interflownexinterflownex
2

bigquery-bigframes

Generate BigFrames Python code for scalable BigQuery data analysis and ML.

Community
Advanced
dominodatalabdominodatalab
6

domino-distributed-computing

Configure and launch Spark, Ray, and Dask clusters in Domino Data Lab.

Official
Advanced