Query BigQuery INFORMATION_SCHEMA tables and columns for metadata without exposing data.
npx skills add https://github.com/BfdCampos/dotfiles --skill bigquery-bfdcampos
Please help me install this Agent Skill. Skill: bigquery Source: https://github.com/BfdCampos/dotfiles/tree/main/claude/skills/bigquery Command: npx skills add https://github.com/BfdCampos/dotfiles --skill bigquery-bfdcampos
BigQuery projects often require understanding data structures without exposing sensitive contents. This skill provides safe metadata queries to preview schemas and table metadata.
Run a basic information_schema query to inspect the dimensions and columns of a target dataset without returning actual data.
High-intent search queries and answers about installing and using this skill.
Use standard SQL to query INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.COLUMNS to retrieve BigQuery table schemas without returning actual data. This safely exposes column names, data types, and table structures while keeping sensitive contents hidden.
Audit BigQuery dataset structures safely by querying INFORMATION_SCHEMA views to list and count datasets and tables. This validates schemas for data modeling workflows without exposing sensitive data contents.
Yes, validate source schemas for dbt pipelines by running BigQuery metadata queries against INFORMATION_SCHEMA.COLUMNS. This inspects column names and data types to validate source structures for migrations and data pipelines.
Yes, specify a project ID when running BigQuery metadata queries by always including the --project_id flag. You must also prescribe using standard SQL with the --use_legacy_sql=false flag.
Use INFORMATION_SCHEMA instead of SELECT * for BigQuery data discovery because it reveals schemas and table structures without exposing actual data. This prevents returning sensitive data during dataset auditing and metadata discovery.
fritzprixInstall and verify MCP runtime dependencies across Windows, Linux, and macOS.
interflownexGenerate and manage Google Cloud Composer pipeline definitions for dbt, Spark, and BigQuery tasks.
starlake-aiExtract BigQuery schemas from Google Cloud projects using CLI options.
gemini-cli-extensionsLocate Google Cloud data assets via Dataplex search and inspect schemas.
