skills.rest
FunnelEnvy
FunnelEnvyOFFICIAL
Explore all skills by this author →
WebsiteGitHub

gcp-bq-data-export

Export BigQuery data to Cloud Storage in CSV, JSON, Avro, and Parquet formats.

1|Updated Dec 11, 2025
Search Tags:#JSON#BigQuery#Parquet#CSV#Cloud Storage#export#Avro
One-click install
npx skills add https://github.com/FunnelEnvy/agents_webinar_demos --skill gcp-bq-data-export
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: gcp-bq-data-export
Source: https://github.com/FunnelEnvy/agents_webinar_demos/tree/main/.claude/skills/gcp-bq-data-export
Command: npx skills add https://github.com/FunnelEnvy/agents_webinar_demos --skill gcp-bq-data-export

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill simplifies exporting BigQuery data to Cloud Storage (CSV, JSON, Avro, Parquet) and supports EXPORT DATA statements, making data movement and archiving straightforward.

Core Features & Use Cases

  • Supports exports to CSV, JSON, Avro, and Parquet formats with optional compression.
  • Wildcard and partitioned export capabilities for large-scale data transfers.
  • Use Case: Automate scheduled extracts from production datasets to Cloud Storage for downstream analytics.

Quick Start

Run a basic export to CSV: bq extract --destination_format=CSV dataset.table gs://bucket/export.csv Example: Export to Parquet: bq extract --destination_format=PARQUET dataset.table gs://bucket/export.parquet

Frequently Asked Questions about gcp-bq-data-export

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

FAQPage Schema
How do I export BigQuery data to Cloud Storage in CSV or Parquet format?▼

Export BigQuery data to Cloud Storage in CSV or Parquet by running the bq extract command with the desired --destination_format flag. This skill supports ad hoc and scheduled extracts directly to a specified Cloud Storage bucket.

What is the best way to handle large-scale BigQuery exports to Cloud Storage?▼

For large-scale BigQuery exports to Cloud Storage, use wildcard and partitioned export capabilities. This skill handles large data transfers by splitting outputs across multiple files using wildcard naming conventions.

Can I automate scheduled BigQuery extracts to Cloud Storage for downstream analytics?▼

Yes, you can automate scheduled BigQuery extracts to Cloud Storage for downstream analytics. This skill supports scheduled exports and EXPORT DATA statements to streamline data movement and archiving.

Does exporting BigQuery data to Cloud Storage support compression settings for Avro and JSON files?▼

Exporting BigQuery data to Cloud Storage supports optional compression settings for formats including Avro, JSON, CSV, and Parquet. This reduces storage costs and file sizes for transferred datasets.

When should I use wildcard exports for BigQuery partitioned datasets?▼

Use wildcard exports for BigQuery partitioned datasets when transferring large-scale data across datasets to Cloud Storage. This approach prevents single-file size limits and enables parallel processing of partitioned transfers.

Related Skills

Explore More Data & Analytics Skills→
lanejlanej
40

bigquery

Manage Google BigQuery operations via a Rust-based CLI.

Community
Advanced
FunnelEnvyFunnelEnvy
1

gcp-bq-data-loading

Load CSV, JSON, Avro, and Parquet data into BigQuery.

Official
Advanced
hotriluanhotriluan
3

devops

Automate cloud infrastructure deployment across Cloudflare, Docker, and Google Cloud Platform.

Community
Advanced
ironkid90ironkid90

bigquery-data-transfer-service

Discover and manage BigQuery Data Transfer Service configurations via the Data Transfer API.

Community
Intermediate