skills.rest
clawdata
clawdataOFFICIAL
Explore all skills by this author →
GitHub

bigquery

Query and manage Google BigQuery datasets using the bq CLI.

24|11|Updated Feb 19, 2026
Search Tags:#sql#cloud#data-analytics#bigquery#datasets#bq
One-click install
npx skills add https://github.com/clawdata/clawdata --skill bigquery-clawdata
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: bigquery
Source: https://github.com/clawdata/clawdata/tree/main/skills/bigquery
Command: npx skills add https://github.com/clawdata/clawdata --skill bigquery-clawdata

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill enables you to interact with Google BigQuery through the standard bq CLI, making it easy to run queries, inspect schemas, load data, and manage datasets without leaving your terminal.

Core Features & Use Cases

  • List datasets, inspect table schemas, run standard SQL queries, and manage partitioning across projects.
  • Use cases include ad-hoc data exploration, data loading from CSV/JSON, and maintaining dataset structures for reporting.
  • Example: quickly fetch the first 10 rows of a table to validate schema during a data ingestion pipeline.

Quick Start

Authenticate with gcloud or a service account and run a simple bq command to verify access.

Frequently Asked Questions about bigquery

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

FAQPage Schema
How do I run SQL queries on Google BigQuery from the command line?▼

You can run SQL queries on Google BigQuery from the command line by using the bq CLI to execute standard queries, inspect table schemas, and fetch data without leaving your terminal.

What is needed to authenticate the bq CLI for BigQuery dataset management?▼

Authenticating the bq CLI for BigQuery dataset management requires setting up gcloud application-default login or configuring a service account key via GOOGLE_APPLICATION_CREDENTIALS and setting GOOGLE_CLOUD_PROJECT.

Can I load data from CSV or JSON files into BigQuery tables using bq?▼

Yes, you can load data from CSV or JSON files into BigQuery tables using the bq CLI, which supports data loading tasks alongside schema inspection and dataset management across projects.

How do I list BigQuery datasets and inspect table schemas across different projects?▼

You can list BigQuery datasets and inspect table schemas across different projects by executing specific bq CLI commands designed for dataset exploration and partitioning management.

What's the best way to validate a BigQuery table schema during a data ingestion pipeline?▼

The best way to validate a BigQuery table schema during a data ingestion pipeline is using the bq CLI to quickly fetch the first rows of a table and inspect the schema structure.

Does the bq CLI support managing table partitioning for BigQuery datasets?▼

Yes, the bq CLI supports managing table partitioning for BigQuery datasets, allowing you to handle partitioning structures across projects while performing routine data exploration and management tasks.

Related Skills

Explore More Data & Analytics Skills→
alex-tgkalex-tgk
1

gcloud

Configure, authenticate, and manage Google Cloud resources via the gcloud CLI.

Community
Intermediate
AstorYHAstorYH
15

bigquery-dataset-query

Query BigQuery datasets with SQL and return results as dictionaries.

Community
Intermediate
wangx7wangx7

bigquery-basics

Manage BigQuery datasets, tables, and jobs via CLI, client libraries, and MCP servers.

Community
Intermediate
johnkuehjohnkueh
5

bq-analytics-query

Query bq-analytics data in BigQuery using the bq CLI.

Community
Intermediate