Google BigQuery API Operations Reference

other

63 operations

ActionGOOGLEBIGQUERY_CANCEL_JOB

Cancel BigQuery Job

Tool to cancel a running BigQuery job.

3 input

ActionGOOGLEBIGQUERY_CREATE_DATA_EXCHANGE

Create Analytics Hub Data Exchange

Tool to create a new Analytics Hub data exchange for sharing BigQuery datasets.

8 input

ActionGOOGLEBIGQUERY_CREATE_LISTING

Create Analytics Hub Listing

Tool to create a new listing in a data exchange using Analytics Hub API.

24 input

ActionGOOGLEBIGQUERY_CREATE_DATAEXCHANGES_LISTINGS

Create Analytics Hub Listing

Tool to create a new listing in a BigQuery Analytics Hub data exchange.

11 input

ActionGOOGLEBIGQUERY_CREATE_QUERY_TEMPLATE

Create Analytics Hub Query Template

Tool to create a new query template in a BigQuery Analytics Hub Data Clean Room (DCR) data exchange.

5 input

ActionGOOGLEBIGQUERY_CREATE_CONNECTION

Create BigQuery Connection

Tool to create a new BigQuery connection to external data sources using the BigQuery Connection API.

12 input

ActionGOOGLEBIGQUERY_CREATE_LOCATIONS_DATAPOLICIES

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.

3 input

ActionGOOGLEBIGQUERY_CREATE_DATASET

Create BigQuery Dataset

Tool to create a new BigQuery dataset with explicit location, labels, and description using the BigQuery Datasets API.

9 input

ActionGOOGLEBIGQUERY_CREATE_RESERVATION

Create BigQuery Reservation

Tool to create a new BigQuery reservation resource to guarantee compute capacity (slots) for query and pipeline jobs.

8 input

ActionGOOGLEBIGQUERY_CREATE_RESERVATION_ASSIGNMENT

Create BigQuery 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.

4 input

ActionGOOGLEBIGQUERY_CREATE_ROUTINE

Create BigQuery Routine

Tool to create a new user-defined routine (function or procedure) in a BigQuery dataset.

17 input

ActionGOOGLEBIGQUERY_CREATE_TABLE

Create BigQuery Table

Tool to create a new, empty table in a BigQuery dataset.

17 input

ActionGOOGLEBIGQUERY_CREATE_CAPACITY_COMMITMENT

Create Capacity Commitment

Tool to create a new capacity commitment resource in BigQuery Reservation.

8 input

ActionGOOGLEBIGQUERY_DELETE_DATASET

Delete BigQuery Dataset

Tool to delete a BigQuery dataset specified by datasetId via the datasets.delete API.

3 input

ActionGOOGLEBIGQUERY_DELETE_JOB_METADATA

Delete BigQuery Job Metadata

Tool to delete the metadata of a BigQuery job.

3 input

ActionGOOGLEBIGQUERY_DELETE_MODEL

Delete BigQuery ML Model

Tool to delete a BigQuery ML model from a dataset.

3 input

ActionGOOGLEBIGQUERY_DELETE_ROUTINE

Delete BigQuery Routine

Tool to delete a BigQuery routine by its ID.

3 input

ActionGOOGLEBIGQUERY_DELETE_TABLE

Delete BigQuery Table

Tool to delete a BigQuery table from a dataset.

3 input

ActionGOOGLEBIGQUERY_GET_CONNECTION_IAM_POLICY

Get BigQuery Connection IAM Policy

Tool to get the IAM access control policy for a BigQuery connection resource.

2 input

ActionGOOGLEBIGQUERY_GET_DATASET

Get BigQuery Dataset Metadata

Tool to retrieve BigQuery dataset metadata including location via the datasets.get API.

4 input

ActionGOOGLEBIGQUERY_GET_JOB

Get BigQuery Job

Tool to retrieve information about a specific BigQuery job.

3 input

ActionGOOGLEBIGQUERY_GET_BIGQUERY_MODEL

