> ## Documentation Index
> Fetch the complete documentation index at: https://docs.stackone.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Google BigQuery

> How to set up the Google BigQuery connector, plus the actions that are available.

![Google BigQuery](https://stackone-logos.com/api/google-bigquery/filled/svg)

v2.1.3[See changelog](https://docs.stackone.com/connectors/googlebigquery/changelog.md)

[41 actions](#actions) · 1 auth method

Databases
Analytics

## Getting Started

**1. Create or Select a Project**

Set up a new project or select an existing one. See [Organizations & Projects](https://docs.stackone.com/gateway/concepts/organizations-and-projects.md).

**2. Configure the Connector**

Enable the connector and create a Connector Profile in your project. See [Setup Connector Profile](https://docs.stackone.com/gateway/quickstart.md#setup-connector-profile).

> [card] [OAuth 2.0 · Connector Profile](https://docs.stackone.com/connectors/googlebigquery/guides/connector-profile/oauth-2-0.md)
>
> Delegated access on behalf of the signed-in Google user, using an OAuth client in a Google Cloud project.

**3. Link an Account**

Link an account [from the dashboard](https://docs.stackone.com/connect/managing-connectors/linking-accounts.md#link-from-the-dashboard) (or via [StackOne Hub](https://docs.stackone.com/embed/account-linking/overview)).

See the guide for the authentication type chosen in the Connector Profile:

> [card] [OAuth 2.0 · Link Account](https://docs.stackone.com/connectors/googlebigquery/guides/link-account/oauth-2-0.md)

**4. Use Actions**

Connect an AI platform to the linked account's actions. See [AI Platforms](https://docs.stackone.com/ai-platforms/overview.md).

Other ways to call actions are listed in [Protocols & SDKs](https://docs.stackone.com/connect/protocols-and-sdks.md).

## Actions

Scopes

Select all
|
Clear

https\://​www\.googleapis.com/auth/bigquery

No scopes found

41 actions

ActionDescriptionRequired scopes

List Datasets`googlebigquery_list_datasets`

Lists all datasets in the specified project

`https://​www.googleapis.com/auth/bigquery`

Get Dataset`googlebigquery_get_dataset`

Returns the dataset specified by datasetID

`https://​www.googleapis.com/auth/bigquery`

Create Dataset`googlebigquery_create_dataset`

Creates a new empty dataset

`https://​www.googleapis.com/auth/bigquery`

Patch Dataset`googlebigquery_patch_dataset`

Updates information in an existing dataset

`https://​www.googleapis.com/auth/bigquery`

Replace Dataset`googlebigquery_replace_dataset`

Replaces an existing dataset with a full resource update

`https://​www.googleapis.com/auth/bigquery`

Delete Dataset`googlebigquery_delete_dataset`

Deletes the dataset specified by datasetId

`https://​www.googleapis.com/auth/bigquery`

Undelete Dataset`googlebigquery_undelete_dataset`

Undeletes a dataset which is within time travel window

`https://​www.googleapis.com/auth/bigquery`

Get Table IAM Policy`googlebigquery_get_table_iam_policy`

Gets the IAM policy for the specified table

`https://​www.googleapis.com/auth/bigquery`

Set Table IAM Policy`googlebigquery_set_table_iam_policy`

Sets the IAM policy for the specified table

`https://​www.googleapis.com/auth/bigquery`

Test Routine IAM Permissions`googlebigquery_test_routine_iam_permissions`

Tests if the caller has the specified permissions on a routine

`https://​www.googleapis.com/auth/bigquery`

Get Routine IAM Policy`googlebigquery_get_routine_iam_policy`

Gets the IAM policy for the specified routine

`https://​www.googleapis.com/auth/bigquery`

Set Routine IAM Policy`googlebigquery_set_routine_iam_policy`

Sets the IAM policy for the specified routine

`https://​www.googleapis.com/auth/bigquery`

Test Table IAM Permissions`googlebigquery_test_table_iam_permissions`

Tests if the caller has the specified permissions on a table

`https://​www.googleapis.com/auth/bigquery`

List Row Access Policies`googlebigquery_list_row_access_policies`

Lists all row access policies on the specified table

`https://​www.googleapis.com/auth/bigquery`

Create Row Access Policy`googlebigquery_create_row_access_policy`

Creates a new row access policy on the specified table

`https://​www.googleapis.com/auth/bigquery`

Query (Synchronous)`googlebigquery_query`

Runs a BigQuery SQL query synchronously and returns query results

`https://​www.googleapis.com/auth/bigquery`

Insert Job (Asynchronous)`googlebigquery_insert_job`

Starts a new asynchronous job (query, load, extract, copy)

`https://​www.googleapis.com/auth/bigquery`

List Jobs`googlebigquery_list_jobs`

Lists all jobs in the specified project

`https://​www.googleapis.com/auth/bigquery`

Get Job`googlebigquery_get_job`

Returns information about a specific job

`https://​www.googleapis.com/auth/bigquery`

Get Query Results`googlebigquery_get_query_results`

Retrieves the results of a query job

`https://​www.googleapis.com/auth/bigquery`

Cancel Job`googlebigquery_cancel_job`

Requests that a job be cancelled

`https://​www.googleapis.com/auth/bigquery`

Delete Job`googlebigquery_delete_job`

Requests the deletion of the metadata of a job

`https://​www.googleapis.com/auth/bigquery`

List Models`googlebigquery_list_models`

Lists all models in the specified dataset

`https://​www.googleapis.com/auth/bigquery`

Get Model`googlebigquery_get_model`

Gets the specified model resource

`https://​www.googleapis.com/auth/bigquery`

Patch Model`googlebigquery_patch_model`

Updates information in an existing model

`https://​www.googleapis.com/auth/bigquery`

Delete Model`googlebigquery_delete_model`

Deletes the model specified by modelId

`https://​www.googleapis.com/auth/bigquery`

List Projects`googlebigquery_list_projects`

Lists all projects to which the user has been granted any project role

`https://​www.googleapis.com/auth/bigquery`

Get Service Account`googlebigquery_get_service_account`

Returns the email address of the service account for the project

`https://​www.googleapis.com/auth/bigquery`

List Routines`googlebigquery_list_routines`

Lists all routines in the specified dataset

`https://​www.googleapis.com/auth/bigquery`

Get Routine`googlebigquery_get_routine`

Gets the specified routine resource

`https://​www.googleapis.com/auth/bigquery`

Create Routine`googlebigquery_create_routine`

Creates a new routine in the dataset

`https://​www.googleapis.com/auth/bigquery`

Update Routine`googlebigquery_update_routine`

Updates information in an existing routine

`https://​www.googleapis.com/auth/bigquery`

Delete Routine`googlebigquery_delete_routine`

Deletes the routine specified by routineId

`https://​www.googleapis.com/auth/bigquery`

List Table Data`googlebigquery_list_table_data`

Lists the content of a table in rows

`https://​www.googleapis.com/auth/bigquery`

Insert Table Data`googlebigquery_insert_table_data`

Streams data into BigQuery using the streaming insert API; supports inserting one or more rows per request

`https://​www.googleapis.com/auth/bigquery`

List Tables`googlebigquery_list_tables`

Lists all tables in the specified dataset

`https://​www.googleapis.com/auth/bigquery`

Get Table`googlebigquery_get_table`

Gets the specified table resource

`https://​www.googleapis.com/auth/bigquery`

Create Table`googlebigquery_create_table`

Creates a new, empty table in the dataset

`https://​www.googleapis.com/auth/bigquery`

Patch Table`googlebigquery_patch_table`

Updates information in an existing table

`https://​www.googleapis.com/auth/bigquery`

Replace Table`googlebigquery_replace_table`

Replaces an existing table with a full resource update

`https://​www.googleapis.com/auth/bigquery`

Delete Table`googlebigquery_delete_table`

Deletes the table specified by tableId

`https://​www.googleapis.com/auth/bigquery`


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.