Make Column Optional Node

M

Data/Database/Schema

Marks a column as optional (nullable).

make_column_optional_local_dbdata

Inputs4

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

4

Input

Execution

exec_in

Database

Struct

database

Database Connection Reference

SchemaNodeDBConnectionNodeDBConnectionNodeDBConnection1 fields

cache_keystringrequired

Schema enforced

Column Name

String

column_name

Name of the column

Default new_column

Optional

Boolean

optional

True = nullable, false = required

Default true

Output Pins

2

Done

Execution

exec_out

Done altering schema

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

make_column_optional_local_db

Category

Data/Database/Schema