Google BigQuery

使用方法

Connect to Google BigQuery to run SQL queries, list datasets and tables, get table metadata, and insert rows.

Run a SQL query against Google BigQuery and return the results

パラメータ	型	必須	説明
`projectId`	string	はい	Google Cloud project ID
`query`	string	はい	SQL query to execute
`useLegacySql`	boolean	いいえ	Whether to use legacy SQL syntax (default: false)
`maxResults`	number	いいえ	Maximum number of rows to return
`defaultDatasetId`	string	いいえ	Default dataset for unqualified table names
`location`	string	いいえ	Processing location (e.g., "US", "EU")

パラメータ	型	説明
`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

List all datasets in a Google BigQuery project

パラメータ	型	必須	説明
`projectId`	string	はい	Google Cloud project ID
`maxResults`	number	いいえ	Maximum number of datasets to return
`pageToken`	string	いいえ	Token for pagination

パラメータ	型	説明
`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

List all tables in a Google BigQuery dataset

パラメータ	型	必須	説明
`projectId`	string	はい	Google Cloud project ID
`datasetId`	string	はい	BigQuery dataset ID
`maxResults`	number	いいえ	Maximum number of tables to return
`pageToken`	string	いいえ	Token for pagination

パラメータ	型	説明
`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

Get metadata and schema for a Google BigQuery table

パラメータ	型	必須	説明
`projectId`	string	はい	Google Cloud project ID
`datasetId`	string	はい	BigQuery dataset ID
`tableId`	string	はい	BigQuery table ID

パラメータ	型	説明
`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

Insert rows into a Google BigQuery table using streaming insert

パラメータ	型	必須	説明
`projectId`	string	はい	Google Cloud project ID
`datasetId`	string	はい	BigQuery dataset ID
`tableId`	string	はい	BigQuery table ID
`rows`	string	はい	JSON array of row objects to insert
`skipInvalidRows`	boolean	いいえ	Whether to insert valid rows even if some are invalid
`ignoreUnknownValues`	boolean	いいえ	Whether to ignore columns not in the table schema

パラメータ	型	説明
`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