Skip to main content
Google BigQuery
Google BigQuery
41 actions · 1 auth method
PreviewDatabase

​
Authentication

OAuth 2.0

The steps in this guide require Admin or Owner privileges within Google Cloud.Guides: Connector Profile, Link Account
Actions
|
41 actions
Action
Description
Required scopes
List Datasets
Lists all datasets in the specified project
Get Dataset
Returns the dataset specified by datasetID
Create Dataset
Creates a new empty dataset
Patch Dataset
Updates information in an existing dataset
Replace Dataset
Replaces an existing dataset with a full resource update
Delete Dataset
Deletes the dataset specified by datasetId
Undelete Dataset
Undeletes a dataset which is within time travel window
Get Table IAM Policy
Gets the IAM policy for the specified table
Set Table IAM Policy
Sets the IAM policy for the specified table
Test Routine IAM Permissions
Tests if the caller has the specified permissions on a routine
Get Routine IAM Policy
Gets the IAM policy for the specified routine
Set Routine IAM Policy
Sets the IAM policy for the specified routine
Test Table IAM Permissions
Tests if the caller has the specified permissions on a table
List Row Access Policies
Lists all row access policies on the specified table
Create Row Access Policy
Creates a new row access policy on the specified table
Query (Synchronous)
Runs a BigQuery SQL query synchronously and returns query results
Insert Job (Asynchronous)
Starts a new asynchronous job (query, load, extract, copy)
List Jobs
Lists all jobs in the specified project
Get Job
Returns information about a specific job
Get Query Results
Retrieves the results of a query job
Cancel Job
Requests that a job be cancelled
Delete Job
Requests the deletion of the metadata of a job
List Models
Lists all models in the specified dataset
Get Model
Gets the specified model resource
Patch Model
Updates information in an existing model
Delete Model
Deletes the model specified by modelId
List Projects
Lists all projects to which the user has been granted any project role
Get Service Account
Returns the email address of the service account for the project
List Routines
Lists all routines in the specified dataset
Get Routine
Gets the specified routine resource
Create Routine
Creates a new routine in the dataset
Update Routine
Updates information in an existing routine
Delete Routine
Deletes the routine specified by routineId
List Table Data
Lists the content of a table in rows
Insert Table Data
Streams data into BigQuery using the streaming insert API; supports inserting one or more rows per request
List Tables
Lists all tables in the specified dataset
Get Table
Gets the specified table resource
Create Table
Creates a new, empty table in the dataset
Patch Table
Updates information in an existing table
Replace Table
Replaces an existing table with a full resource update
Delete Table
Deletes the table specified by tableId

​
Getting Started

1

Create or Select a Project

Set up a new project or select an existing one. See the Projects Guide.
2

Configure the Connector

Enable the connector and set up a connector profile in your project. See Managing Connectors.
https://stackone-logos.com/api/google-bigquery/filled/png

Connector Profile

Google BigQuery - OAuth 2.0
3

Link an Account

Connect an account using StackOne Hub or Auth Link.
https://stackone-logos.com/api/google-bigquery/filled/png

Link Account

Google BigQuery - OAuth 2.0
4

Use Actions

Invoke actions using one of the methods below: