googlebigquery · 63 tools · no triggers
Connect it
run auth googlebigquery
run auth googlebigquery --scope team # shared with the organization
Use it
run googlebigquery # common commands
run googlebigquery --all # every command
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. |
All 63 tools
All 63 tools
| 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. |