Skip to content

Write Delta Table Node

Data/DataFusion/Lakes

Write query results to a new or existing Delta Lake table using FlowPath. Supports append, overwrite modes.

df_write_deltadata
Inputs7
Outputs4
Security exposure7/10
Packagedata

Ratings

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

SecurityAttack surface and exposure impact.
7/10High
PrivacyPotential sensitivity of processed data.
7/10High
PerformanceRuntime or resource pressure.
8/10High
GovernancePolicy, audit, or compliance impact.
9/10High
ReliabilityOperational stability considerations.
9/10High
CostExternal or compute cost impact.
8/10High

Input Pins

7

Input

Execution
exec_in

Trigger execution

Session

Struct
session

DataFusion session

DataFusionSessionDataFusionSession1 fields
cache_keystringrequired

Query

String
query

SQL query to execute. Use $placeholders for values that come from the flow (SELECT * FROM events WHERE day = $day) — each one adds an input pin to wire the value into. Placeholders stand for values only; table and column names cannot be parameterized.

Params

Struct
params

Values for the query's $placeholders, as an object keyed by placeholder name without the $ (e.g. {"customer_id": 42}). Only needed when the query itself comes from a wire — a literal query derives one pin per placeholder instead. Where both supply the same name, the derived pin wins unless it is empty.

objectobject0 fields
No named fields in this schema.
Default {}

Path

Struct
path

FlowPath for the Delta table directory

FlowPathFlowPath3 fields
pathstringrequired
store_refstringrequired
cache_store_refstring | null

Mode

String
mode

Write mode: append, overwrite, error, ignore

Default append

Partition By

String
partition_by

Columns to partition by (comma-separated)

Output Pins

4

Done

Execution
exec_out

Write completed

Session

Struct
session_out

DataFusion session

DataFusionSessionDataFusionSession1 fields
cache_keystringrequired

Rows Written

Integer
rows_written

Number of rows written

New Version

Integer
new_version

Version number after write

Node Info

Internal name
df_write_delta
Category
Data/DataFusion/Lakes