# Google BigQuery - Run custom SQL action

The Run custom SQL action allows you to send an SQL string to Google BigQuery to be executed. You can use this action when your SQL transaction spans multiple queries or when you need to run DML statements.

OUTPUT DOES NOT CONTAIN ROWS

This action does not return any row data. For custom SQL that does return rows, use our Get batch of rows by Job ID action to retrieve the resultant rows.

# Input

Input field Description
Project Select the project to bill for the query.
Dataset Select the dataset to pull tables from.
Location Select the geographical location of where the job should run. This field isn't required in most cases.
Query Enter the SQL Statement to execute.
Use legacy SQL Toggle to true to use legacy SQL. Normally not configured.

# Output

Output field Description
ID The ID of the job completed.
Kind The type of the Google BigQuery job.
Job Reference Contains information about the job, such as the project ID, job ID and location.
State State of job. Most often, this value will be "DONE".
Statistics Contains information about the query time and total bytes processed by the job.
Configuration Contains information about the query configuration.
Status Contains error results and messages if any.
User email Email of the user who ran the job.


Last updated: 3/14/2025, 5:29:31 PM