Sign inDownload

← All integrations

Google BigQuery

One-click sign-inProjects & CodeMarketing & Growth

Connect it in Quilt

Google BigQuery is a fully managed data warehouse for large-scale data analytics, offering fast SQL queries and machine learning capabilities on massive datasets

Sign in with one click. Composio asks the app for you; Quilt never sees the login.

Reads on its own32

Agents use these right away.

  • Get BigQuery Dataset MetadataTool to retrieve BigQuery dataset metadata including location via the datasets.get API.
  • Get BigQuery JobTool to retrieve information about a specific BigQuery job.
  • Get BigQuery Query ResultsTool to get the results of a BigQuery query job via RPC.
  • Get BigQuery Table SchemaFetch a BigQuery table's schema and metadata without querying row data.
  • List BigQuery DatasetsTool to list datasets in a specific BigQuery project, including dataset locations.
  • List BigQuery JobsLists a page of jobs in a BigQuery project, optionally including jobs owned by all users, with filters for creation time, state, or parent job.
  • List BigQuery ModelsTool to list all BigQuery ML models in a specified dataset.
  • List BigQuery ProjectsTool to list BigQuery projects to which the user has been granted any project role.
  • List BigQuery Table DataTool to list the content of a BigQuery table in rows via the REST API.
  • List BigQuery TablesList tables in a BigQuery dataset via the REST API, with pagination.
  • Get BigQuery ML ModelTool to retrieve a specific BigQuery ML model resource by model ID.
  • Get BigQuery Connection IAM PolicyTool to get the IAM access control policy for a BigQuery connection resource.
  • Get BigQuery RoutineTool to retrieve a BigQuery routine (user-defined function or stored procedure) by its ID.
  • Get BigQuery Routine IAM PolicyTool to retrieve the IAM access control policy for a BigQuery routine resource.
  • Get BigQuery Service AccountTool to get the service account for a project used for interactions with Google Cloud KMS.
  • Get BigQuery Table IAM PolicyTool to retrieve the IAM access control policy for a BigQuery table resource.
  • List Analytics Hub ListingsTool to list all listings in a given Analytics Hub data exchange.
  • List BigQuery ConnectionsTool to list BigQuery connections in a given project and location.
  • List BigQuery Capacity CommitmentsList capacity commitments for an admin project in a specified location, including purchased compute slots and commitment details such as plan, state, and duration.
  • List Data Exchange ListingsTool to list all listings in a given Analytics Hub data exchange using the v1beta1 API.
  • List BigQuery Data Transfer LocationsTool to list information about supported locations for BigQuery Data Transfer Service.
  • List Connections in LocationTool to list BigQuery connections in a given project and location using the v1beta1 API.
  • List BigQuery Location Data PoliciesTool to list all data policies in a specified parent project and location using the v2beta1 API.
  • List Organization Data ExchangesTool to list all data exchanges from projects in a given organization and location using Analytics Hub API.
  • List Analytics Hub Query TemplatesList a page of query templates in an Analytics Hub data exchange.
  • List BigQuery Reservation AssignmentsTool to list BigQuery reservation assignments.
  • List BigQuery Reservation GroupsTool to list all BigQuery reservation groups for a project in a specified location.
  • List BigQuery ReservationsTool to list all BigQuery reservations for a project in a specified location.
  • List BigQuery RoutinesList routines, including user-defined functions and stored procedures, in a BigQuery dataset.
  • List BigQuery Row Access PoliciesList row access policies and their filter predicates for a specified BigQuery table.
  • Search All BigQuery Reservation AssignmentsTool to search all BigQuery reservation assignments for a specified resource in a particular region.
  • Test BigQuery Routine IAM PermissionsTool to test which IAM permissions the caller has on a BigQuery routine.

Asks someone first31

Anything that sends, creates, changes or deletes waits for a person to approve it in the session’s chat.

  • Create Analytics Hub ListingTool to create a new listing in a BigQuery Analytics Hub data exchange.
  • Create BigQuery DatasetTool to create a new BigQuery dataset with explicit location, labels, and description using the BigQuery Datasets API.
  • Create BigQuery RoutineTool to create a new user-defined routine (function or procedure) in a BigQuery dataset.
  • Create BigQuery TableTool to create a new, empty table in a BigQuery dataset.
  • Delete BigQuery DatasetTool to delete a BigQuery dataset specified by datasetId via the datasets.delete API.
  • Delete BigQuery ML ModelTool to delete a BigQuery ML model from a dataset.
  • Delete BigQuery TableTool to delete a BigQuery table from a dataset.
  • Insert Data into BigQuery TableTool to stream data into BigQuery one record at a time without running a load job.
  • Insert BigQuery JobTool to start a new asynchronous BigQuery job (query, load, extract, or copy).
  • Insert BigQuery Job with UploadTool to start a new BigQuery load job with file upload.
  • Patch BigQuery DatasetTool to update an existing BigQuery dataset using RFC5789 PATCH semantics.
  • Patch BigQuery ML ModelTool to update specific fields in an existing BigQuery ML model using PATCH semantics.
  • Patch BigQuery TableTool to update specific fields in an existing BigQuery table using RFC5789 PATCH semantics.
  • Undelete BigQuery DatasetTool to undelete a BigQuery dataset within the time travel window.
  • Update BigQuery DatasetTool to update information in an existing BigQuery dataset using the PUT method.
  • Update BigQuery TableTool to update an existing BigQuery table.
  • Cancel BigQuery JobTool to cancel a running BigQuery job.
  • Create Capacity CommitmentTool to create a new capacity commitment resource in BigQuery Reservation.
  • Create BigQuery ConnectionTool to create a new BigQuery connection to external data sources using the BigQuery Connection API.
  • Create Analytics Hub Data ExchangeTool to create a new Analytics Hub data exchange for sharing BigQuery datasets.
  • Create Analytics Hub ListingTool to create a new listing in a data exchange using Analytics Hub API.
  • 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.
  • Create Analytics Hub Query TemplateTool to create a new query template in a BigQuery Analytics Hub Data Clean Room (DCR) data exchange.
  • Create BigQuery ReservationTool to create a new BigQuery reservation resource to guarantee compute capacity (slots) for query and pipeline jobs.
  • Create BigQuery Reservation AssignmentTool to create a BigQuery reservation assignment that allows a project, folder, or organization to submit jobs using slots from a specified reservation.
  • Delete BigQuery Job MetadataTool to delete the metadata of a BigQuery job.
  • Delete BigQuery RoutineTool to delete a BigQuery routine by its ID.
  • QueryRuns a SQL query in BigQuery using the REST API, including statements that can modify data.
  • Set BigQuery Routine IAM PolicyTool to set the IAM access control policy for a BigQuery routine resource.
  • Update BigQuery ConnectionTool to update a specified BigQuery connection using the BigQuery Connection API.
  • Update BigQuery RoutineTool to update an existing BigQuery routine (function or stored procedure).
Google BigQuery integration · Quilt