Google BigQuery Database API: Watch Jobs, Cancel Job

Query and manage Google BigQuery datasets, tables, jobs, and routines — run SQL and stream rows. 1 trigger, 19 searches, and 29 actions including Watch Jobs.

About this integration

Query and manage Google BigQuery datasets, tables, jobs, and routines — run SQL and stream rows. Connect it to any workflow without writing code.

You can choose from 1 trigger, 19 search modules and 29 actions. The connection type is oauth authentication.

How to connect

The credential form asks for Client ID and Client Secret.

OAuth asks you to approve View and manage your data in Google BigQuery before access is granted.

You’ll be redirected to sign in and approve access — your password is never shared with WEXTL.

Field	Type	Help
Client IDRequired	text	OAuth 2.0 Client ID from Google Cloud Console → APIs & Services → Credentials → Web application. Enable the BigQuery API. Add this app's redirect URI.
Client SecretRequired	password	Client secret for the same OAuth client. Verify may return 401 if the access token has aged out — reconnect or wait for the refresh condition to run; Verify deliberately does not refresh first.

Permissions requested

View and manage your data in Google BigQuery

Use it in workflow automation

Start with Watch Jobs, then add Cancel Job.

Triggers, searches and actions

Explore the fields available for each Google BigQuery trigger, search, and action — 1 trigger, 19 searchs, and 29 actions.

Triggers

Whenever something changes in the app, one of 1 available trigger can start a run immediately.

Watch Jobs

Searches

19 search modules let you query the app mid-run and feed the results to the next step.

Get Dataset
Get Job
Get Model
Get Query Results
Get Routine

14more searches

Actions

Use 29 action modules to write data back into the app from anywhere in a run.

Cancel Job
Create Dataset
Create Job
Create Routine
Create Row Access Policy

24more actions

Explore the fields available for each Google BigQuery trigger, search, and action.

Triggers

Input fields

Field	Type
Project IDRequired	choice
Limit	number

Output fields

Field	Type
Configuration	object
Copy	object
Dryrun	boolean
Extract	object
Jobtimeoutms	text
Jobtype	text
Labels	text
Load	object
Maxslots	number
Query	object
Reservation	text
Etag	text
Id	text
Jobcreationreason	object
Code	text
Jobreference	object
Jobid	text
Location	text
Projectid	text
Kind	text
Principal Subject	text
Selflink	text
Statistics	object
Completionratio	number
Copy	object
Creationtime	text
Datamaskingstatistics	object
Edition	text
Endtime	text
Extract	object
Finalexecutiondurationms	text
Globalqueryremoteregions	array
Load	object
Status	object
Errorresult	object
Errors	array
State	text
User Email	text

Searches

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice

Output fields

Field	Type
Access	array
Catalogsource	text
Creationtime	text
Datasetreference	object
Datasetid	text
Projectid	text
Defaultcollation	text
Defaultencryptionconfiguration	object
Kmskeyname	text
Defaultpartitionexpirationms	text
Defaultroundingmode	text
Defaulttableexpirationms	text
Description	text
Etag	text
Externalcatalogdatasetoptions	object
Defaultstoragelocationuri	text
Parameters	text
Externaldatasetreference	object
Connection	text
Externalsource	text
Friendlyname	text
Id	text
Iscaseinsensitive	boolean
Kind	text
Labels	text
Lastmodifiedtime	text
Linkeddatasetmetadata	object
Linkstate	text

11other output fields

Input fields

Field	Type
Project IDRequired	choice
Job IDRequired	choice
Location	text

Output fields

Field	Type
Configuration	object
Copy	object
Dryrun	boolean
Extract	object
Jobtimeoutms	text
Jobtype	text
Labels	text
Load	object
Maxslots	number
Query	object
Reservation	text
Etag	text
Id	text
Jobcreationreason	object
Code	text
Jobreference	object
Jobid	text
Location	text
Projectid	text
Kind	text
Principal Subject	text
Selflink	text
Statistics	object
Completionratio	number
Copy	object
Creationtime	text
Datamaskingstatistics	object
Edition	text
Endtime	text
Extract	object
Finalexecutiondurationms	text
Globalqueryremoteregions	array
Load	object
Status	object
Errorresult	object
Errors	array
State	text
User Email	text

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Model IDRequired	choice

