Open Connector
← All tools

BigQuery logoBigQuery

BigQuery is the autonomous data and AI platform, automating the entire data life cycle so you can go from data to AI to action faster.

googlebigqueryvcatalog-v142 tools

Authentication

MethodKindStatusDetails
OAuth 2.0oauth2available—

Call a tool

import { createClient } from "@open-connector/sdk";const oc = createClient({  baseUrl: "https://api.openconnector.dev",  apiKey: process.env.OPEN_CONNECTOR_API_KEY!,});const result = await oc.executeTool({  slug: "GOOGLEBIGQUERY_BIGQUERY_DATASETS_DELETE",  connectedAccountId: "conn_...",  arguments: { /* match this tool's input schema */ },});
import Composio from "@composio/client";const composio = new Composio({  baseURL: "https://api.openconnector.dev/composio",  apiKey: process.env.OPEN_CONNECTOR_API_KEY!,});const result = await composio.tools.execute("GOOGLEBIGQUERY_BIGQUERY_DATASETS_DELETE", {  connected_account_id: "conn_...",  arguments: { /* match this tool's input schema */ },});
oc tools execute GOOGLEBIGQUERY_BIGQUERY_DATASETS_DELETE --data '{ }'

Tool catalog

Available tools

42 callable operations

Bigquery Datasets DeleteGOOGLEBIGQUERY_BIGQUERY_DATASETS_DELETEDeletes the dataset specified by the datasetId value. Before you can delete a dataset, you must delete all its tables, either manually or by specifying deleteContents. Immediately after deletion, you can create another dataset with the same name. # IAM Permissions Requires the `bigquery.datasets.delete` permission on the dataset.

Deletes the dataset specified by the datasetId value. Before you can delete a dataset, you must delete all its tables, either manually or by specifying deleteContents. Immediately after deletion, you can create another dataset with the same name. # IAM Permissions Requires the `bigquery.datasets.delete` permission on the dataset.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

datasets
Bigquery Datasets GetGOOGLEBIGQUERY_BIGQUERY_DATASETS_GETReturns the dataset specified by datasetID. # IAM Permissions Requires the `bigquery.datasets.get` permission on the dataset.

Returns the dataset specified by datasetID. # IAM Permissions Requires the `bigquery.datasets.get` permission on the dataset.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/cloud-platform.read-only

Tags

datasets
Bigquery Datasets InsertGOOGLEBIGQUERY_BIGQUERY_DATASETS_INSERTCreates a new empty dataset. # IAM Permissions Requires the `bigquery.datasets.create` permission on the project.

Creates a new empty dataset. # IAM Permissions Requires the `bigquery.datasets.create` permission on the project.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

datasets
Bigquery Datasets ListGOOGLEBIGQUERY_BIGQUERY_DATASETS_LISTLists all datasets in the specified project to which the user has been granted the READER dataset role. # IAM Permissions Requires no specific IAM permission(s) to use this method. Results are filtered to only include datasets on which the caller has the `bigquery.datasets.get` permission.

Lists all datasets in the specified project to which the user has been granted the READER dataset role. # IAM Permissions Requires no specific IAM permission(s) to use this method. Results are filtered to only include datasets on which the caller has the `bigquery.datasets.get` permission.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/cloud-platform.read-only

Tags

datasets
Bigquery Datasets PatchGOOGLEBIGQUERY_BIGQUERY_DATASETS_PATCHUpdates information in an existing dataset. The update method replaces the entire dataset resource, whereas the patch method only replaces fields that are provided in the submitted dataset resource. This method supports RFC5789 patch semantics. # IAM Permissions Requires the following IAM permission(s) to use this method: - `bigquery.datasets.update` on the dataset. - `bigquery.datasets.get` on the dataset.

Updates information in an existing dataset. The update method replaces the entire dataset resource, whereas the patch method only replaces fields that are provided in the submitted dataset resource. This method supports RFC5789 patch semantics. # IAM Permissions Requires the following IAM permission(s) to use this method: - `bigquery.datasets.update` on the dataset. - `bigquery.datasets.get` on the dataset.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

datasets
Bigquery Datasets UndeleteGOOGLEBIGQUERY_BIGQUERY_DATASETS_UNDELETEUndeletes a dataset which is within time travel window based on datasetId. If a time is specified, the dataset version deleted at that time is undeleted, else the last live version is undeleted. # IAM Permissions Requires the following IAM permission(s) to use this method: - `bigquery.datasets.create` on the project. - `bigquery.datasets.get` on the dataset.

