BigQuery
Create table
Overview
This BLOCK creates a BigQuery table. It can also create partitioned tables open_in_new
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. |