Output fields

Field	Type
Besttrialid	text
Creationtime	text
Defaulttrialid	text
Description	text
Encryptionconfiguration	object
Kmskeyname	text
Etag	text
Expirationtime	text
Featurecolumns	array
Item	object
Friendlyname	text
Hparamsearchspaces	object
Activationfn	object
Batchsize	object
Boostertype	object
Colsamplebylevel	object
Colsamplebynode	object
Colsamplebytree	object
Dartnormalizetype	object
Dropout	object
Hiddenunits	object
L1Reg	object
Hparamtrials	array
Item	object
Labelcolumns	array
Item	object
Labels	text
Lastmodifiedtime	text
Location	text
Modelreference	object
Datasetid	text
Modelid	text
Projectid	text
Modeltype	text
Optimaltrialids	array
Remotemodelinfo	object
Connection	text
Endpoint	text
Maxbatchingrows	text
Remotemodelversion	text
Remoteservicetype	text
Speechrecognizer	text
Trainingruns	array
Item	object

1other output field

Input fields

Field	Type
Project IDRequired	choice
Job IDRequired	choice
Location	text

Output fields

Field	Type
Cachehit	boolean
Errors	array
Item	object
Etag	text
Jobcomplete	boolean
Jobreference	object
Jobid	text
Location	text
Projectid	text
Kind	text
Numdmlaffectedrows	text
Pagetoken	text
Rows	array
Item	object
Schema	object
Fields	array
Foreigntypeinfo	object
Totalbytesprocessed	text
Totalrows	text

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Routine IDRequired	choice

Output fields

Field	Type
Arguments	array
Item	object
Buildstatus	object
Buildduration	text
Buildstate	text
Buildstateupdatetime	text
Errorresult	object
Imagesizebytes	text
Creationtime	text
Datagovernancetype	text
Definitionbody	text
Description	text
Determinismlevel	text
Etag	text
Externalruntimeoptions	object
Containercpu	number
Containermemory	text
Containerrequestconcurrency	text
Maxbatchingrows	text
Runtimeconnection	text
Runtimeversion	text
Importedlibraries	array
Language	text
Lastmodifiedtime	text
Pythonoptions	object
Entrypoint	text
Packages	array
Remotefunctionoptions	object
Connection	text
Endpoint	text
Maxbatchingrows	text
Userdefinedcontext	text
Returntabletype	object
Columns	array
Returntype	object
Arrayelementtype	object
Rangeelementtype	object
Structtype	object
Typekind	text
Routinereference	object
Datasetid	text
Projectid	text
Routineid	text
Routinetype	text
Securitymode	text
Sparkoptions	object
Archiveuris	array
Connection	text
Containerimage	text
Fileuris	array
Jaruris	array
Mainclass	text
Mainfileuri	text
Properties	text
Pyfileuris	array
Runtimeversion	text

1other output field

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Routine IDRequired	choice
Options	text

Output fields

Field	Type
Auditconfigs	array
Item	object
Bindings	array
Item	object
Etag	text
Version	number

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Table IDRequired	choice
Policy IDRequired	choice

Output fields

Field	Type
Creationtime	text
Etag	text
Filterpredicate	text
Grantees	array
Lastmodifiedtime	text
Rowaccesspolicyreference	object
Datasetid	text
Policyid	text
Projectid	text
Tableid	text

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Table IDRequired	choice
Policy IDRequired	choice
Options	text

Output fields

Field	Type
Auditconfigs	array
Item	object
Bindings	array
Item	object
Etag	text
Version	number

Input fields

Field	Type
Project IDRequired	choice

Output fields

