Set Table Key Node

S

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.

set_primary_key_local_dbdata

Inputs3

Outputs2

Security exposureUnrated

Packagedata

Ratings

Scores range from 0 to 10. Higher values mean more impact, exposure, or operational weight.

No score metadata has been set for this node yet.

Input Pins

3

Input

Execution

exec_in

Database

Struct

database

Database Connection Reference

SchemaNodeDBConnectionNodeDBConnectionNodeDBConnection1 fields

cache_keystringrequired

Schema enforced

Column Name

String

column_name

Column that uniquely identifies each row, usually the ID Column your Upserts use

Default id

Output Pins

2

Done

Execution

exec_out

The column is the table key

Schema

Struct

schema

Updated database schema

SchemaTableSchemaTableSchemaTableSchema2 fields

fieldsArray<TableField>required

The columns, in storage order.

itemsTableFieldarray item

One column of a table.

namestringrequired

Column name.

data_typevaluerequired

Arrow data type: a bare name such as `"Utf8"` or `"Int64"` for simple types, an object for nested ones such as lists and structs.

nullablebooleanrequired

Whether the column accepts nulls.

dict_idinteger | null

Dictionary id, set only on dictionary-encoded columns.

format int64

dict_is_orderedboolean | null

Whether the dictionary is ordered, set only on dictionary-encoded columns.

+1 more fields

metadatavalue

Table level key/value metadata, defined by whoever wrote the table.

default null

Node Info

Internal name

set_primary_key_local_db

Category

Data/Database/Schema