Google BigQuery

The Google BigQuery node adds Google BigQuery operations to your workflows. Add it on the canvas or ask the AI builder for it by name, then pick an operation and fill in its fields. Google BigQuery also includes 1 trigger operation (marked in the tables below) that can start a workflow when something happens in Google BigQuery.

You can wire the Google BigQuery node into an AI agent as a tool provider: the agent calls the operations you allow. See Agent tools.

Credentials

Connect Google BigQuery under Credentials in the node settings. See Connecting credentials for the general flow.

Big query OAuth

Sign in with your Google BigQuery account when prompted; no keys to copy. Get your credentials here. NoClick requests the following permissions:

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

Big query service account

Enter the values manually when creating the credential. Create a JSON key for a service account with the required BigQuery IAM roles (e.g. BigQuery Job User + BigQuery Data Editor). Prefer user OAuth for user-delegated access; use service accounts for server-to-server automation. Get your credentials here.

Operations

Datasets

Operation	ID	Description
Create Dataset	`create_dataset`	Create a new dataset.
Delete Dataset	`delete_dataset`	Delete a dataset.
Get Dataset	`get_dataset`	Fetch dataset metadata.
List Datasets	`list_datasets`	List datasets in the project.
Patch Dataset	`patch_dataset`	Partial update of dataset metadata (PATCH).
Undelete Dataset	`undelete_dataset`	Restore a dataset within its time-travel window (datasets.undelete).
Update Dataset	`update_dataset`	Full replace of dataset metadata (PUT).

Jobs

Operation	ID	Description
Cancel Job	`cancel_job`	Request cancellation of a running job.
Delete Job	`delete_job`	Delete a job’s metadata.
Get Job	`get_job`	Fetch a job’s status and statistics (poll until DONE).
Insert Job	`insert_job`	Start a query / load / extract / copy job (async).
List Jobs	`list_jobs`	List jobs in a project (filter by state, time range).

Models

Operation	ID	Description
Delete Model	`delete_model`	Delete a BQML model.
Get Model	`get_model`	Fetch BQML model metadata.
List Models	`list_models`	List BigQuery ML models in a dataset.
Patch Model	`patch_model`	Update mutable BQML model metadata (models.patch).

Project

Operation	ID	Description	Trigger
Get Service Account	`get_service_account`	Return the BigQuery service account for the project (KMS/transfer grants).
List Projects	`list_projects`	List projects the caller can access (for project picker UIs).

Queries

Operation	ID	Description	Trigger
Get Query Results	`get_query_results`	Page through the results of a (possibly async) query job.
Run Query	`run_query`	Run a SQL query and return results inline (synchronous, bounded by timeout).

Routines

Operation	ID	Description
Create Routine	`create_routine`	Create a stored procedure / UDF / TVF.
Delete Routine	`delete_routine`	Delete a routine (routines.delete).
Get Routine	`get_routine`	Fetch a routine definition.
List Routines	`list_routines`	List stored procedures / UDFs / TVFs in a dataset.
Update Routine	`update_routine`	Replace a routine’s full definition (routines.update, PUT).

Row access policies

Operation	ID	Description	Trigger
Get Row Access Policy	`get_row_access_policy`	Get a single row access policy (rowAccessPolicies.get).
List Row Access Policies	`list_row_access_policies`	List row access policies on a table (rowAccessPolicies.list).

Tables

Operation	ID	Description
Create Table	`create_table`	Create a table or view with a schema.
Delete Table	`delete_table`	Delete a table or view.
Get Table	`get_table`	Fetch table metadata/schema.
Get Table IAM Policy	`get_table_iam_policy`	Get the IAM policy for a table (tables.getIamPolicy).
List Table Data	`list_table_data`	Read rows from a table directly (paginated, no SQL).
List Tables	`list_tables`	List tables/views in a dataset.
Patch Table	`patch_table`	Partial update of a table (add columns, set expiration, etc.).
Set Table IAM Policy	`set_table_iam_policy`	Set the IAM policy for a table (tables.setIamPolicy).
Stream Insert Rows	`stream_insert`	Streaming insert of JSON rows into a table (real-time append).
Test Table IAM Permissions	`test_table_iam_permissions`	Test the caller’s permissions on a table (tables.testIamPermissions).
Update Table	`update_table`	Full replace of table metadata (PUT).

Triggers

Operation	ID	Description	Trigger
On Scheduled Query Results	`on_query_results`	Poll-based trigger: run a SQL query on a schedule and emit NEW rows.	Yes

​Credentials

​Big query OAuth

​Big query service account

​Operations

​Datasets

​Jobs

​Models

​Project

​Queries

​Routines

​Row access policies

​Tables

​Triggers

Credentials

Big query OAuth

Big query service account

Operations

Datasets

Jobs

Models

Project

Queries

Routines

Row access policies

Tables

Triggers