Field	Type
Email	text
Kind	text

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Table IDRequired	choice

Output fields

Field	Type
Biglakeconfiguration	object
Connectionid	text
Fileformat	text
Storageuri	text
Tableformat	text
Clonedefinition	object
Basetablereference	object
Clonetime	text
Clustering	object
Fields	array
Creationtime	text
Defaultcollation	text
Defaultroundingmode	text
Description	text
Encryptionconfiguration	object
Kmskeyname	text
Etag	text
Expirationtime	text
Externalcatalogtableoptions	object
Connectionid	text
Parameters	text
Storagedescriptor	object
Externaldataconfiguration	object
Autodetect	boolean
Avrooptions	object
Bigtableoptions	object
Compression	text
Connectionid	text
Csvoptions	object
Dateformat	text
Datetimeformat	text
Decimaltargettypes	array
Filesetspectype	text
Friendlyname	text
Id	text
Kind	text
Labels	text
Lastmodifiedtime	text
Location	text
Managedtabletype	text
Materializedview	object
Allownonincrementaldefinition	boolean
Enablerefresh	boolean
Lastrefreshtime	text
Maxstaleness	text
Query	text
Refreshintervalms	text

32other output fields

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Table IDRequired	choice
Options	text

Output fields

Field	Type
Auditconfigs	array
Item	object
Bindings	array
Item	object
Etag	text
Version	number

Input fields

Field	Type
Project IDRequired	choice
All	boolean
Filter	text
Limit	number

Output fields

Field	Type
Access	array
Catalogsource	text
Creationtime	text
Datasetreference	object
Datasetid	text
Projectid	text
Defaultcollation	text
Defaultencryptionconfiguration	object
Kmskeyname	text
Defaultpartitionexpirationms	text
Defaultroundingmode	text
Defaulttableexpirationms	text
Description	text
Etag	text
Externalcatalogdatasetoptions	object
Defaultstoragelocationuri	text
Parameters	text
Externaldatasetreference	object
Connection	text
Externalsource	text
Friendlyname	text
Id	text
Iscaseinsensitive	boolean
Kind	text
Labels	text
Lastmodifiedtime	text
Linkeddatasetmetadata	object
Linkstate	text

11other output fields

Input fields

Field	Type
Project IDRequired	choice
All Users	boolean
State Filter	choice
Min Creation Time	date
Max Creation Time	date
Parent Job ID	choice
Projection	choice
Limit	number

Output fields

Field	Type
Configuration	object
Copy	object
Dryrun	boolean
Extract	object
Jobtimeoutms	text
Jobtype	text
Labels	text
Load	object
Maxslots	number
Query	object
Reservation	text
Etag	text
Id	text
Jobcreationreason	object
Code	text
Jobreference	object
Jobid	text
Location	text
Projectid	text
Kind	text
Principal Subject	text
Selflink	text
Statistics	object
Completionratio	number
Copy	object
Creationtime	text
Datamaskingstatistics	object
Edition	text
Endtime	text
Extract	object
Finalexecutiondurationms	text
Globalqueryremoteregions	array
Load	object
Status	object
Errorresult	object
Errors	array
State	text
User Email	text

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Limit	number

Output fields

Field	Type
Besttrialid	text
Creationtime	text
Defaulttrialid	text
Description	text
Encryptionconfiguration	object
Kmskeyname	text
Etag	text
Expirationtime	text
Featurecolumns	array
Item	object
Friendlyname	text
Hparamsearchspaces	object
Activationfn	object
Batchsize	object
Boostertype	object
Colsamplebylevel	object
Colsamplebynode	object
Colsamplebytree	object
Dartnormalizetype	object
Dropout	object
Hiddenunits	object
L1Reg	object
Hparamtrials	array
Item	object
Labelcolumns	array
Item	object
Labels	text
Lastmodifiedtime	text
Location	text
Modelreference	object
Datasetid	text
Modelid	text
Projectid	text
Modeltype	text
Optimaltrialids	array
Remotemodelinfo	object
Connection	text
Endpoint	text
Maxbatchingrows	text
Remotemodelversion	text
Remoteservicetype	text
Speechrecognizer	text
Trainingruns	array
Item	object

1other output field

Input fields

Field	Type
Limit	number

Output fields

Field	Type
ID	text
Friendly Name	text
Numeric ID	text
Project Reference	object
Project ID	text
Kind	text

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Filter	text
Read Mask	text
Limit	number

Output fields

Field	Type
Arguments	array
Item	object
Buildstatus	object
Buildduration	text
Buildstate	text
Buildstateupdatetime	text
Errorresult	object
Imagesizebytes	text
Creationtime	text
Datagovernancetype	text
Definitionbody	text
Description	text
Determinismlevel	text
Etag	text
Externalruntimeoptions	object
Containercpu	number
Containermemory	text
Containerrequestconcurrency	text
Maxbatchingrows	text
Runtimeconnection	text
Runtimeversion	text
Importedlibraries	array
Language	text
Lastmodifiedtime	text
Pythonoptions	object
Entrypoint	text
Packages	array
Remotefunctionoptions	object
Connection	text
Endpoint	text
Maxbatchingrows	text
Userdefinedcontext	text
Returntabletype	object
Columns	array
Returntype	object
Arrayelementtype	object
Rangeelementtype	object
Structtype	object
Typekind	text
Routinereference	object
Datasetid	text
Projectid	text
Routineid	text
Routinetype	text
Securitymode	text
Sparkoptions	object
Archiveuris	array
Connection	text
Containerimage	text
Fileuris	array
Jaruris	array
Mainclass	text
Mainfileuri	text
Properties	text
Pyfileuris	array
Runtimeversion	text

1other output field

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Table IDRequired	choice
Limit	number

Output fields

Field	Type
Creationtime	text
Etag	text
Filterpredicate	text
Grantees	array
Lastmodifiedtime	text
Rowaccesspolicyreference	object
Datasetid	text
Policyid	text
Projectid	text
Tableid	text

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Table IDRequired	choice
Selected Fields	text
Limit	number

Output fields

Field	Type
F	array
Item	object

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Limit	number

Output fields

Field	Type
Biglakeconfiguration	object
Connectionid	text
Fileformat	text
Storageuri	text
Tableformat	text
Clonedefinition	object
Basetablereference	object
Clonetime	text
Clustering	object
Fields	array
Creationtime	text
Defaultcollation	text
Defaultroundingmode	text
Description	text
Encryptionconfiguration	object
Kmskeyname	text
Etag	text
Expirationtime	text
Externalcatalogtableoptions	object
Connectionid	text
Parameters	text
Storagedescriptor	object
Externaldataconfiguration	object
Autodetect	boolean
Avrooptions	object
Bigtableoptions	object
Compression	text
Connectionid	text
Csvoptions	object
Dateformat	text
Datetimeformat	text
Decimaltargettypes	array
Filesetspectype	text
Friendlyname	text
Id	text
Kind	text
Labels	text
Lastmodifiedtime	text
Location	text
Managedtabletype	text
Materializedview	object
Allownonincrementaldefinition	boolean
Enablerefresh	boolean
Lastrefreshtime	text
Maxstaleness	text
Query	text
Refreshintervalms	text

32other output fields

Actions

Input fields

Field	Type
Project IDRequired	choice
Job IDRequired	choice
Location	text

Output fields

Field	Type
Configuration	object
Copy	object
Dryrun	boolean
Extract	object
Jobtimeoutms	text
Jobtype	text
Labels	text
Load	object
Maxslots	number
Query	object
Reservation	text
Etag	text
Id	text
Jobcreationreason	object
Code	text
Jobreference	object
Jobid	text
Location	text
Projectid	text
Kind	text
Principal Subject	text
Selflink	text
Statistics	object
Completionratio	number
Copy	object
Creationtime	text
Datamaskingstatistics	object
Edition	text
Endtime	text
Extract	object
Finalexecutiondurationms	text
Globalqueryremoteregions	array
Load	object
Status	object
Errorresult	object
Errors	array
State	text
User Email	text

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	text
Friendly Name	text
Description	text
Location	text
Labels	text
Default Table Expiration Ms	text
Default Partition Expiration Ms	text
Access	array
Access Entry	text

