BigQuery
Execute query
Overview
This BLOCK executes a BigQuery SQL query and stores the results into a BigQuery table and/or variable.
Properties
| Property | Explanation |
|---|---|
| BLOCK name | Configure the name displayed on this BLOCK. |
| GCP service account |
Select the GCP service account to use with this BLOCK. |
| SQL syntax |
Select whether your query will use Legacy SQL or Standard SQL syntax. |
| Query |
Designate a query to execute. You can set a query prefix open_in_new ( To send % format characters, like Supports % format characters and variable expansion. |
| Dataset for storing results |
Designate the ID of the dataset containing the table that will store the query results. If you leave this and Table for storing results blank, the results will be sent to the Variable for storing results, which is set to Supports % format characters and variable expansion. |
| Table for storing results |
Designate the ID of the table that will store the query results. If you leave this Dataset for storing results blank, the results will be sent to the Variable for storing results, which is set to Supports % format characters and variable expansion. |
| In cases of non-empty tables |
Select which action to perform when the Table for storing results already contains data.
|
| Query priority level |
Select the query priority level from the following:
|
| Variable for storing results |
Designate a variable that will store the results of the query. The variable can store query results with up to 1,000 records. If you leave this, the Dataset for storing result, and the Table for storing results blank, the results will be sent to the variable |
| BLOCK memos | Make notes about this BLOCK. |
| Reattempts in case of errors | Configure the number of attempts to try in case of a request error. |
| Minimum timeout interval | Set the number of seconds to wait for results. If results are not returned during this interval, the time will be doubled for each reattempt until the time set in the Maximum timeout interval property is reached. |
| Maximum timeout interval | Indicate the maximum number of seconds to wait for results. The timeout interval will start with the value set in the Minimum timeout interval property and double with each reattempt until reaching the value set here. |
| Allow results with 1,000+ records | Select whether or not to allow query results with over 1,000 records. This cannot be enabled if the Dataset for storing results and Table for storing results properties are blank. |
| Allow flattened results | Select whether or not to flatten nested fields. If you do not allow flattened results, you will not be able to enable the Allow results with 1,000+ records property. |
| Use query cache | Select whether or not to use the query cache. |
| User-defined functions |
If using user-defined functions (UDF), enter them as strings into this property. You can enter multiple UDFs. Strings starting with info_outline This property can only be used when |
| Maximum bytes billed | Set a limit for query pricing. Queries that will have bytes billed beyond this limit will fail without incurring charges. |
| Tables required for execution | Designate a table or tables that the BLOCK will check for before executing. Enter tables as strings (ProjectID:DatasetID:TableID), or objects ({"dataset":"DatasetID","table":"TableID"}). You can enter multiple tables as an array. |
| Times to check for table(s) | Set the maximum number of times to check for the table(s) specified in the Tables required for execution property. |
| Time between checks | Set the number of seconds to wait between checking for the table(s) specified in the Tables required for execution property. |
| Output query logs |
Configure whether or not to output query logs. Query logs are output with expanded variables. Query logs are not output by default. Check this property to output query logs. |