Google BigQuery

Google BigQuery integration (Data, Developer Tools). Imported from open-connector.

OAuth19 toolshttps://bigquery.googleapis.com/bigquery/v2

POST

google_bigquery_query

Run a BigQuery SQL query synchronously.

/projects/{projectId}/queries

9 parameters

Param	Type	Required	Description
projectId	string	required	The Google Cloud project ID that owns the BigQuery resource.
query	string	required	The GoogleSQL query text to execute.
location	string	optional	The BigQuery job location, such as US or europe-west1.
maxResults	integer	optional	The maximum number of results to return.
dryRun	boolean	optional	Whether BigQuery should validate the query without running it.
useLegacySql	boolean	optional	Whether to use legacy SQL instead of GoogleSQL.
timeoutMs	integer	optional	How long BigQuery should wait for the query to complete, in milliseconds.
parameterMode	string	optional	The BigQuery parameter mode.
queryParameters	array	optional	The query parameters for parameterized SQL.

POST

google_bigquery_cancel_job

Cancel a BigQuery job.

/projects/{projectId}/jobs/{jobId}/cancel

3 parameters

Param	Type	Required	Description
projectId	string	required	The Google Cloud project ID that owns the BigQuery resource.
jobId	string	required	The BigQuery job ID.
location	string	optional	The BigQuery job location, such as US or europe-west1.

POST

google_bigquery_start_query_job

Start an asynchronous BigQuery query job.

/projects/{projectId}/jobs

15 parameters

Param	Type	Required	Description
projectId	string	required	The Google Cloud project ID that owns the BigQuery resource.
query	string	required	The GoogleSQL query text to execute.
location	string	optional	The BigQuery job location, such as US or europe-west1.
jobId	string	optional	The optional client-provided BigQuery job ID.
dryRun	boolean	optional	Whether BigQuery should validate the query without running it.
useLegacySql	boolean	optional	Whether to use legacy SQL instead of GoogleSQL.
destinationTable	object	optional	The raw BigQuery object returned by the API.
defaultDataset	object	optional	The raw BigQuery object returned by the API.
writeDisposition	string	optional	—
createDisposition	string	optional	—
priority	string	optional	—
maximumBytesBilled	string	optional	—
parameterMode	string	optional	—
queryParameters	array	optional	—
labels	object	optional	A BigQuery labels map.

POST

google_bigquery_start_load_job_from_gcs

Start a BigQuery load job from Cloud Storage.

/projects/{projectId}/jobs

22 parameters

Param	Type	Required	Description
projectId	string	required	The Google Cloud project ID that owns the BigQuery resource.
sourceUris	array	required	—
destinationTable	object	required	A BigQuery table reference.
location	string	optional	The BigQuery job location, such as US or europe-west1.
jobId	string	optional	The BigQuery job ID.
sourceFormat	string	optional	—
schema	object	optional	The raw BigQuery object returned by the API.
writeDisposition	string	optional	—
createDisposition	string	optional	—
skipLeadingRows	integer	optional	—
fieldDelimiter	string	optional	—
allowQuotedNewlines	boolean	optional	—
allowJaggedRows	boolean	optional	—
ignoreUnknownValues	boolean	optional	—
maxBadRecords	integer	optional	—
autodetect	boolean	optional	—
nullMarker	string	optional	—
encoding	string	optional	—
timePartitioning	object	optional	The raw BigQuery object returned by the API.
rangePartitioning	object	optional	The raw BigQuery object returned by the API.
clustering	object	optional	The raw BigQuery object returned by the API.
labels	object	optional	A BigQuery labels map.

POST

google_bigquery_start_extract_job_to_gcs

Start a BigQuery extract job to Cloud Storage.

/projects/{projectId}/jobs

11 parameters

Param	Type	Required	Description
projectId	string	required	The Google Cloud project ID that owns the BigQuery resource.
sourceTable	object	required	A BigQuery table reference.
destinationUris	array	required	—
location	string	optional	The BigQuery job location, such as US or europe-west1.
jobId	string	optional	The BigQuery job ID.
destinationFormat	string	optional	—
compression	string	optional	—
fieldDelimiter	string	optional	—
printHeader	boolean	optional	—
useAvroLogicalTypes	boolean	optional	—
labels	object	optional	A BigQuery labels map.

