What authentication is required for this skill to work?

Users must have the Google Cloud SDK installed and authenticated via 'gcloud auth application-default login'. The skill performs a connection test upon startup.

Can it help align business metrics before writing SQL?

Absolutely. A core part of the workflow is the 'Requirement Clarification' step, which forces an alignment on metric definitions and logic before any SQL is generated or executed.

Does it support legacy SQL?

No, the skill is optimized for Standard SQL (use_legacy_sql=false) to ensure compatibility with modern BigQuery features and best practices.

How does it handle environments with hundreds of tables?

The skill utilizes a three-layer progressive loading strategy, selectively reading core rules, domain-specific READMEs, and individual table documents only when relevant to the user's query.

Does this skill support query cost estimation?

Yes, it performs mandatory dry-run checks via the BigQuery CLI to estimate Slot Time and will refuse execution if the query exceeds the predefined safety thresholds.

BigQuery Data Analyst

Name: BigQuery Data Analyst
Author: SerendipityOneInc

bySerendipityOneInc

•

분석 및 모니터링

Analyzes BigQuery data with high precision using an extensive metadata knowledge base and automated cost controls.

BigQuery Data Analyst is a specialized skill for Claude Code designed to streamline data analysis within Google Cloud Platform environments. It provides a structured workflow that ensures business requirements are aligned before SQL execution, strictly enforces data governance rules, and manages query costs through automated slot-time checks. By leveraging a multi-layered metadata repository covering over 600 tables and 500 functions, it helps developers and analysts generate accurate SQL, validate results for business logic, and maintain security through mandatory CLI connection verification.

주요 기능

01Automated cost management with mandatory dry-run checks to prevent expensive queries exceeding slot-time thresholds.

02Mandatory BigQuery CLI authentication verification to ensure secure and authorized data access.

03Context-optimized domain loading that selectively reads relevant documentation to maximize token efficiency.

042 GitHub stars

05Standardized 4-step workflow including requirement clarification, table selection, SQL generation, and result validation.

06Deep metadata integration supporting 600+ production tables and 16 business domains for context-aware analysis.

사용 사례

01Explaining data lineage and calculation logic for specific business metrics using built-in metadata.

02Automating routine data reporting and trend analysis across diverse business domains like advertising and user behavior.

03Generating complex analytical SQL queries with correct joins and mandatory partition filters.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add serendipityoneinc/srp-claude-code-marketplace bigquery-analyst

For use in Claude.ai and ChatGPT

Download Skill