skills.rest
AstorYH
AstorYHCOMMUNITY
Explore all skills by this author →
GitHub

bigquery-dataset-query

Query BigQuery datasets with SQL and return results as dictionaries.

15|8|Updated Feb 9, 2026
Search Tags:#analysis#gcp#data#sql#query#bigquery
One-click install
npx skills add https://github.com/AstorYH/PASB --skill bigquery-dataset-query
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: bigquery-dataset-query
Source: https://github.com/AstorYH/PASB/tree/main/nanobot/skills/bigquery-dataset-query
Command: npx skills add https://github.com/AstorYH/PASB --skill bigquery-dataset-query

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill automates the process of querying BigQuery datasets, allowing users to retrieve specific data without needing to manually interact with the BigQuery interface or write complex scripts.

Core Features & Use Cases

  • Data Retrieval: Execute custom SQL queries against BigQuery datasets.
  • Structured Output: Receive query results in a machine-readable format (list of dictionaries).
  • Use Case: Quickly get a list of all users who signed up in the last week from your user_data dataset in BigQuery.

Quick Start

Query the 'users' table in the 'analytics' dataset within the 'my-gcp-project' project for all entries where the 'signup_date' is greater than '2023-01-01'.

Frequently Asked Questions about bigquery-dataset-query

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

FAQPage Schema
How do I query a BigQuery dataset using SQL?▼

To query a BigQuery dataset, you provide a valid project ID, dataset ID, and a BigQuery-compatible SQL query string. The skill executes the query against the specified Google Cloud Platform dataset and returns the retrieved data.

What format do BigQuery query results come in?▼

BigQuery query results are returned in a machine-readable structured format, specifically a list of dictionaries. This format allows for immediate programmatic access and integration into downstream data analysis workflows.

Do I need a specific GCP project ID to run a BigQuery data analysis?▼

Yes, executing a BigQuery SQL query requires a valid GCP project ID, dataset ID, and the query string. Without these identifiers, the skill cannot locate or authenticate the data retrieval task within your Google Cloud Platform environment.

Can I retrieve specific user signup data from BigQuery without writing scripts?▼

Yes, you can retrieve specific user signup data from BigQuery by supplying a custom SQL query string. This skill automates the data retrieval process, eliminating the need to manually interact with the BigQuery interface or write complex scripts.

What is the best way to automate data retrieval from a BigQuery dataset?▼

Automating data retrieval from a BigQuery dataset is done by passing a custom SQL query to this skill along with your project and dataset IDs. It directly returns the queried records as a list of dictionaries for seamless integration.

Are there limitations when executing custom SQL queries against BigQuery datasets?▼

The primary limitation is that the SQL query string must be BigQuery-compatible, and valid project and dataset IDs are mandatory. The skill relies entirely on these inputs to execute the data retrieval task successfully within GCP.

Related Skills

Explore More Data & Analytics Skills→
ssmleossmleo

bigquery-basics

Create and manage BigQuery datasets, tables, and SQL queries.

Community
Intermediate
bettyguobettyguo
8

extract-table-pagination

Extract HTML table rows into dictionaries and paginate via next controls.

Community
Intermediate
googlegoogle
17.1k

agent-platform-migrate-from-ai-studio

Migrate applications from Google AI Studio to the Agent Platform.

Official
Intermediate
koya-altkoya-alt

query-integration-data

Query and modify records from connected services and data warehouses.

Community
Intermediate