POST

google_bigquery_create_dataset

Create a BigQuery dataset.

/projects/{projectId}/datasets

9 parameters

Param	Type	Required	Description
projectId	string	required	The Google Cloud project ID that owns the BigQuery resource.
datasetId	string	required	The BigQuery dataset ID.
location	string	optional	The BigQuery job location, such as US or europe-west1.
friendlyName	string	optional	—
description	string	optional	—
labels	object	optional	A BigQuery labels map.
defaultTableExpirationMs	string	optional	—
defaultPartitionExpirationMs	string	optional	—
updateMode	string	optional	—

PATCH

google_bigquery_patch_dataset

Patch BigQuery dataset metadata.

/projects/{projectId}/datasets/{datasetId}

9 parameters

Param	Type	Required	Description
projectId	string	required	The Google Cloud project ID that owns the BigQuery resource.
datasetId	string	required	The BigQuery dataset ID.
location	string	optional	The BigQuery job location, such as US or europe-west1.
friendlyName	string	optional	—
description	string	optional	—
labels	object	optional	A BigQuery labels map.
defaultTableExpirationMs	string	optional	—
defaultPartitionExpirationMs	string	optional	—
updateMode	string	optional	—

PUT

google_bigquery_update_dataset

Replace BigQuery dataset metadata.

/projects/{projectId}/datasets/{datasetId}

9 parameters

Param	Type	Required	Description
projectId	string	required	The Google Cloud project ID that owns the BigQuery resource.
datasetId	string	required	The BigQuery dataset ID.
location	string	optional	The BigQuery job location, such as US or europe-west1.
friendlyName	string	optional	—
description	string	optional	—
labels	object	optional	A BigQuery labels map.
defaultTableExpirationMs	string	optional	—
defaultPartitionExpirationMs	string	optional	—
updateMode	string	optional	—

DELETE

google_bigquery_delete_dataset

Delete a BigQuery dataset.

/projects/{projectId}/datasets/{datasetId}

3 parameters

Param	Type	Required	Description
projectId	string	required	The Google Cloud project ID that owns the BigQuery resource.
datasetId	string	required	The BigQuery dataset ID.
deleteContents	boolean	optional	Whether to delete all tables in the dataset.

POST

google_bigquery_create_table

Create a BigQuery table.

/projects/{projectId}/datasets/{datasetId}/tables

14 parameters

Param	Type	Required	Description
projectId	string	required	The Google Cloud project ID that owns the BigQuery resource.
datasetId	string	required	The BigQuery dataset ID.
tableId	string	required	The BigQuery table ID.
schema	object	optional	The raw BigQuery object returned by the API.
friendlyName	string	optional	—
description	string	optional	—
labels	object	optional	A BigQuery labels map.
timePartitioning	object	optional	The raw BigQuery object returned by the API.
rangePartitioning	object	optional	The raw BigQuery object returned by the API.
clustering	object	optional	The raw BigQuery object returned by the API.
view	object	optional	The raw BigQuery object returned by the API.
materializedView	object	optional	The raw BigQuery object returned by the API.
externalDataConfiguration	object	optional	The raw BigQuery object returned by the API.
encryptionConfiguration	object	optional	The raw BigQuery object returned by the API.

PATCH

google_bigquery_patch_table

Patch BigQuery table metadata.

/projects/{projectId}/datasets/{datasetId}/tables/{tableId}

14 parameters

Param	Type	Required	Description
projectId	string	required	The Google Cloud project ID that owns the BigQuery resource.
datasetId	string	required	The BigQuery dataset ID.
tableId	string	required	The BigQuery table ID.
schema	object	optional	The raw BigQuery object returned by the API.
friendlyName	string	optional	—
description	string	optional	—
labels	object	optional	A BigQuery labels map.
timePartitioning	object	optional	The raw BigQuery object returned by the API.
rangePartitioning	object	optional	The raw BigQuery object returned by the API.
clustering	object	optional	The raw BigQuery object returned by the API.
view	object	optional	The raw BigQuery object returned by the API.
materializedView	object	optional	The raw BigQuery object returned by the API.
externalDataConfiguration	object	optional	The raw BigQuery object returned by the API.
encryptionConfiguration	object	optional	The raw BigQuery object returned by the API.

