What actions can I run in Google BigQuery?

48 actions are available, including "Get Dataset", "Get Job", and "Get Model", and more. Run them from any trigger in your automation stack — map fields once and they execute automatically.

Do I need to write code to automate this?

No. Most automations are built visually on the canvas by picking triggers, actions, and mapping fields. You can add custom JavaScript with Functions when advanced logic is needed — but it is never required.

Is the integration secure?

Yes. Connections are authenticated per account, credentials are encrypted at rest, and you can enforce approvals and team-level access controls on any automation.

Google BigQuery Integrations

Query and manage Google BigQuery datasets, tables, jobs, and routines — run SQL and stream rows. Use Google BigQuery as a workflow source of truth — query, insert, and sync without scripts.

Explore Documentation

GDPR
Data Encryption
2FA
Local Data Region

Watch JobsTriggers when a new BigQuery job is created.
Get DatasetReturns a single dataset.
Get JobReturns a single job.
Get ModelReturns a single model.
Get Query ResultsReturns results for a query job.
Get RoutineReturns a single routine.
Get Routine IAM PolicyReturns the IAM policy for a routine.
Get Row Access PolicyReturns a single row access policy.
Get Row Access Policy IAM PolicyReturns the IAM policy for a row access policy.
Get Service AccountReturns the project's BigQuery service account.
Get TableReturns a single table.
Get Table IAM PolicyReturns the IAM policy for a table.
List DatasetsRetrieves datasets in a project.
List JobsRetrieves jobs in a project.
List ModelsRetrieves models in a dataset.
List ProjectsRetrieves projects the user can access.
List RoutinesRetrieves routines in a dataset.
List Row Access PoliciesRetrieves row access policies on a table.
List Table DataRetrieves rows from a table.
List TablesRetrieves tables in a dataset.
Cancel JobCancels a running job.
Create DatasetCreates a new dataset.
Create JobCreates a query, load, copy, or extract job.
Create RoutineCreates a new routine.
Create Row Access PolicyCreates a row access policy.
Create TableCreates a new table.
Delete DatasetDeletes a dataset.
Delete JobDeletes the metadata of a completed job.
Delete ModelDeletes a model.
Delete RoutineDeletes a routine.
Delete Row Access Policies in BatchDeletes several row access policies.
Delete Row Access PolicyDeletes a row access policy.
Delete TableDeletes a table.
Edit DatasetUpdates selected fields on a dataset.
Edit ModelUpdates selected fields on a model.
Edit TableUpdates selected fields on a table.
Execute QueryRuns a SQL query.
Insert RowsInserts rows into a table.
Make an API CallPerforms an arbitrary authorized API call.
Set Routine IAM PolicySets the IAM policy for a routine.
Set Table IAM PolicySets the IAM policy for a table.
Test Routine IAM PermissionsTests IAM permissions on a routine.
Test Row Access Policy IAM PermissionsTests IAM permissions on a row access policy.
Test Table IAM PermissionsTests IAM permissions on a table.
Undelete DatasetRestores a recently deleted dataset.
Update DatasetReplaces an existing dataset.
Update RoutineReplaces an existing routine.
Update Row Access PolicyReplaces a row access policy.
Update TableReplaces an existing table.

When to use Google BigQuery

Common scenarios where Google BigQuery automation saves time and reduces manual work.

React to "Watch Jobs" in Google BigQuery in real time: route the event into CRM, chat, ticketing, or any connected service.
Use "Get Job" as an automated action in Google BigQuery so records stay consistent whenever something changes elsewhere in your stack.
Layer "Get Job" from Google BigQuery with filters, transforms, and AI steps to build automations that match your exact business logic.

Frequently asked questions

Common questions about automating Google BigQuery in your workflows.

Google BigQuery has 1 trigger, including "Watch Jobs". Use them to start workflows the moment Google BigQuery events fire — no polling required.

Google BigQuery Integrations

When to use Google BigQuery

Frequently asked questions

Google BigQuery Integrations

When to use Google BigQuery

Connect Google BigQuery to any app in workflows

Frequently asked questions

Connect Google BigQuery to any app in workflows

Connect Google BigQuery to any app in workflows

Connect Google BigQuery to any app in workflows

Google BigQuery Integrations

Google BigQuery triggers and actions

When to use Google BigQuery

Frequently asked questions

What triggers does Google BigQuery support?

What actions can I run in Google BigQuery?

Do I need to write code to automate this?

Is the integration secure?

Google BigQuery Integrations

Google BigQuery triggers and actions

When to use Google BigQuery

Connect Google BigQuery to any app in workflows

Frequently asked questions

What triggers does Google BigQuery support?

What actions can I run in Google BigQuery?

Do I need to write code to automate this?

Is the integration secure?

Connect Google BigQuery to any app in workflows

Connect Google BigQuery to any app in workflows

Connect Google BigQuery to any app in workflows