Get BigQuery ML Model

Tool to retrieve a specific BigQuery ML model resource by model ID.

3 input

ActionGOOGLEBIGQUERY_GET_QUERY_RESULTS

Get BigQuery Query Results

Tool to get the results of a BigQuery query job via RPC.

19 input

ActionGOOGLEBIGQUERY_GET_ROUTINE

Get BigQuery Routine

Tool to retrieve a BigQuery routine (user-defined function or stored procedure) by its ID.

4 input

ActionGOOGLEBIGQUERY_GET_ROUTINE_IAM_POLICY

Get BigQuery Routine IAM Policy

Tool to retrieve the IAM access control policy for a BigQuery routine resource.

4 input

ActionGOOGLEBIGQUERY_GET_SERVICE_ACCOUNT

Get BigQuery Service Account

Tool to get the service account for a project used for interactions with Google Cloud KMS.

12 input

ActionGOOGLEBIGQUERY_GET_TABLE_IAM_POLICY

Get BigQuery Table IAM Policy

Tool to retrieve the IAM access control policy for a BigQuery table resource.

2 input

ActionGOOGLEBIGQUERY_GET_TABLE_SCHEMA

Get BigQuery Table Schema

Tool to fetch a BigQuery table's schema and metadata without querying row data.

4 input

ActionGOOGLEBIGQUERY_INSERT_JOB

Insert BigQuery Job

Tool to start a new asynchronous BigQuery job (query, load, extract, or copy).

3 input

ActionGOOGLEBIGQUERY_INSERT_JOB_WITH_UPLOAD

Insert BigQuery Job with Upload

Tool to start a new BigQuery load job with file upload.

4 input

ActionGOOGLEBIGQUERY_INSERT_ALL

Insert Data into BigQuery Table

Tool to stream data into BigQuery one record at a time without running a load job.

8 input

ActionGOOGLEBIGQUERY_LIST_ANALYTICS_HUB_LISTINGS

List Analytics Hub Listings

Tool to list all listings in a given Analytics Hub data exchange.

14 input

ActionGOOGLEBIGQUERY_LIST_QUERY_TEMPLATES

List Analytics Hub Query Templates

Tool to list all query templates in a given Analytics Hub data exchange.

3 input

ActionGOOGLEBIGQUERY_LIST_CAPACITY_COMMITMENTS

List BigQuery Capacity Commitments

Tool to list all capacity commitments for the admin project.

3 input

ActionGOOGLEBIGQUERY_LIST_BIG_QUERY_CONNECTIONS

List BigQuery Connections

Tool to list BigQuery connections in a given project and location.

3 input

ActionGOOGLEBIGQUERY_LIST_LOCATIONS

List BigQuery Data Transfer Locations

Tool to list information about supported locations for BigQuery Data Transfer Service.

4 input

ActionGOOGLEBIGQUERY_LIST_DATASETS

List BigQuery Datasets

Tool to list datasets in a specific BigQuery project, including dataset locations.

5 input

ActionGOOGLEBIGQUERY_LIST_JOBS

List BigQuery Jobs

Tool to list all jobs that you started in a BigQuery project.

9 input

ActionGOOGLEBIGQUERY_LIST_LOCATIONS_DATAPOLICIES

List BigQuery Location Data Policies

Tool to list all data policies in a specified parent project and location using the v2beta1 API.

4 input

ActionGOOGLEBIGQUERY_LIST_MODELS

List BigQuery Models

Tool to list all BigQuery ML models in a specified dataset.

4 input

ActionGOOGLEBIGQUERY_LIST_PROJECTS

List BigQuery Projects

Tool to list BigQuery projects to which the user has been granted any project role.

2 input

ActionGOOGLEBIGQUERY_LIST_RESERVATION_ASSIGNMENTS

List BigQuery Reservation Assignments

Tool to list BigQuery reservation assignments.

3 input