Undeletes a dataset which is within time travel window based on datasetId. If a time is specified, the dataset version deleted at that time is undeleted, else the last live version is undeleted. # IAM Permissions Requires the following IAM permission(s) to use this method: - `bigquery.datasets.create` on the project. - `bigquery.datasets.get` on the dataset.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

datasets
Bigquery Datasets UpdateGOOGLEBIGQUERY_BIGQUERY_DATASETS_UPDATEUpdates information in an existing dataset. The update method replaces the entire dataset resource, whereas the patch method only replaces fields that are provided in the submitted dataset resource. # IAM Permissions Requires the `bigquery.datasets.update` permission on the dataset.

Updates information in an existing dataset. The update method replaces the entire dataset resource, whereas the patch method only replaces fields that are provided in the submitted dataset resource. # IAM Permissions Requires the `bigquery.datasets.update` permission on the dataset.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

datasets
Bigquery Jobs CancelGOOGLEBIGQUERY_BIGQUERY_JOBS_CANCELRequests that a job be cancelled. This call will return immediately, and the client will need to poll for the job status to see if the cancel completed successfully. Cancelled jobs may still incur costs. # IAM Permissions Requires the `bigquery.jobs.update` permission on the job resource. If the user matches the creator of the job, the `bigquery.jobs.create` permission on the project is required instead.

Requests that a job be cancelled. This call will return immediately, and the client will need to poll for the job status to see if the cancel completed successfully. Cancelled jobs may still incur costs. # IAM Permissions Requires the `bigquery.jobs.update` permission on the job resource. If the user matches the creator of the job, the `bigquery.jobs.create` permission on the project is required instead.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

jobs
Bigquery Jobs DeleteGOOGLEBIGQUERY_BIGQUERY_JOBS_DELETERequests the deletion of the metadata of a job. This call returns when the job's metadata is deleted. # IAM Permissions Requires the `bigquery.jobs.delete` permission on the job resource.

Requests the deletion of the metadata of a job. This call returns when the job's metadata is deleted. # IAM Permissions Requires the `bigquery.jobs.delete` permission on the job resource.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

jobs
Bigquery Jobs GetGOOGLEBIGQUERY_BIGQUERY_JOBS_GETReturns information about a specific job. Job information is available for a six month period after creation. Requires that you're the person who ran the job, or have the Is Owner project role. # IAM Permissions Requires the `bigquery.jobs.get` permission on the job resource. If the user matches the creator of the job, the `bigquery.jobs.create` permission on the project is required instead.

Returns information about a specific job. Job information is available for a six month period after creation. Requires that you're the person who ran the job, or have the Is Owner project role. # IAM Permissions Requires the `bigquery.jobs.get` permission on the job resource. If the user matches the creator of the job, the `bigquery.jobs.create` permission on the project is required instead.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/cloud-platform.read-only

Tags

jobs
Bigquery Jobs GetQueryResultsGOOGLEBIGQUERY_BIGQUERY_JOBS_GET_QUERY_RESULTSRPC to get the results of a query job. # IAM Permissions Requires the following IAM permission(s) to use this method: - `bigquery.jobs.get` on the job. - `bigquery.tables.getData` on the destination table. If the user matches the creator of the job, the following IAM permission(s) are required instead: - `bigquery.jobs.create` on the project. - `bigquery.tables.getData` on the destination table.

RPC to get the results of a query job. # IAM Permissions Requires the following IAM permission(s) to use this method: - `bigquery.jobs.get` on the job. - `bigquery.tables.getData` on the destination table. If the user matches the creator of the job, the following IAM permission(s) are required instead: - `bigquery.jobs.create` on the project. - `bigquery.tables.getData` on the destination table.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/cloud-platform.read-only

Tags

jobs
Bigquery Jobs InsertGOOGLEBIGQUERY_BIGQUERY_JOBS_INSERTStarts a new asynchronous job. This API has two different kinds of endpoint URIs, as this method supports a variety of use cases. * The *Metadata* URI is used for most interactions, as it accepts the job configuration directly. * The *Upload* URI is ONLY for the case when you're sending both a load job configuration and a data stream together. In this case, the Upload URI accepts the job configuration and the data as two distinct multipart MIME parts. # IAM Permissions Requires the `bigquery.jobs.create` permission on the project resource. Additional permissions are required depending on the job type: - **Load, Export, and Copy jobs**: Generally require data-level permissions such as `bigquery.tables.export` or access to external storage. - **Query jobs**: Permissions are dependent on the SQL statement. Complex queries (DDL, DCL) may require additional permissions to create reservations, modify IAM policies, or update project settings.

