Connect your AI agent to Google BigQuery
Google BigQuery is a fully managed data warehouse for large-scale data analytics, offering fast SQL queries and machine learning capabilities on massive datasets
Set it up in Melso
- 1In Melso, open Settings → Agent Apps and hit Connect on Google BigQuery.
- 2Finish the OAUTH2 / GOOGLE_SERVICE_ACCOUNT sign-in in the window that opens. Melso stores the connection, not your credentials.
- 3Open your agent, go to its Agent Apps tab, and allow Google BigQuery.
- 4Give the agent a task. It calls Google BigQuery itself when the work needs it.
What Google BigQuery gives your agent
The tools, permissions, and events Google BigQuery exposes — the same ones your agent can use once the app is authorized.
What you sign in with
Google BigQuery connects with OAUTH2 / GOOGLE_SERVICE_ACCOUNT.
- Client id
- Client secret
Permissions
Tools Google BigQuery exposes
Cancel BigQuery Job
Tool to cancel a running BigQuery job. This call returns immediately, and you need to poll for the job status to see if the cancel completed successfully. Note that cancelled jobs may still incur costs.
Create Capacity Commitment
Tool to create a new capacity commitment resource in BigQuery Reservation. Use when you need to purchase compute capacity (slots) with a committed period of usage for BigQuery jobs. Supports various commitment plans (FLEX, MONTHLY, ANNUAL, THREE_YEAR) and editions (STANDARD, ENTERPRISE, ENTERPRISE_PLUS).
Create BigQuery Connection
Tool to create a new BigQuery connection to external data sources using the BigQuery Connection API. Use when setting up connections to AWS, Azure, Cloud Spanner, Cloud SQL, Salesforce DataCloud, or Apache Spark.
Create Analytics Hub Data Exchange
Tool to create a new Analytics Hub data exchange for sharing BigQuery datasets. Use when you need to set up a container for data sharing with descriptive information and listings.
Create Analytics Hub Listing
Tool to create a new listing in a BigQuery Analytics Hub data exchange. Use when you need to share a BigQuery dataset with specific subscribers or make it available for discovery. The dataset must exist and be in the same region as the data exchange.
Create BigQuery Dataset
Tool to create a new BigQuery dataset with explicit location, labels, and description using the BigQuery Datasets API. Use when the workflow needs to set up a staging/warehouse dataset and correctness of region is critical to avoid downstream job location mismatches. Surfaces 409 Already Exists errors cleanly without retrying.
Create Analytics Hub Listing
Tool to create a new listing in a data exchange using Analytics Hub API. Use when publishing a BigQuery dataset to make it available for subscription by other users or organizations.
Create BigQuery Data Policy (v2beta1)
Tool to create a new data policy under a project with specified location using the v2beta1 BigQuery Data Policy API. Use when you need to set up data masking rules or column-level security for sensitive data. The v2beta1 endpoint uses a nested request structure.
Compare nearby apps
Other Databases connections your agents can use.
Connect to Supabase
Supabase is an open-source backend-as-a-service providing a Postgres database, authentication, storage, and real-time subscription APIs for building modern applications
Connect to Airtable
Airtable merges spreadsheet functionality with database power, enabling teams to organize projects, track tasks, and collaborate through customizable views, automation, and integrations for data management
Connect to Code Interpreter
CodeInterpreter extends Python-based coding environments with integrated data analysis, enabling developers to run scripts, visualize results, and prototype solutions inside supported platforms
Connect to SerpApi
SerpApi provides a real-time API for structured search engine results, allowing developers to scrape, parse, and analyze SERP data for SEO and research
Connect to Exa
Exa focuses on data extraction and search, helping teams gather, analyze, and visualize information from websites, APIs, or internal databases
Connect to Snowflake
Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments