Requirements
Connecting Google BigQuery takes an active account plus OAuth client credentials, granted by signing in with your account — no other setup is required.[3]
Get your Google BigQuery credentials
You’ll be redirected to sign in and approve access — your password is never shared with WEXTL.
- Client IDtextRequired
OAuth 2.0 Client ID from Google Cloud Console → APIs & Services → Credentials → Web application. Enable the BigQuery API. Add this app's redirect URI.
[1] - Client SecretpasswordRequired
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.
[1] - Additional Scopesarray
Optional. Extra Google OAuth scopes to request on top of the default ones, one full scope URL per item (for example https://www.googleapis.com/auth/drive). Duplicates of the default scopes are ignored. Use this with your own Client ID, and enable the same scopes on its OAuth consent screen.
[1]
Integration requests 1 permission:
View and manage your data in Google BigQuery
Connect Google BigQuery in WEXTL
- Log in to your WEXTL account, add the Google BigQuery node module to your workflow, and click Create new credential.
- Optional: In the Credential name field, enter a name for the credential.
- Enter the authentication credentials you copied from your Google BigQuery account, or follow the on-screen instructions to create the credential.
- If prompted, authenticate your account and confirm access.
- If you want to make changes to your credential in the future, follow the steps in Manage credentials →
Notes
Credentials are org-scoped; share them with teammates from the Credentials picker on any of its nodes.For detailed information on connecting an application, see Connect an application →
Google BigQuery node modules
The list below is a reference of every Google BigQuery node module the integration supports. You will be able to pick any of them on the workflow canvas while building automations.
Expand any Google BigQuery node module below to see exactly what it takes in, what it returns, and what connection it needs.
Watch JobsTrigger
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
| Limit | number |
Output fields[3]
| 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 |
Get DatasetSearch
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
Output fields[3]
| 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
Get JobSearch
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Job IDRequired | choice |
| Location | text |
Output fields[3]
| 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 |
Get ModelSearch
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
Model IDRequired | choice |
Output fields[3]
| 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
Get Query ResultsSearch
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Job IDRequired | choice |
| Location | text |
Output fields[3]
| 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 |
Get RoutineSearch
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
Routine IDRequired | choice |
Output fields[3]
| 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
Get Routine IAM PolicySearch
Get Row Access PolicySearch
Get Row Access Policy IAM PolicySearch
Get Service AccountSearch
Get TableSearch
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
Table IDRequired | choice |
Output fields[3]
| 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
Get Table IAM PolicySearch
List DatasetsSearch
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
| All | boolean |
| Filter | text |
| Limit | number |
Output fields[3]
| 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
List JobsSearch
Input fields[3]
| 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[3]
| 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 |
List ModelsSearch
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
| Limit | number |
Output fields[3]
| 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
List ProjectsSearch
List RoutinesSearch
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
| Filter | text |
| Read Mask | text |
| Limit | number |
Output fields[3]
| 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
List Row Access PoliciesSearch
List Table DataSearch
List TablesSearch
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
| Limit | number |
Output fields[3]
| 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
Cancel JobAction
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Job IDRequired | choice |
| Location | text |
Output fields[3]
| 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 |
Create DatasetAction
Input fields[3]
| 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[3]
| 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
Create JobAction
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
ConfigurationRequired | text |
| Job Reference | text |
Output fields[3]
| 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 |
Create RoutineAction
Input fields[3]
| 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[3]
| 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
Create Row Access PolicyAction
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
Table IDRequired | choice |
Policy IDRequired | text |
Filter PredicateRequired | text |
| Grantees | array |
| Grantee | text |
Output fields[3]
| Field | Type |
|---|---|
| Creationtime | text |
| Etag | text |
| Filterpredicate | text |
| Grantees | array |
| Lastmodifiedtime | text |
| Rowaccesspolicyreference | object |
| Datasetid | text |
| Policyid | text |
| Projectid | text |
| Tableid | text |
Create TableAction
Input fields[3]
| 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[3]
| 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
Delete DatasetAction
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
| Delete Contents | boolean |
Delete JobAction
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Job IDRequired | choice |
LocationRequired | text |
Delete ModelAction
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
Model IDRequired | choice |
Delete RoutineAction
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
Routine IDRequired | choice |
Delete Row Access Policies in BatchAction
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
Table IDRequired | choice |
Policy IDsRequired | choice |
| Force | boolean |
Delete Row Access PolicyAction
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
Table IDRequired | choice |
Policy IDRequired | choice |
Delete TableAction
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
Table IDRequired | choice |
Edit DatasetAction
Input fields[3]
| 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[3]
| 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
Edit ModelAction
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
Model IDRequired | choice |
| Description | text |
| Friendly Name | text |
| Labels | text |
Output fields[3]
| 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
Edit TableAction
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
Table IDRequired | choice |
| Friendly Name | text |
| Description | text |
| Schema | text |
| View | text |
| Labels | text |
Output fields[3]
| 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
Execute QueryAction
Input fields[3]
| 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[3]
| 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
Insert RowsAction
Make an API Calluniversal
Input fields[3]
| Field | Type |
|---|---|
URLRequired | text |
MethodRequired | choice |
| Headers | array |
| Header | object |
| Query String | array |
| Parameter | object |
| Body | text |
Set Routine IAM PolicyAction
Set Table IAM PolicyAction
Test Routine IAM PermissionsAction
Test Row Access Policy IAM PermissionsAction
Test Table IAM PermissionsAction
Undelete DatasetAction
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
| Deletion Time | text |
Output fields[3]
| 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
Update DatasetAction
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
| Friendly Name | text |
| Description | text |
| Location | text |
| Labels | text |
Output fields[3]
| 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
Update RoutineAction
Input fields[3]
| 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[3]
| 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
Update Row Access PolicyAction
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
Table IDRequired | choice |
Policy IDRequired | choice |
Filter PredicateRequired | text |
| Grantees | array |
| Grantee | text |
Output fields[3]
| Field | Type |
|---|---|
| Creationtime | text |
| Etag | text |
| Filterpredicate | text |
| Grantees | array |
| Lastmodifiedtime | text |
| Rowaccesspolicyreference | object |
| Datasetid | text |
| Policyid | text |
| Projectid | text |
| Tableid | text |
Update TableAction
Input fields[3]
| Field | Type |
|---|---|
Project IDRequired | choice |
Dataset IDRequired | choice |
Table IDRequired | choice |
| Friendly Name | text |
| Description | text |
| Schema | text |
| View | text |
| Labels | text |
Output fields[3]
| 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
Templates
Look for Google BigQuery templates in the WEXTL template library.
Browse templates →Explore alternative apps
- Google Firestore[2]Cloud Firestore NoSQL database for realtime app data.
- FirebaseRealtime Database JSON paths and Firebase Auth user admin — read, write, query, and manage users.
- FileMakerRead and write records in FileMaker databases hosted on FileMaker Server or FileMaker Cloud, run scripts, and inspect layout metadata.
- AirtableSpreadsheet-database hybrid for structured collaborative data.
- BaserowOpen-source database — manage workspaces, tables, fields, rows, and views through the Baserow REST API.
References
- WEXTL® Google BigQuery Source Code connector implementation.
- Our users use cases and automations.
- Official API Documentation for Google BigQuery.
- WEXTL® visual workflow builder data.
Last updated: Sep 1, 2026 09:27