Starts a new asynchronous job. This API has two different kinds of endpoint URIs, as this method supports a variety of use cases. * The *Metadata* URI is used for most interactions, as it accepts the job configuration directly. * The *Upload* URI is ONLY for the case when you're sending both a load job configuration and a data stream together. In this case, the Upload URI accepts the job configuration and the data as two distinct multipart MIME parts. # IAM Permissions Requires the `bigquery.jobs.create` permission on the project resource. Additional permissions are required depending on the job type: - **Load, Export, and Copy jobs**: Generally require data-level permissions such as `bigquery.tables.export` or access to external storage. - **Query jobs**: Permissions are dependent on the SQL statement. Complex queries (DDL, DCL) may require additional permissions to create reservations, modify IAM policies, or update project settings.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/devstorage.full_controlhttps://www.googleapis.com/auth/devstorage.read_onlyhttps://www.googleapis.com/auth/devstorage.read_write

Tags

jobs
Bigquery Jobs ListGOOGLEBIGQUERY_BIGQUERY_JOBS_LISTLists all jobs that you started in the specified project. Job information is available for a six month period after creation. The job list is sorted in reverse chronological order, by job creation time. Requires the Can View project role, or the Is Owner project role if you set the allUsers property. # IAM Permissions Requires no specific IAM permission(s) to use this method. Users are able to list the jobs they created. Additional access is granted based on the following permissions: - Users with the `bigquery.jobs.listAll` permission can list all jobs with all metadata. - Users with the `bigquery.jobs.list` permission can list all jobs, but with redacted information for jobs they did not create.

Lists all jobs that you started in the specified project. Job information is available for a six month period after creation. The job list is sorted in reverse chronological order, by job creation time. Requires the Can View project role, or the Is Owner project role if you set the allUsers property. # IAM Permissions Requires no specific IAM permission(s) to use this method. Users are able to list the jobs they created. Additional access is granted based on the following permissions: - Users with the `bigquery.jobs.listAll` permission can list all jobs with all metadata. - Users with the `bigquery.jobs.list` permission can list all jobs, but with redacted information for jobs they did not create.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/cloud-platform.read-only

Tags

jobs
Bigquery Jobs QueryGOOGLEBIGQUERY_BIGQUERY_JOBS_QUERYRuns a BigQuery SQL query synchronously and returns query results if the query completes within a specified timeout. # IAM Permissions Requires the `bigquery.jobs.create` permission on the project resource. Data-level permissions are highly dependent on the SQL statement being executed. While standard queries require data access (such as `bigquery.tables.getData`), complex operations like DDL or DCL may require permissions to manage reservations, IAM policies, or project settings.

Runs a BigQuery SQL query synchronously and returns query results if the query completes within a specified timeout. # IAM Permissions Requires the `bigquery.jobs.create` permission on the project resource. Data-level permissions are highly dependent on the SQL statement being executed. While standard queries require data access (such as `bigquery.tables.getData`), complex operations like DDL or DCL may require permissions to manage reservations, IAM policies, or project settings.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/cloud-platform.read-only

Tags

jobs
Bigquery Models DeleteGOOGLEBIGQUERY_BIGQUERY_MODELS_DELETEDeletes the model specified by modelId from the dataset. # IAM Permissions Requires the `bigquery.models.delete` permission on the model.

Deletes the model specified by modelId from the dataset. # IAM Permissions Requires the `bigquery.models.delete` permission on the model.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

models
Bigquery Models GetGOOGLEBIGQUERY_BIGQUERY_MODELS_GETGets the specified model resource by model ID. # IAM Permissions Requires the `bigquery.models.getMetadata` permission on the model.

Gets the specified model resource by model ID. # IAM Permissions Requires the `bigquery.models.getMetadata` permission on the model.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/cloud-platform.read-only

Tags

models
Bigquery Models ListGOOGLEBIGQUERY_BIGQUERY_MODELS_LISTLists all models in the specified dataset. Requires the READER dataset role. After retrieving the list of models, you can get information about a particular model by calling the models.get method. # IAM Permissions Requires the `bigquery.models.list` permission on the dataset.

Lists all models in the specified dataset. Requires the READER dataset role. After retrieving the list of models, you can get information about a particular model by calling the models.get method. # IAM Permissions Requires the `bigquery.models.list` permission on the dataset.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/cloud-platform.read-only

