Create view

最終更新日：2022年07月01日

BigQuery

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 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. Legacy SQL Standard SQL
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.