Add Column Node

A

Data/Database/Schema

Add Column

Adds a column using a typed SQL expression (e.g. 0, '', CAST(NULL AS STRING)). LanceDB rejects bare NULL — wrap it in CAST(... AS <type>). Supported types: int, bigint, float, double, string, binary, boolean, date, timestamp.

add_column_local_dbdata

Inputs4

Outputs2

Security exposure10/10

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). Bare NULL is rejected; LanceDB supports 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

Node Info

Internal name

add_column_local_db

Category

Data/Database/Schema

Version

2