BLOCKS Reference

Block Reference

BigQuery

Create view

This BLOCK creates a BigQuery view.

Property Explanation
BLOCK name Configure the name displayed on this BLOCK.
GCP service account Select the GCP service account to use with this BLOCK.
Result storage data set

Designate the ID of the dataset that will contain the new table.

[% format character addressable] [variable expansion addressable]

Result storage table

Designate an ID for the new table.

[% format character addressable] [variable expansion addressable]

SQL Syntax

Select which of the below SQL dialects will be used in the "Query" property.

Query

Designate a query for the new view.

You can set a query prefix (#legacySQL or #standardSQL) to execute the query using the SQL syntax of the query prefix, regardless of how the SQL syntax property is set.

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]

Overwrite Specify whether or not to erase pre-existing views and tables with identical names when saving newly added ones.
Storage term duration Designate how many seconds to wait before automatically deleting a view. If "0" is designated, automatic deletion will not occur.