Schema Node Catalog

Schema category

Generated from 4 catalog nodes in Data/Database/Schema.

Nodes in this category

Showing 4 of 4 matching nodes.

Search

A

Add Column

Data/Database/Schema

Adds a column using a typed SQL expression (e.g. 0, '', CAST(NULL AS STRING)). Flow-Like requires an explicit type for NULL. Use CAST(NULL AS <type>). Supported types: int, bigint, float, double, string, binary, boolean, date, timestamp.

4 in2 outSecurity unrated

D

Drop Column

Data/Database/Schema

Drops a column from the database table.

3 in2 outSecurity unrated

M

Make Column Optional

Data/Database/Schema

Marks a column as optional (nullable).

4 in2 outSecurity unrated

S

Set Table Key

Data/Database/Schema

Marks a column as the table key so concurrent Upserts on it never create duplicate rows. The column must be required, hold unique values and be a string, 32/64-bit integer or binary column. The key cannot be changed or removed afterwards; setting the current key again succeeds.

3 in2 outSecurity unrated