DEFAULTS

Default parameter values injected into the pipeline SQL. Parameters use $name syntax.

Category: pipeline-clauses

Syntax

DEFAULTS ($batch_date = '2024-01-01', $limit = 1000)

Description

The DEFAULTS clause declares named parameters with default values that are injected into the pipeline SQL at execution time. Parameters use `$name` syntax and are enclosed in parentheses as comma-separated `$name = value` pairs. Supported value types include single-quoted strings, integers, floats, and booleans. When a pipeline is executed, these defaults are applied unless overridden by runtime parameters passed at invocation. When omitted, the pipeline has no parameterized defaults and all values must be hardcoded in the SQL body or supplied at execution time.

Open in interactive docs →   DeltaForge home →