Gcp Bq Data Loading
Helps with Google Cloud, data as part of deploying and managing cloud infrastructure workflows.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add gcp-bq-data-loading npx -- -y @trustedskills/gcp-bq-data-loading
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"gcp-bq-data-loading": {
"command": "npx",
"args": [
"-y",
"@trustedskills/gcp-bq-data-loading"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill enables AI agents to load data into Google BigQuery tables. It handles the complexities of connecting to GCP, authenticating, and formatting data for efficient loading. The agent can specify the source file (e.g., CSV, JSON), target dataset and table within BigQuery, and any necessary transformation options.
When to use it
- Automated Data Pipelines: Schedule regular data imports from external sources into your BigQuery warehouse.
- Data Migration: Quickly move datasets from local files or cloud storage (like Google Cloud Storage) into BigQuery for analysis.
- Real-time Analytics: Ingest streaming data directly into BigQuery to power dashboards and reports.
- ETL Processes: Integrate this skill as part of a larger Extract, Transform, Load (ETL) workflow.
Key capabilities
- Connects to Google Cloud Platform (GCP).
- Loads data from files into BigQuery tables.
- Supports various file formats (CSV, JSON).
- Handles authentication with GCP.
Example prompts
- "Load the CSV file 'customer_data.csv' from my local machine into the 'marketing_dataset.customers' table in BigQuery."
- "Import the JSON data from Google Cloud Storage bucket 'my-bucket' and file 'sales_data.json' into the 'analytics.orders' BigQuery table."
- “Load the data, skipping the first row of headers.”
Tips & gotchas
- Ensure your AI agent has appropriate permissions to access GCP resources and write to BigQuery datasets.
- Large files may require configuring partitioning or clustering for optimal loading performance in BigQuery.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.