BLOCKS Reference

Block Reference

BigQuery

Create view

This BLOCK creates BigQuery views.

Property name Explanation
BLOCK name Designate a name for BLOCKS. The names will be displayed on the BLOCKS.
GCP service account Select the GCP service account for use with this BLOCK.
Result storage data set

Designate an ID for the additional data set.

[% format character string addressable] [variable expansion addressable]

Result storage table

Designate an ID for the additional table.

[% format character string 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 additional view.
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.