BLOCKS Reference

Block Reference

BigQuery

Create table

This BLOCK creates a BigQuery table. It can also create partitioned tables

Property name Explanation
BLOCK name Designate a name to be displayed on this BLOCK.
GCP service account Select the GCP service account to use with this BLOCK.
Destination dataset

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

[% format character addressable] [expanded variable addressable]

Table ID

Designate the ID of the table to be created.

[% format character addressable] [expanded variable addressable]

Schema settings

Designate the schema of the new table.

Click "Edit as JSON" to input schema directly in JSON format.

Overwrite Specify whether or not to erase pre-existing views and tables with identical names when saving newly added ones.
BLOCK memos Make any comments regarding this BLOCK.
Storage term duration Designate how many seconds to wait before automatically deleting a table. If "0" is designated, automatic deletion will not occur.
Partitioned table Specify whether to create a partitioned table or not.