BLOCKS Reference

BigQuery

Create table

Overview

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

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.
Destination dataset

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

Supports % format characters and variable expansion.

Table ID

Designate the ID of the table to be created.

Supports % format characters and variable expansion.

Schema settings

Designate the schema of the new table.

Click Edit as JSON to input schema directly as JSON text.

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. You can enter 0 to disable automatic deletion.
Partitioned table Specify whether or not to create partitioned tables.