Google BigQuery
Query, list, and insert data in Google BigQuery
Connect to Google BigQuery to run SQL queries, list datasets and tables, get table metadata, and insert rows.
| Parameter | Type | Required | Description |
|---|
projectId | string | Yes | No description |
query | string | Yes | No description |
useLegacySql | boolean | No | No description |
maxResults | number | No | No description |
defaultDatasetId | string | No | No description |
location | string | No | Processing location (e.g., "US", "EU") |
| Parameter | Type | Description |
|---|
columns | array | Array of column names from the query result |
rows | array | Array of row objects keyed by column name |
totalRows | string | Total number of rows in the complete result set |
jobComplete | boolean | Whether the query completed within the timeout |
totalBytesProcessed | string | Total bytes processed by the query |
cacheHit | boolean | Whether the query result was served from cache |
jobReference | object | Job reference (useful when jobComplete is false) |
↳ projectId | string | Project ID containing the job |
↳ jobId | string | Unique job identifier |
↳ location | string | Geographic location of the job |
pageToken | string | Token for fetching additional result pages |
| Parameter | Type | Required | Description |
|---|
projectId | string | Yes | No description |
maxResults | number | No | No description |
pageToken | string | No | No description |
| Parameter | Type | Description |
|---|
datasets | array | Array of dataset objects |
↳ datasetId | string | Unique dataset identifier |
↳ projectId | string | Project ID containing this dataset |
↳ friendlyName | string | Descriptive name for the dataset |
↳ location | string | Geographic location where the data resides |
nextPageToken | string | Token for fetching next page of results |
| Parameter | Type | Required | Description |
|---|
projectId | string | Yes | No description |
datasetId | string | Yes | No description |
maxResults | number | No | No description |
pageToken | string | No | No description |
| Parameter | Type | Description |
|---|
tables | array | Array of table objects |
↳ tableId | string | Table identifier |
↳ datasetId | string | Dataset ID containing this table |
↳ projectId | string | Project ID containing this table |
↳ type | string | Table type (TABLE, VIEW, EXTERNAL, etc.) |
↳ friendlyName | string | User-friendly name for the table |
↳ creationTime | string | Time when created, in milliseconds since epoch |
totalItems | number | Total number of tables in the dataset |
nextPageToken | string | Token for fetching next page of results |
| Parameter | Type | Required | Description |
|---|
projectId | string | Yes | No description |
datasetId | string | Yes | No description |
tableId | string | Yes | No description |
| Parameter | Type | Description |
|---|
tableId | string | Table ID |
datasetId | string | Dataset ID |
projectId | string | Project ID |
type | string | Table type (TABLE, VIEW, SNAPSHOT, MATERIALIZED_VIEW, EXTERNAL) |
description | string | Table description |
numRows | string | Total number of rows |
numBytes | string | Total size in bytes, excluding data in streaming buffer |
schema | array | Array of column definitions |
↳ name | string | Column name |
↳ type | string | Data type (STRING, INTEGER, FLOAT, BOOLEAN, TIMESTAMP, RECORD, etc.) |
↳ mode | string | Column mode (NULLABLE, REQUIRED, or REPEATED) |
↳ description | string | Column description |
creationTime | string | Table creation time (milliseconds since epoch) |
lastModifiedTime | string | Last modification time (milliseconds since epoch) |
location | string | Geographic location where the table resides |
| Parameter | Type | Required | Description |
|---|
projectId | string | Yes | No description |
datasetId | string | Yes | No description |
tableId | string | Yes | No description |
rows | string | Yes | No description |
skipInvalidRows | boolean | No | No description |
ignoreUnknownValues | boolean | No | No description |
| Parameter | Type | Description |
|---|
insertedRows | number | Number of rows successfully inserted |
errors | array | Array of per-row insertion errors (empty if all succeeded) |
↳ index | number | Zero-based index of the row that failed |
↳ errors | array | Error details for this row |
↳ reason | string | Short error code summarizing the error |
↳ location | string | Where the error occurred |
↳ message | string | Human-readable error description |
