bigquery-basics

Automate BigQuery dataset, table, and job management with SQL queries.

17.1k|1.4k|Updated Mar 31, 2026
One-click install
npx skills add https://github.com/google/skills --skill bigquery-basics-google
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: bigquery-basics
Source: https://github.com/google/skills/tree/main/skills/cloud/bigquery-basics
Command: npx skills add https://github.com/google/skills --skill bigquery-basics-google

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires google-cloud-bigquery, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies managing datasets, tables, and jobs in BigQuery, allowing users to perform data ingestion, analysis, and query execution efficiently.

Core Features & Use Cases

  • Dataset Management: Create, modify, and delete datasets.
  • Table Management: Create, modify, and delete tables, including time partitioning.
  • Job Management: List, show, and cancel jobs.
  • Query Execution: Run SQL queries against BigQuery tables.
  • Use Case: For a business analyst, this Skill can be used to quickly set up a new dataset, create a table from a JSON schema, and execute a query to extract insights from the data.

Quick Start

Use the bigquery-basics skill to create a new dataset named 'my_dataset'.

Frequently Asked Questions about bigquery-basics

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

FAQPage Schema
How do I automate BigQuery dataset and table creation?

You can automate BigQuery dataset and table creation by using this Skill to programmatically generate, modify, or delete datasets and tables, including configurations for time partitioning. It requires the google-cloud-bigquery Python client library to interact with the service.

Can I execute SQL queries and manage BigQuery jobs programmatically?

Yes, you can execute SQL queries and manage BigQuery jobs programmatically. This Skill allows you to run SQL queries against your BigQuery tables and list, show, or cancel ongoing jobs to streamline your data analysis workflow.

Do I need the Python BigQuery client library to create tables from a JSON schema?

Yes, you need the Python BigQuery client library to create tables from a JSON schema. This Skill relies on the google-cloud-bigquery dependency to interact with BigQuery for setting up environments and managing table structures.

What's the best way to set up a BigQuery environment for data analysis?

The best way to set up a BigQuery environment for data analysis is to automate your initial infrastructure. This Skill lets you quickly establish datasets, create necessary tables, and execute queries to extract insights without manual console configuration.

Why use a programmatic approach for BigQuery table management instead of the console?

Using a programmatic approach for BigQuery table management automates repetitive setup tasks and ensures consistency. This Skill handles dataset and table modifications, time partitioning, and job cancellations efficiently, which is ideal for users managing reporting environments.