Output fields

Field	Type
Access	array
Catalogsource	text
Creationtime	text
Datasetreference	object
Datasetid	text
Projectid	text
Defaultcollation	text
Defaultencryptionconfiguration	object
Kmskeyname	text
Defaultpartitionexpirationms	text
Defaultroundingmode	text
Defaulttableexpirationms	text
Description	text
Etag	text
Externalcatalogdatasetoptions	object
Defaultstoragelocationuri	text
Parameters	text
Externaldatasetreference	object
Connection	text
Externalsource	text
Friendlyname	text
Id	text
Iscaseinsensitive	boolean
Kind	text
Labels	text
Lastmodifiedtime	text
Linkeddatasetmetadata	object
Linkstate	text

11other output fields

Input fields

Field	Type
Project IDRequired	choice
ConfigurationRequired	text
Job Reference	text

Output fields

Field	Type
Configuration	object
Copy	object
Dryrun	boolean
Extract	object
Jobtimeoutms	text
Jobtype	text
Labels	text
Load	object
Maxslots	number
Query	object
Reservation	text
Etag	text
Id	text
Jobcreationreason	object
Code	text
Jobreference	object
Jobid	text
Location	text
Projectid	text
Kind	text
Principal Subject	text
Selflink	text
Statistics	object
Completionratio	number
Copy	object
Creationtime	text
Datamaskingstatistics	object
Edition	text
Endtime	text
Extract	object
Finalexecutiondurationms	text
Globalqueryremoteregions	array
Load	object
Status	object
Errorresult	object
Errors	array
State	text
User Email	text

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Routine IDRequired	text
Routine TypeRequired	text
Definition Body	text
Language	text
Description	text
Arguments	array
Argument	text
Return Type	text

Output fields

Field	Type
Arguments	array
Item	object
Buildstatus	object
Buildduration	text
Buildstate	text
Buildstateupdatetime	text
Errorresult	object
Imagesizebytes	text
Creationtime	text
Datagovernancetype	text
Definitionbody	text
Description	text
Determinismlevel	text
Etag	text
Externalruntimeoptions	object
Containercpu	number
Containermemory	text
Containerrequestconcurrency	text
Maxbatchingrows	text
Runtimeconnection	text
Runtimeversion	text
Importedlibraries	array
Language	text
Lastmodifiedtime	text
Pythonoptions	object
Entrypoint	text
Packages	array
Remotefunctionoptions	object
Connection	text
Endpoint	text
Maxbatchingrows	text
Userdefinedcontext	text
Returntabletype	object
Columns	array
Returntype	object
Arrayelementtype	object
Rangeelementtype	object
Structtype	object
Typekind	text
Routinereference	object
Datasetid	text
Projectid	text
Routineid	text
Routinetype	text
Securitymode	text
Sparkoptions	object
Archiveuris	array
Connection	text
Containerimage	text
Fileuris	array
Jaruris	array
Mainclass	text
Mainfileuri	text
Properties	text
Pyfileuris	array
Runtimeversion	text

1other output field

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Table IDRequired	choice
Policy IDRequired	text
Filter PredicateRequired	text
Grantees	array
Grantee	text

Output fields

Field	Type
Creationtime	text
Etag	text
Filterpredicate	text
Grantees	array
Lastmodifiedtime	text
Rowaccesspolicyreference	object
Datasetid	text
Policyid	text
Projectid	text
Tableid	text

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Table IDRequired	text
Friendly Name	text
Description	text
Schema	text
View	text
External Data Configuration	text
Labels	text
Time Partitioning	text
Clustering	text

