BLOCKS Reference

BigQuery

Create view

Overview

This BLOCK creates a BigQuery view.

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.
Result storage dataset

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

Supports % format characters and variable expansion.

Result storage table

Designate an ID for the new table.

Supports % format characters and variable expansion.

SQL syntax

Select which of the following SQL formats 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, like %Y or %m, directly to BigQuery, use %%. For example, if you enter %%Y, BigQuery will change the %% into a %, thus receive your intended %Y.

Supports % format characters and variable expansion.

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 table. You can enter 0 to disable automatic deletion.