ActionGOOGLEBIGQUERY_LIST_RESERVATION_GROUPS

List BigQuery Reservation Groups

Tool to list all BigQuery reservation groups for a project in a specified location.

3 input

ActionGOOGLEBIGQUERY_LIST_RESERVATIONS

List BigQuery Reservations

Tool to list all BigQuery reservations for a project in a specified location.

14 input

ActionGOOGLEBIGQUERY_LIST_ROUTINES

List BigQuery Routines

Tool to list all routines (user-defined functions and stored procedures) in a BigQuery dataset.

6 input

ActionGOOGLEBIGQUERY_LIST_ROW_ACCESS_POLICIES

List BigQuery Row Access Policies

Tool to list all row access policies on a specified BigQuery table.

5 input

ActionGOOGLEBIGQUERY_LIST_TABLE_DATA

List BigQuery Table Data

Tool to list the content of a BigQuery table in rows via the REST API.

8 input

ActionGOOGLEBIGQUERY_LIST_TABLES

List BigQuery Tables

Tool to list tables in a BigQuery dataset via the REST API.

4 input

ActionGOOGLEBIGQUERY_LIST_LOCATIONS_CONNECTIONS

List Connections in Location

Tool to list BigQuery connections in a given project and location using the v1beta1 API.

3 input

ActionGOOGLEBIGQUERY_LIST_DATAEXCHANGES_LISTINGS

List Data Exchange Listings

Tool to list all listings in a given Analytics Hub data exchange using the v1beta1 API.

14 input

ActionGOOGLEBIGQUERY_LIST_ORGANIZATION_DATA_EXCHANGES

List Organization Data Exchanges

Tool to list all data exchanges from projects in a given organization and location using Analytics Hub API.

14 input

ActionGOOGLEBIGQUERY_PATCH_DATASET

Patch BigQuery Dataset

Tool to update an existing BigQuery dataset using RFC5789 PATCH semantics.

18 input

ActionGOOGLEBIGQUERY_PATCH_MODEL

Patch BigQuery ML Model

Tool to update specific fields in an existing BigQuery ML model using PATCH semantics.

8 input

ActionGOOGLEBIGQUERY_PATCH_TABLE

Patch BigQuery Table

Tool to update specific fields in an existing BigQuery table using RFC5789 PATCH semantics.

9 input

ActionGOOGLEBIGQUERY_QUERY

Query

Query Tool runs a SQL query in BigQuery using the REST API.

6 input

ActionGOOGLEBIGQUERY_SEARCH_ALL_ASSIGNMENTS

Search All BigQuery Reservation Assignments

Tool to search all BigQuery reservation assignments for a specified resource in a particular region.

15 input

ActionGOOGLEBIGQUERY_SET_ROUTINE_IAM_POLICY

Set BigQuery Routine IAM Policy

Tool to set the IAM access control policy for a BigQuery routine resource.

5 input

ActionGOOGLEBIGQUERY_TEST_ROUTINE_IAM_PERMISSIONS

Test BigQuery Routine IAM Permissions

Tool to test which IAM permissions the caller has on a BigQuery routine.

4 input

ActionGOOGLEBIGQUERY_UNDELETE_DATASET

Undelete BigQuery Dataset

Tool to undelete a BigQuery dataset within the time travel window.

3 input

ActionGOOGLEBIGQUERY_UPDATE_CONNECTION

Update BigQuery Connection

Tool to update a specified BigQuery connection using the BigQuery Connection API.

12 input

ActionGOOGLEBIGQUERY_UPDATE_DATASET

Update BigQuery Dataset

Tool to update information in an existing BigQuery dataset using the PUT method.

18 input

ActionGOOGLEBIGQUERY_UPDATE_ROUTINE

Update BigQuery Routine

Tool to update an existing BigQuery routine (function or stored procedure).

18 input

ActionGOOGLEBIGQUERY_UPDATE_TABLE

Update BigQuery Table

Tool to update an existing BigQuery table.

17 input