Output fields

Field	Type
Biglakeconfiguration	object
Connectionid	text
Fileformat	text
Storageuri	text
Tableformat	text
Clonedefinition	object
Basetablereference	object
Clonetime	text
Clustering	object
Fields	array
Creationtime	text
Defaultcollation	text
Defaultroundingmode	text
Description	text
Encryptionconfiguration	object
Kmskeyname	text
Etag	text
Expirationtime	text
Externalcatalogtableoptions	object
Connectionid	text
Parameters	text
Storagedescriptor	object
Externaldataconfiguration	object
Autodetect	boolean
Avrooptions	object
Bigtableoptions	object
Compression	text
Connectionid	text
Csvoptions	object
Dateformat	text
Datetimeformat	text
Decimaltargettypes	array
Filesetspectype	text
Friendlyname	text
Id	text
Kind	text
Labels	text
Lastmodifiedtime	text
Location	text
Managedtabletype	text
Materializedview	object
Allownonincrementaldefinition	boolean
Enablerefresh	boolean
Lastrefreshtime	text
Maxstaleness	text
Query	text
Refreshintervalms	text

32other output fields

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Delete Contents	boolean

Input fields

Field	Type
Project IDRequired	choice
Job IDRequired	choice
LocationRequired	text

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Model IDRequired	choice

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Routine IDRequired	choice

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Table IDRequired	choice
Policy IDsRequired	choice
Force	boolean

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Table IDRequired	choice
Policy IDRequired	choice

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Table IDRequired	choice

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Friendly Name	text
Description	text
Labels	text
Default Table Expiration Ms	text
Default Partition Expiration Ms	text
Access	array
Access Entry	text

Output fields

Field	Type
Access	array
Catalogsource	text
Creationtime	text
Datasetreference	object
Datasetid	text
Projectid	text
Defaultcollation	text
Defaultencryptionconfiguration	object
Kmskeyname	text
Defaultpartitionexpirationms	text
Defaultroundingmode	text
Defaulttableexpirationms	text
Description	text
Etag	text
Externalcatalogdatasetoptions	object
Defaultstoragelocationuri	text
Parameters	text
Externaldatasetreference	object
Connection	text
Externalsource	text
Friendlyname	text
Id	text
Iscaseinsensitive	boolean
Kind	text
Labels	text
Lastmodifiedtime	text
Linkeddatasetmetadata	object
Linkstate	text

11other output fields

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Model IDRequired	choice
Description	text
Friendly Name	text
Labels	text

Output fields

Field	Type
Besttrialid	text
Creationtime	text
Defaulttrialid	text
Description	text
Encryptionconfiguration	object
Kmskeyname	text
Etag	text
Expirationtime	text
Featurecolumns	array
Item	object
Friendlyname	text
Hparamsearchspaces	object
Activationfn	object
Batchsize	object
Boostertype	object
Colsamplebylevel	object
Colsamplebynode	object
Colsamplebytree	object
Dartnormalizetype	object
Dropout	object
Hiddenunits	object
L1Reg	object
Hparamtrials	array
Item	object
Labelcolumns	array
Item	object
Labels	text
Lastmodifiedtime	text
Location	text
Modelreference	object
Datasetid	text
Modelid	text
Projectid	text
Modeltype	text
Optimaltrialids	array
Remotemodelinfo	object
Connection	text
Endpoint	text
Maxbatchingrows	text
Remotemodelversion	text
Remoteservicetype	text
Speechrecognizer	text
Trainingruns	array
Item	object

1other output field

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Table IDRequired	choice
Friendly Name	text
Description	text
Schema	text
View	text
Labels	text

Output fields

