google-bigquery

What This Skill Does

The google-bigquery skill enables seamless interaction with Google BigQuery, Google's fully managed, serverless data warehouse. By leveraging managed OAuth via the Maton gateway, this skill allows users to execute complex SQL queries, manage datasets and tables, and perform data analysis at scale without needing to handle manual authentication flows. It acts as a bridge between the OpenClaw AI agent and the BigQuery API, automatically injecting the necessary authorization headers to perform administrative and analytical tasks programmatically.

Installation

To integrate this skill into your environment, use the OpenClaw CLI:

clawhub install openclaw/skills/skills/byungkyu/google-bigquery

Ensure that you have set your MATON_API_KEY as an environment variable to authorize the gateway. You must also manage your BigQuery connection status at https://ctrl.maton.ai by authenticating with your Google account to grant the required permissions.

Use Cases

• Data Analytics: Run complex SQL queries across massive datasets and return results directly into the agent context for reporting or visualization.
• Database Management: Automate the creation, deletion, or listing of datasets and tables to streamline data lifecycle management.
• ETL Workflows: Schedule tasks to extract or load data into BigQuery as part of a larger data pipeline managed by OpenClaw.
• Auditing: Programmatically check table schemas or metadata to ensure data governance standards are maintained across your organization.

Example Prompts

1. "Run a query on my 'sales_data' dataset to calculate the total revenue from the last 30 days and summarize the findings."
2. "Check the current schema for the 'user_activity' table in the 'analytics_prod' dataset and tell me if it contains a 'timestamp' column."
3. "Create a new BigQuery dataset named 'marketing_reports' in the project 'my-cool-project' and set the default location to US."

Tips & Limitations

• Authentication: Always verify that your connection status is 'ACTIVE' at https://ctrl.maton.ai if your queries return 401 Unauthorized errors.
• Quota Management: Keep in mind that heavy analytical queries will count against your Google Cloud project's billing and quota limits.
• Security: Since this skill allows for data manipulation, ensure the service account or user account linked via OAuth has the 'Least Privilege' required for your specific tasks to prevent accidental data deletion or unauthorized exposure.