Tags

models
Bigquery Models PatchGOOGLEBIGQUERY_BIGQUERY_MODELS_PATCHPatch specific fields in the specified model. # IAM Permissions Requires the `bigquery.models.updateMetadata` permission on the model.

Patch specific fields in the specified model. # IAM Permissions Requires the `bigquery.models.updateMetadata` permission on the model.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

models
Bigquery Projects GetServiceAccountGOOGLEBIGQUERY_BIGQUERY_PROJECTS_GET_SERVICE_ACCOUNTRPC to get the service account for a project used for interactions with Google Cloud KMS. Requires the `bigquery.jobs.create` permission on the project resource. This permission is required to authorize the retrieval of the project's service identity for technical management tasks like encryption configuration.

RPC to get the service account for a project used for interactions with Google Cloud KMS. Requires the `bigquery.jobs.create` permission on the project resource. This permission is required to authorize the retrieval of the project's service identity for technical management tasks like encryption configuration.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/cloud-platform.read-only

Tags

projects
Bigquery Projects ListGOOGLEBIGQUERY_BIGQUERY_PROJECTS_LISTRPC to list projects to which the user has been granted any project role. Users of this method are encouraged to consider the [Resource Manager](https://cloud.google.com/resource-manager/docs/) API, which provides the underlying data for this method and has more capabilities. # IAM Permissions Requires no specific IAM permission(s) to use this method. The results are filtered to only include projects on which the caller has been granted a project-level role such as a BigQuery predefined IAM role or a basic role such as Viewer or Owner.

RPC to list projects to which the user has been granted any project role. Users of this method are encouraged to consider the [Resource Manager](https://cloud.google.com/resource-manager/docs/) API, which provides the underlying data for this method and has more capabilities. # IAM Permissions Requires no specific IAM permission(s) to use this method. The results are filtered to only include projects on which the caller has been granted a project-level role such as a BigQuery predefined IAM role or a basic role such as Viewer or Owner.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/cloud-platform.read-only

Tags

projects
Bigquery Routines DeleteGOOGLEBIGQUERY_BIGQUERY_ROUTINES_DELETEDeletes the routine specified by routineId from the dataset. # IAM Permissions Requires the `bigquery.routines.delete` permission on the routine.

Deletes the routine specified by routineId from the dataset. # IAM Permissions Requires the `bigquery.routines.delete` permission on the routine.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

routines
Bigquery Routines GetGOOGLEBIGQUERY_BIGQUERY_ROUTINES_GETGets the specified routine resource by routine ID. # IAM Permissions Requires the `bigquery.routines.get` permission on the routine.

Gets the specified routine resource by routine ID. # IAM Permissions Requires the `bigquery.routines.get` permission on the routine.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/cloud-platform.read-only

Tags

routines
Bigquery Routines InsertGOOGLEBIGQUERY_BIGQUERY_ROUTINES_INSERTCreates a new routine in the dataset. # IAM Permissions Requires the `bigquery.routines.create` permission on the dataset.

Creates a new routine in the dataset. # IAM Permissions Requires the `bigquery.routines.create` permission on the dataset.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

routines
Bigquery Routines ListGOOGLEBIGQUERY_BIGQUERY_ROUTINES_LISTLists all routines in the specified dataset. Requires the READER dataset role. # IAM Permissions Requires the `bigquery.routines.list` permission on the dataset.

Lists all routines in the specified dataset. Requires the READER dataset role. # IAM Permissions Requires the `bigquery.routines.list` permission on the dataset.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/cloud-platform.read-only

Tags

routines
Bigquery Routines UpdateGOOGLEBIGQUERY_BIGQUERY_ROUTINES_UPDATEUpdates information in an existing routine. The update method replaces the entire Routine resource. # IAM Permissions Requires the `bigquery.routines.update` permission on the routine.

Updates information in an existing routine. The update method replaces the entire Routine resource. # IAM Permissions Requires the `bigquery.routines.update` permission on the routine.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

routines
Bigquery RowAccessPolicies BatchDeleteGOOGLEBIGQUERY_BIGQUERY_ROW_ACCESS_POLICIES_BATCH_DELETEDeletes provided row access policies. # IAM Permissions Requires the following IAM permission(s) on the table: - `bigquery.rowAccessPolicies.delete` - `bigquery.rowAccessPolicies.setIamPolicy`

Deletes provided row access policies. # IAM Permissions Requires the following IAM permission(s) on the table: - `bigquery.rowAccessPolicies.delete` - `bigquery.rowAccessPolicies.setIamPolicy`

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

rowaccesspolicies
Bigquery RowAccessPolicies DeleteGOOGLEBIGQUERY_BIGQUERY_ROW_ACCESS_POLICIES_DELETEDeletes a row access policy. # IAM Permissions Requires the following IAM permission(s) on the table: - `bigquery.rowAccessPolicies.delete` - `bigquery.rowAccessPolicies.setIamPolicy`

Deletes a row access policy. # IAM Permissions Requires the following IAM permission(s) on the table: - `bigquery.rowAccessPolicies.delete` - `bigquery.rowAccessPolicies.setIamPolicy`

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

rowaccesspolicies
Bigquery RowAccessPolicies GetGOOGLEBIGQUERY_BIGQUERY_ROW_ACCESS_POLICIES_GETGets the specified row access policy by policy ID. # IAM Permissions Requires the `bigquery.rowAccessPolicies.get` permission on the table.

Gets the specified row access policy by policy ID. # IAM Permissions Requires the `bigquery.rowAccessPolicies.get` permission on the table.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/cloud-platform.read-only

Tags

rowaccesspolicies
Bigquery RowAccessPolicies InsertGOOGLEBIGQUERY_BIGQUERY_ROW_ACCESS_POLICIES_INSERTCreates a row access policy. # IAM Permissions Requires the following IAM permission(s) on the table: - `bigquery.rowAccessPolicies.create` - `bigquery.rowAccessPolicies.setIamPolicy` - `bigquery.tables.getData`

Creates a row access policy. # IAM Permissions Requires the following IAM permission(s) on the table: - `bigquery.rowAccessPolicies.create` - `bigquery.rowAccessPolicies.setIamPolicy` - `bigquery.tables.getData`

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

rowaccesspolicies
Bigquery RowAccessPolicies ListGOOGLEBIGQUERY_BIGQUERY_ROW_ACCESS_POLICIES_LISTLists all row access policies on the specified table. # IAM Permissions Requires the `bigquery.rowAccessPolicies.list` permission on the table.

Lists all row access policies on the specified table. # IAM Permissions Requires the `bigquery.rowAccessPolicies.list` permission on the table.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/cloud-platform.read-only

Tags

rowaccesspolicies
Bigquery RowAccessPolicies UpdateGOOGLEBIGQUERY_BIGQUERY_ROW_ACCESS_POLICIES_UPDATEUpdates a row access policy. # IAM Permissions Requires the following IAM permission(s) on the table: - `bigquery.rowAccessPolicies.update` - `bigquery.rowAccessPolicies.setIamPolicy` - `bigquery.tables.getData`

Updates a row access policy. # IAM Permissions Requires the following IAM permission(s) on the table: - `bigquery.rowAccessPolicies.update` - `bigquery.rowAccessPolicies.setIamPolicy` - `bigquery.tables.getData`

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

rowaccesspolicies
Bigquery Tabledata InsertAllGOOGLEBIGQUERY_BIGQUERY_TABLEDATA_INSERT_ALLStreams data into BigQuery one record at a time without needing to run a load job. # IAM Permissions Requires the following IAM permission(s) to use this method: - `bigquery.tables.updateData` on the table. - `bigquery.tables.get` on the table. - `bigquery.datasets.get` on the dataset.

Streams data into BigQuery one record at a time without needing to run a load job. # IAM Permissions Requires the following IAM permission(s) to use this method: - `bigquery.tables.updateData` on the table. - `bigquery.tables.get` on the table. - `bigquery.datasets.get` on the dataset.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/bigquery.insertdatahttps://www.googleapis.com/auth/cloud-platform

Tags

tabledata
Bigquery Tabledata ListGOOGLEBIGQUERY_BIGQUERY_TABLEDATA_LISTList the content of a table in rows. # IAM Permissions Requires the `bigquery.tables.getData` permission on the table.

List the content of a table in rows. # IAM Permissions Requires the `bigquery.tables.getData` permission on the table.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/cloud-platform.read-only

Tags

tabledata
Bigquery Tables DeleteGOOGLEBIGQUERY_BIGQUERY_TABLES_DELETEDeletes the table specified by tableId from the dataset. If the table contains data, all the data will be deleted. # IAM Permissions Requires the `bigquery.tables.delete` permission on the table.

Deletes the table specified by tableId from the dataset. If the table contains data, all the data will be deleted. # IAM Permissions Requires the `bigquery.tables.delete` permission on the table.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

tables
Bigquery Tables GetGOOGLEBIGQUERY_BIGQUERY_TABLES_GETGets the specified table resource by table ID. This method does not return the data in the table, it only returns the table resource, which describes the structure of this table. # IAM Permissions Requires the `bigquery.tables.get` permission on the table.

Gets the specified table resource by table ID. This method does not return the data in the table, it only returns the table resource, which describes the structure of this table. # IAM Permissions Requires the `bigquery.tables.get` permission on the table.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/cloud-platform.read-only

Tags

tables
Bigquery Tables GetIamPolicyGOOGLEBIGQUERY_BIGQUERY_TABLES_GET_IAM_POLICYGets the access control policy for a resource. Returns an empty policy if the resource exists and does not have a policy set.

Gets the access control policy for a resource. Returns an empty policy if the resource exists and does not have a policy set.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/cloud-platform.read-only

Tags

tables
Bigquery Tables InsertGOOGLEBIGQUERY_BIGQUERY_TABLES_INSERTCreates a new, empty table in the dataset. # IAM Permissions Requires the `bigquery.tables.create` permission on the dataset.

Creates a new, empty table in the dataset. # IAM Permissions Requires the `bigquery.tables.create` permission on the dataset.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

tables
Bigquery Tables ListGOOGLEBIGQUERY_BIGQUERY_TABLES_LISTLists all tables in the specified dataset. Requires the READER dataset role. # IAM Permissions Requires the `bigquery.tables.list` permission on the dataset.

Lists all tables in the specified dataset. Requires the READER dataset role. # IAM Permissions Requires the `bigquery.tables.list` permission on the dataset.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/cloud-platform.read-only

Tags

tables
Bigquery Tables PatchGOOGLEBIGQUERY_BIGQUERY_TABLES_PATCHUpdates information in an existing table. The update method replaces the entire table resource, whereas the patch method only replaces fields that are provided in the submitted table resource. This method supports RFC5789 patch semantics. # IAM Permissions Requires the following IAM permission(s) on the table: - `bigquery.tables.update` - `bigquery.tables.get`

Updates information in an existing table. The update method replaces the entire table resource, whereas the patch method only replaces fields that are provided in the submitted table resource. This method supports RFC5789 patch semantics. # IAM Permissions Requires the following IAM permission(s) on the table: - `bigquery.tables.update` - `bigquery.tables.get`

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

tables
Bigquery Tables SetIamPolicyGOOGLEBIGQUERY_BIGQUERY_TABLES_SET_IAM_POLICYSets the access control policy on the specified resource. Replaces any existing policy. Can return `NOT_FOUND`, `INVALID_ARGUMENT`, and `PERMISSION_DENIED` errors.

Sets the access control policy on the specified resource. Replaces any existing policy. Can return `NOT_FOUND`, `INVALID_ARGUMENT`, and `PERMISSION_DENIED` errors.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

tables
Bigquery Tables TestIamPermissionsGOOGLEBIGQUERY_BIGQUERY_TABLES_TEST_IAM_PERMISSIONSReturns permissions that a caller has on the specified resource. If the resource does not exist, this will return an empty set of permissions, not a `NOT_FOUND` error. Note: This operation is designed to be used for building permission-aware UIs and command-line tools, not for authorization checking. This operation may "fail open" without warning.

Returns permissions that a caller has on the specified resource. If the resource does not exist, this will return an empty set of permissions, not a `NOT_FOUND` error. Note: This operation is designed to be used for building permission-aware UIs and command-line tools, not for authorization checking. This operation may "fail open" without warning.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platformhttps://www.googleapis.com/auth/cloud-platform.read-only

Tags

tables
Bigquery Tables UpdateGOOGLEBIGQUERY_BIGQUERY_TABLES_UPDATEUpdates information in an existing table. The update method replaces the entire Table resource, whereas the patch method only replaces fields that are provided in the submitted Table resource. # IAM Permissions Requires the `bigquery.tables.update` permission on the table.

Updates information in an existing table. The update method replaces the entire Table resource, whereas the patch method only replaces fields that are provided in the submitted Table resource. # IAM Permissions Requires the `bigquery.tables.update` permission on the table.

Authentication

Connected account required

Scopes

https://www.googleapis.com/auth/bigqueryhttps://www.googleapis.com/auth/cloud-platform

Tags

tables

Provider resources