Integrations
Google BigQuery
6 actions for Google BigQuery.
Execute BigQuery Query#
Executes a SQL query in Google BigQuery.
Plans: Trial, Pro, Premium, Enterprise · Type: BigqueryExecuteQuery
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| SQL Query | Text | Yes | (empty) | The SQL query to execute in BigQuery. |
| Project ID | Text | No | (empty) | Google Cloud project ID. If not provided, uses the default project. |
| Dry Run | Yes/No | No | Off | If enabled, validates the query without executing it. Returns cost estimation. |
Outputs#
| Output | Type |
|---|---|
| Rows | List |
| Total Rows | Number |
| Table Schema | List |
| Job Id | Text |
| Dry Run | Yes/No |
| Total Bytes Processed | Any |
| Total Bytes Billed | Any |
| Cache Hit | Any |
Use as an agent tool#
Tool name: bigquery_execute_query
Execute a SQL query in BigQuery and return results
Get BigQuery Dataset Info#
Gets metadata for a specific BigQuery dataset.
Plans: Trial, Pro, Premium, Enterprise · Type: BigqueryGetDatasetInfo
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Dataset ID | Text | Yes | (empty) | The BigQuery dataset ID to get information for. |
| Project ID | Text | No | (empty) | Google Cloud project ID. If not provided, uses the default project. |
Outputs#
| Output | Type |
|---|---|
| Dataset Id | Text |
| Project | Text |
| Location | Text |
| Created | Any |
| Modified | Any |
| Description | Any |
| Labels | Object |
Use as an agent tool#
Tool name: bigquery_get_dataset_info
Get detailed information about a BigQuery dataset
List BigQuery Projects#
Lists all Google Cloud projects accessible with the integration.
Plans: Trial, Pro, Premium, Enterprise · Type: BigqueryGetProjects
Outputs#
| Output | Type |
|---|---|
| Projects | List |
| Total Count | Number |
Use as an agent tool#
Tool name: bigquery_get_projects
List all accessible Google Cloud projects for BigQuery
Get BigQuery Table Info#
Gets metadata and schema for a specific BigQuery table.
Plans: Trial, Pro, Premium, Enterprise · Type: BigqueryGetTableInfo
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Dataset ID | Text | Yes | (empty) | The BigQuery dataset ID containing the table. |
| Table ID | Text | Yes | (empty) | The BigQuery table ID to get information for. |
| Project ID | Text | No | (empty) | Google Cloud project ID. If not provided, uses the default project. |
Outputs#
| Output | Type |
|---|---|
| Table Id | Text |
| Dataset Id | Text |
| Project | Text |
| Table Type | Text |
| Created | Any |
| Modified | Any |
| Num Rows | Number |
| Num Bytes | Number |
| Description | Any |
| Table Schema | List |
| Labels | Object |
Use as an agent tool#
Tool name: bigquery_get_table_info
Get detailed information and schema for a BigQuery table
List BigQuery Datasets#
Lists all datasets in a Google Cloud project.
Plans: Trial, Pro, Premium, Enterprise · Type: BigqueryListDatasets
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Project ID | Text | No | (empty) | Google Cloud project ID. If not provided, uses the default project. |
| Max Results | Number | No | 100 | Maximum number of datasets to return. |
Outputs#
| Output | Type |
|---|---|
| Datasets | List |
| Total Count | Number |
Use as an agent tool#
Tool name: bigquery_list_datasets
List all datasets in a BigQuery project
List BigQuery Tables#
Lists all tables in a BigQuery dataset.
Plans: Trial, Pro, Premium, Enterprise · Type: BigqueryListTables
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Dataset ID | Text | Yes | (empty) | The BigQuery dataset ID to list tables from. |
| Project ID | Text | No | (empty) | Google Cloud project ID. If not provided, uses the default project. |
| Max Results | Number | No | 100 | Maximum number of tables to return. |
Outputs#
| Output | Type |
|---|---|
| Tables | List |
| Total Count | Number |
Use as an agent tool#
Tool name: bigquery_list_tables
List all tables in a BigQuery dataset