Add Column Node

A

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.

add_column_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 to add

Default new_column

SQL Expression

String

sql_expression

Typed SQL expression used to populate existing rows. Examples: 0, '', CAST(NULL AS STRING). Flow-Like requires an explicit type for NULL. Supported types: int, bigint, float, double, string, binary, boolean, date, timestamp.

Default CAST(NULL AS STRING)

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

add_column_local_db

Category

Data/Database/Schema

Version

2