BLOCKS Reference

Block Reference

BigQuery

Execute DML query

warning This BLOCK is currently in beta and will become unavailable post official release.
*Please make use of the official BLOCK once released.

As a beta release, there is the possibility that some functions may not execute properly. We appreciate feedback from users, through the BLOCKS Forum or direct contact, regarding bugs or ways to improve BLOCKS.

This BLOCK executes a BigQuery Data Manipulation Language query.

Property Explanation
BLOCK name Configure the name displayed on this BLOCK.
GCP service account

Select the GCP service account to use with this BLOCK.

Query

Designate a DML query to execute.

To send % format characters (ex. %Y or %m) directly to BigQuery, use %%. For example, enter %%Y and BigQuery will change the %% into %, thus receiving the intended %Y.

[% format character addressable] [variable expansion addressable]

Query priority level

Select the query priority level.

  • Interactive (executes immediately, limited simultaneous queries)
  • Batch (executes when resources are available, unlimited simultaneous queries)
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.