PUT

google_bigquery_update_table

Replace BigQuery table metadata.

/projects/{projectId}/datasets/{datasetId}/tables/{tableId}

14 parameters

Param	Type	Required	Description
projectId	string	required	The Google Cloud project ID that owns the BigQuery resource.
datasetId	string	required	The BigQuery dataset ID.
tableId	string	required	The BigQuery table ID.
schema	object	optional	The raw BigQuery object returned by the API.
friendlyName	string	optional	—
description	string	optional	—
labels	object	optional	A BigQuery labels map.
timePartitioning	object	optional	The raw BigQuery object returned by the API.
rangePartitioning	object	optional	The raw BigQuery object returned by the API.
clustering	object	optional	The raw BigQuery object returned by the API.
view	object	optional	The raw BigQuery object returned by the API.
materializedView	object	optional	The raw BigQuery object returned by the API.
externalDataConfiguration	object	optional	The raw BigQuery object returned by the API.
encryptionConfiguration	object	optional	The raw BigQuery object returned by the API.

DELETE

google_bigquery_delete_table

Delete a BigQuery table.

/projects/{projectId}/datasets/{datasetId}/tables/{tableId}

3 parameters

Param	Type	Required	Description
projectId	string	required	The Google Cloud project ID that owns the BigQuery resource.
datasetId	string	required	The BigQuery dataset ID.
tableId	string	required	The BigQuery table ID.

POST

google_bigquery_insert_all

Insert a small batch of rows into a BigQuery table.

/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/insertAll

7 parameters

Param	Type	Required	Description
projectId	string	required	The Google Cloud project ID that owns the BigQuery resource.
datasetId	string	required	The BigQuery dataset ID.
tableId	string	required	The BigQuery table ID.
rows	array	required	—
skipInvalidRows	boolean	optional	—
ignoreUnknownValues	boolean	optional	—
templateSuffix	string	optional	—

POST

google_bigquery_create_routine

Create a BigQuery routine.

/projects/{projectId}/datasets/{datasetId}/routines

11 parameters

Param	Type	Required	Description
projectId	string	required	The Google Cloud project ID that owns the BigQuery resource.
datasetId	string	required	The BigQuery dataset ID.
routineId	string	required	—
routineType	string	required	—
language	string	optional	—
definitionBody	string	required	—
description	string	optional	—
arguments	array	optional	—
returnType	object	optional	The raw BigQuery object returned by the API.
importedLibraries	array	optional	—
determinismLevel	string	optional	—

PUT

google_bigquery_update_routine

Replace BigQuery routine metadata.

/projects/{projectId}/datasets/{datasetId}/routines/{routineId}

11 parameters

Param	Type	Required	Description
projectId	string	required	The Google Cloud project ID that owns the BigQuery resource.
datasetId	string	required	The BigQuery dataset ID.
routineId	string	required	—
routineType	string	required	—
language	string	optional	—
definitionBody	string	required	—
description	string	optional	—
arguments	array	optional	—
returnType	object	optional	The raw BigQuery object returned by the API.
importedLibraries	array	optional	—
determinismLevel	string	optional	—

DELETE

google_bigquery_delete_routine

Delete a BigQuery routine.

/projects/{projectId}/datasets/{datasetId}/routines/{routineId}

3 parameters

Param	Type	Required	Description
projectId	string	required	The Google Cloud project ID that owns the BigQuery resource.
datasetId	string	required	The BigQuery dataset ID.
routineId	string	required	—

PATCH

google_bigquery_patch_model

Patch BigQuery model metadata.

/projects/{projectId}/datasets/{datasetId}/models/{modelId}

6 parameters

Param	Type	Required	Description
projectId	string	required	The Google Cloud project ID that owns the BigQuery resource.
datasetId	string	required	The BigQuery dataset ID.
modelId	string	required	—
friendlyName	string	optional	—
description	string	optional	—
labels	object	optional	A BigQuery labels map.

DELETE

google_bigquery_delete_model

Delete a BigQuery model.

/projects/{projectId}/datasets/{datasetId}/models/{modelId}

3 parameters

Param	Type	Required	Description
projectId	string	required	The Google Cloud project ID that owns the BigQuery resource.
datasetId	string	required	The BigQuery dataset ID.
modelId	string	required	—