Field	Type
Biglakeconfiguration	object
Connectionid	text
Fileformat	text
Storageuri	text
Tableformat	text
Clonedefinition	object
Basetablereference	object
Clonetime	text
Clustering	object
Fields	array
Creationtime	text
Defaultcollation	text
Defaultroundingmode	text
Description	text
Encryptionconfiguration	object
Kmskeyname	text
Etag	text
Expirationtime	text
Externalcatalogtableoptions	object
Connectionid	text
Parameters	text
Storagedescriptor	object
Externaldataconfiguration	object
Autodetect	boolean
Avrooptions	object
Bigtableoptions	object
Compression	text
Connectionid	text
Csvoptions	object
Dateformat	text
Datetimeformat	text
Decimaltargettypes	array
Filesetspectype	text
Friendlyname	text
Id	text
Kind	text
Labels	text
Lastmodifiedtime	text
Location	text
Managedtabletype	text
Materializedview	object
Allownonincrementaldefinition	boolean
Enablerefresh	boolean
Lastrefreshtime	text
Maxstaleness	text
Query	text
Refreshintervalms	text

32other output fields

Input fields

Field	Type
Project IDRequired	choice
QueryRequired	text
Use Legacy SQL	boolean
Dry Run	boolean
Default Dataset	text
Parameter Mode	choice
Query Parameters	array
Query Parameter	object
Location	text
Labels	text
Preserve Nulls	boolean

Output fields

Field	Type
Arrowrecordbatch	object
Serializedrecordbatch	text
Arrowschema	object
Serializedschema	text
Cachehit	boolean
Creationtime	text
Dmlstats	object
Deletedrowcount	text
Dmlmode	text
Finegraineddmlunusedreason	text
Insertedrowcount	text
Updatedrowcount	text
Endtime	text
Errors	array
Item	object
Jobcomplete	boolean
Jobcreationreason	object
Code	text
Jobreference	object
Jobid	text
Location	text
Projectid	text
Kind	text
Location	text
Numdmlaffectedrows	text
Pagerowcount	text
Pagetoken	text
Queryid	text
Rows	array
Item	object
Schema	object
Fields	array
Foreigntypeinfo	object
Sessioninfo	object
Sessionid	text
Starttime	text

5other output fields

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Table IDRequired	choice
RowsRequired	array
Row	object
Skip Invalid Rows	boolean
Ignore Unknown Values	boolean
Template Suffix	text
Trace ID	text

Output fields

Field	Type
Inserterrors	array
Kind	text

Input fields

Field	Type
URLRequired	text
MethodRequired	choice
Headers	array
Header	object
Query String	array
Parameter	object
Body	text

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Routine IDRequired	choice
PolicyRequired	text
Update Mask	text

Output fields

Field	Type
Auditconfigs	array
Item	object
Bindings	array
Item	object
Etag	text
Version	number

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Table IDRequired	choice
PolicyRequired	text
Update Mask	text

Output fields

Field	Type
Auditconfigs	array
Item	object
Bindings	array
Item	object
Etag	text
Version	number

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Routine IDRequired	choice
PermissionsRequired	array
Permission	text

Output fields

Field	Type
Permissions	array

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Table IDRequired	choice
Policy IDRequired	choice
PermissionsRequired	array
Permission	text

Output fields

Field	Type
Permissions	array

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Table IDRequired	choice
PermissionsRequired	array
Permission	text

Output fields

Field	Type
Permissions	array

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Deletion Time	text

Output fields

Field	Type
Access	array
Catalogsource	text
Creationtime	text
Datasetreference	object
Datasetid	text
Projectid	text
Defaultcollation	text
Defaultencryptionconfiguration	object
Kmskeyname	text
Defaultpartitionexpirationms	text
Defaultroundingmode	text
Defaulttableexpirationms	text
Description	text
Etag	text
Externalcatalogdatasetoptions	object
Defaultstoragelocationuri	text
Parameters	text
Externaldatasetreference	object
Connection	text
Externalsource	text
Friendlyname	text
Id	text
Iscaseinsensitive	boolean
Kind	text
Labels	text
Lastmodifiedtime	text
Linkeddatasetmetadata	object
Linkstate	text

