> ## Documentation Index > Fetch the complete documentation index at: https://docs.boxd.sh/llms.txt > Use this file to discover all available pages before exploring further. # 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 Google BigQuery is a fully managed data warehouse for large-scale data analytics, offering fast SQL queries and machine learning capabilities on massive datasets `googlebigquery` · **63 tools** · no triggers ## Connect it ```bash theme={"theme":"github-dark"} run auth googlebigquery run auth googlebigquery --scope team # shared with the organization ``` Or from the [Integrations page](https://app.boxd.sh/integrations) in the console. See [Connections](/guides/integrations/connections) for personal versus shared, and who may remove one. ## Use it ```bash theme={"theme":"github-dark"} run googlebigquery # common commands run googlebigquery --all # every command ``` ```ts theme={"theme":"github-dark"} import { googlebigquery } from "@boxd/run"; ``` ## Common tools | Tool | What it does | | ------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `create-dataexchanges-listings` | Tool to create a new listing in a BigQuery Analytics Hub data exchange. | | `create-dataset` | Tool to create a new BigQuery dataset with explicit location, labels, and description using the BigQuery Datasets API. | | `create-routine` | Tool to create a new user-defined routine (function or procedure) in a BigQuery dataset. | | `create-table` | Tool to create a new, empty table in a BigQuery dataset. Use when setting up data infrastructure for standard tables, external tables, views, or materialized views. | | `delete-dataset` | Tool to delete a BigQuery dataset specified by datasetId via the datasets.delete API. | | `delete-model` | Tool to delete a BigQuery ML model from a dataset. Use when you need to remove a trained machine learning model permanently. | | `delete-table` | Tool to delete a BigQuery table from a dataset. Use when you need to remove a table and all its data permanently. | | `get-dataset` | Tool to retrieve BigQuery dataset metadata including location via the datasets.get API. | | `get-job` | Tool to retrieve information about a specific BigQuery job. Returns job configuration, status, and statistics. | | `get-query-results` | Tool to get the results of a BigQuery query job via RPC. Use this to retrieve results after running a query, or to check job completion status and... | | `get-table-schema` | Tool to fetch a BigQuery table's schema and metadata without querying row data. | | `insert-all` | Tool to stream data into BigQuery one record at a time without running a load job. | | `insert-job` | Tool to start a new asynchronous BigQuery job (query, load, extract, or copy). | | `insert-job-with-upload` | Tool to start a new BigQuery load job with file upload. Uploads a file (CSV, JSON, etc.) and loads it into a BigQuery table in a single operation. | | `list-datasets` | Tool to list datasets in a specific BigQuery project, including dataset locations. | | `list-jobs` | Tool to list all jobs that you started in a BigQuery project. | | `list-models` | Tool to list all BigQuery ML models in a specified dataset. Requires READER dataset role. | | `list-projects` | Tool to list BigQuery projects to which the user has been granted any project role. | | `list-table-data` | Tool to list the content of a BigQuery table in rows via the REST API. | | `list-tables` | Tool to list tables in a BigQuery dataset via the REST API. Use this early in exploration to discover accessible tables without relying on... | | `patch-dataset` | Tool to update an existing BigQuery dataset using RFC5789 PATCH semantics. | | `patch-model` | Tool to update specific fields in an existing BigQuery ML model using PATCH semantics. | | `patch-table` | Tool to update specific fields in an existing BigQuery table using RFC5789 PATCH semantics. | | `undelete-dataset` | Tool to undelete a BigQuery dataset within the time travel window. | | `update-dataset` | Tool to update information in an existing BigQuery dataset using the PUT method. | | Tool | What it does | | ---------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `cancel-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. | | `create-capacity-commitment` | Tool to create a new capacity commitment resource in BigQuery Reservation. | | `create-connection` | Tool to create a new BigQuery connection to external data sources using the BigQuery Connection API. | | `create-data-exchange` | Tool to create a new Analytics Hub data exchange for sharing BigQuery datasets. | | `create-dataexchanges-listings` | Tool to create a new listing in a BigQuery Analytics Hub data exchange. | | `create-dataset` | Tool to create a new BigQuery dataset with explicit location, labels, and description using the BigQuery Datasets API. | | `create-listing` | Tool to create a new listing in a data exchange using Analytics Hub API. | | `create-locations-datapolicies` | Tool to create a new data policy under a project with specified location using the v2beta1 BigQuery Data Policy API. | | `create-query-template` | Tool to create a new query template in a BigQuery Analytics Hub Data Clean Room (DCR) data exchange. | | `create-reservation` | Tool to create a new BigQuery reservation resource to guarantee compute capacity (slots) for query and pipeline jobs. | | `create-reservation-assignment` | Tool to create a BigQuery reservation assignment that allows a project, folder, or organization to submit jobs using slots from a specified reservation. | | `create-routine` | Tool to create a new user-defined routine (function or procedure) in a BigQuery dataset. | | `create-table` | Tool to create a new, empty table in a BigQuery dataset. Use when setting up data infrastructure for standard tables, external tables, views, or materialized views. | | `delete-dataset` | Tool to delete a BigQuery dataset specified by datasetId via the datasets.delete API. | | `delete-job-metadata` | Tool to delete the metadata of a BigQuery job. Use when you need to remove job metadata from the system. | | `delete-model` | Tool to delete a BigQuery ML model from a dataset. Use when you need to remove a trained machine learning model permanently. | | `delete-routine` | Tool to delete a BigQuery routine by its ID. Use when you need to remove a stored procedure, user-defined function, or table function from a dataset. | | `delete-table` | Tool to delete a BigQuery table from a dataset. Use when you need to remove a table and all its data permanently. | | `get-bigquery-model` | Tool to retrieve a specific BigQuery ML model resource by model ID. | | `get-connection-iam-policy` | Tool to get the IAM access control policy for a BigQuery connection resource. | | `get-dataset` | Tool to retrieve BigQuery dataset metadata including location via the datasets.get API. | | `get-job` | Tool to retrieve information about a specific BigQuery job. Returns job configuration, status, and statistics. | | `get-query-results` | Tool to get the results of a BigQuery query job via RPC. Use this to retrieve results after running a query, or to check job completion status and... | | `get-routine` | Tool to retrieve a BigQuery routine (user-defined function or stored procedure) by its ID. | | `get-routine-iam-policy` | Tool to retrieve the IAM access control policy for a BigQuery routine resource. | | `get-service-account` | Tool to get the service account for a project used for interactions with Google Cloud KMS. | | `get-table-iam-policy` | Tool to retrieve the IAM access control policy for a BigQuery table resource. | | `get-table-schema` | Tool to fetch a BigQuery table's schema and metadata without querying row data. | | `insert-all` | Tool to stream data into BigQuery one record at a time without running a load job. | | `insert-job` | Tool to start a new asynchronous BigQuery job (query, load, extract, or copy). | | `insert-job-with-upload` | Tool to start a new BigQuery load job with file upload. Uploads a file (CSV, JSON, etc.) and loads it into a BigQuery table in a single operation. | | `list-analytics-hub-listings` | Tool to list all listings in a given Analytics Hub data exchange. | | `list-big-query-connections` | Tool to list BigQuery connections in a given project and location. | | `list-capacity-commitments` | Tool to list all capacity commitments for the admin project. | | `list-dataexchanges-listings` | Tool to list all listings in a given Analytics Hub data exchange using the v1beta1 API. | | `list-datasets` | Tool to list datasets in a specific BigQuery project, including dataset locations. | | `list-jobs` | Tool to list all jobs that you started in a BigQuery project. | | `list-locations` | Tool to list information about supported locations for BigQuery Data Transfer Service. | | `list-locations-connections` | Tool to list BigQuery connections in a given project and location using the v1beta1 API. | | `list-locations-datapolicies` | Tool to list all data policies in a specified parent project and location using the v2beta1 API. | | `list-models` | Tool to list all BigQuery ML models in a specified dataset. Requires READER dataset role. | | `list-organization-data-exchanges` | Tool to list all data exchanges from projects in a given organization and location using Analytics Hub API. | | `list-projects` | Tool to list BigQuery projects to which the user has been granted any project role. | | `list-query-templates` | Tool to list all query templates in a given Analytics Hub data exchange. | | `list-reservation-assignments` | Tool to list BigQuery reservation assignments. Only explicitly created assignments will be returned (no expansion or merge happens). | | `list-reservation-groups` | Tool to list all BigQuery reservation groups for a project in a specified location. | | `list-reservations` | Tool to list all BigQuery reservations for a project in a specified location. | | `list-routines` | Tool to list all routines (user-defined functions and stored procedures) in a BigQuery dataset. | | `list-row-access-policies` | Tool to list all row access policies on a specified BigQuery table. | | `list-table-data` | Tool to list the content of a BigQuery table in rows via the REST API. | | `list-tables` | Tool to list tables in a BigQuery dataset via the REST API. Use this early in exploration to discover accessible tables without relying on... | | `patch-dataset` | Tool to update an existing BigQuery dataset using RFC5789 PATCH semantics. | | `patch-model` | Tool to update specific fields in an existing BigQuery ML model using PATCH semantics. | | `patch-table` | Tool to update specific fields in an existing BigQuery table using RFC5789 PATCH semantics. | | `query` | Query Tool runs a SQL query in BigQuery using the REST API. Use proper BigQuery SQL syntax, e.g., SELECT \* FROM `project.dataset.table` WHERE column\_name = 'value'. | | `search-all-assignments` | Tool to search all BigQuery reservation assignments for a specified resource in a particular region. | | `set-routine-iam-policy` | Tool to set the IAM access control policy for a BigQuery routine resource. | | `test-routine-iam-permissions` | Tool to test which IAM permissions the caller has on a BigQuery routine. | | `undelete-dataset` | Tool to undelete a BigQuery dataset within the time travel window. | | `update-connection` | Tool to update a specified BigQuery connection using the BigQuery Connection API. | | `update-dataset` | Tool to update information in an existing BigQuery dataset using the PUT method. | | `update-routine` | Tool to update an existing BigQuery routine (function or stored procedure). | | `update-table` | Tool to update an existing BigQuery table. The update method replaces the entire Table resource, whereas the patch method only replaces fields that are provided. | [Open Google BigQuery in the console →](https://app.boxd.sh/integrations/detail/googlebigquery)