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 | Trigger |
|---|---|---|---|
| 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 | Trigger |
|---|---|---|---|
| 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 | Trigger |
|---|---|---|---|
| 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 | Trigger |
|---|---|---|---|
| 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 | Trigger |
|---|---|---|---|
| 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 |