bigquery

Name: bigquery
Availability: InStock
Author: ClawData

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

Ready to run

npx skills add https://github.com/clawdata/clawdata --skill bigquery-clawdata

💬 Prompt for ChatGPT / Claude Chat▼

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.