11other output fields

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Friendly Name	text
Description	text
Location	text
Labels	text

Output fields

Field	Type
Access	array
Catalogsource	text
Creationtime	text
Datasetreference	object
Datasetid	text
Projectid	text
Defaultcollation	text
Defaultencryptionconfiguration	object
Kmskeyname	text
Defaultpartitionexpirationms	text
Defaultroundingmode	text
Defaulttableexpirationms	text
Description	text
Etag	text
Externalcatalogdatasetoptions	object
Defaultstoragelocationuri	text
Parameters	text
Externaldatasetreference	object
Connection	text
Externalsource	text
Friendlyname	text
Id	text
Iscaseinsensitive	boolean
Kind	text
Labels	text
Lastmodifiedtime	text
Linkeddatasetmetadata	object
Linkstate	text

11other output fields

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Routine IDRequired	choice
Routine Type	text
Definition Body	text
Language	text
Description	text
Arguments	array
Argument	text
Return Type	text

Output fields

Field	Type
Arguments	array
Item	object
Buildstatus	object
Buildduration	text
Buildstate	text
Buildstateupdatetime	text
Errorresult	object
Imagesizebytes	text
Creationtime	text
Datagovernancetype	text
Definitionbody	text
Description	text
Determinismlevel	text
Etag	text
Externalruntimeoptions	object
Containercpu	number
Containermemory	text
Containerrequestconcurrency	text
Maxbatchingrows	text
Runtimeconnection	text
Runtimeversion	text
Importedlibraries	array
Language	text
Lastmodifiedtime	text
Pythonoptions	object
Entrypoint	text
Packages	array
Remotefunctionoptions	object
Connection	text
Endpoint	text
Maxbatchingrows	text
Userdefinedcontext	text
Returntabletype	object
Columns	array
Returntype	object
Arrayelementtype	object
Rangeelementtype	object
Structtype	object
Typekind	text
Routinereference	object
Datasetid	text
Projectid	text
Routineid	text
Routinetype	text
Securitymode	text
Sparkoptions	object
Archiveuris	array
Connection	text
Containerimage	text
Fileuris	array
Jaruris	array
Mainclass	text
Mainfileuri	text
Properties	text
Pyfileuris	array
Runtimeversion	text

1other output field

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Table IDRequired	choice
Policy IDRequired	choice
Filter PredicateRequired	text
Grantees	array
Grantee	text

Output fields

Field	Type
Creationtime	text
Etag	text
Filterpredicate	text
Grantees	array
Lastmodifiedtime	text
Rowaccesspolicyreference	object
Datasetid	text
Policyid	text
Projectid	text
Tableid	text

Input fields

Field	Type
Project IDRequired	choice
Dataset IDRequired	choice
Table IDRequired	choice
Friendly Name	text
Description	text
Schema	text
View	text
Labels	text

Output fields

Field	Type
Biglakeconfiguration	object
Connectionid	text
Fileformat	text
Storageuri	text
Tableformat	text
Clonedefinition	object
Basetablereference	object
Clonetime	text
Clustering	object
Fields	array
Creationtime	text
Defaultcollation	text
Defaultroundingmode	text
Description	text
Encryptionconfiguration	object
Kmskeyname	text
Etag	text
Expirationtime	text
Externalcatalogtableoptions	object
Connectionid	text
Parameters	text
Storagedescriptor	object
Externaldataconfiguration	object
Autodetect	boolean
Avrooptions	object
Bigtableoptions	object
Compression	text
Connectionid	text
Csvoptions	object
Dateformat	text
Datetimeformat	text
Decimaltargettypes	array
Filesetspectype	text
Friendlyname	text
Id	text
Kind	text
Labels	text
Lastmodifiedtime	text
Location	text
Managedtabletype	text
Materializedview	object
Allownonincrementaldefinition	boolean
Enablerefresh	boolean
Lastrefreshtime	text
Maxstaleness	text
Query	text
Refreshintervalms	text

32other output fields