SHOW INCREMENTAL CONFIG

Displays the stored incremental loading configuration for a Delta table.

Category: incrementalDeltaForge extension

Syntax

SHOW INCREMENTAL CONFIG ON <table>

Description

## Overview SHOW INCREMENTAL CONFIG reads the Delta table's transaction log and extracts all properties in the `delta.forge.incremental.*` namespace. It presents the configuration as a two-column result set (property, value), providing a quick way to verify what INCREMENTAL FILTER will use as defaults. ## Result Columns | Column | Type | Description | |--------|------|-------------| | property | VARCHAR | The configuration property name (columns, datecol, overlap_days, filter, dialect). | | value | VARCHAR | The stored value, or NULL if the property has not been configured. | The result always contains exactly five rows, one for each configurable property: 1. **columns** - Comma-separated list of key-based incremental columns. 2. **datecol** - Date or timestamp column name. 3. **overlap_days** - Number of days to subtract from the maximum date value. 4. **filter** - Static SQL filter condition. 5. **dialect** - SQL dialect for output formatting. ## Implementation Details The command opens a snapshot of the Delta table and reads the `configuration` map from the table metadata. Properties are read from the `delta.forge.incremental.*` namespace. If a property has not been set, the corresponding value is returned as NULL. This is a read-only operation that does not modify the table or create a new log commit. ## Typical Workflow 1. Run SET INCREMENTAL CONFIG to establish defaults. 2. Run SHOW INCREMENTAL CONFIG to verify the stored values. 3. Run INCREMENTAL FILTER (with no inline overrides) to generate the WHERE clause using stored defaults. 4. If configuration changes are needed, run SET INCREMENTAL CONFIG again with updated parameters. 5. To remove all incremental configuration, run UNSET INCREMENTAL CONFIG.

Parameters

Name	Type	Description
`table`		Specifies the Delta table whose incremental loading configuration to display. The table must be registered in the current session (via CREATE DELTA TABLE or OPEN DELTA TABLE). Use a fully qualified name (catalog.schema.table) when multiple schemas are in scope.

Examples

-- View incremental configuration for a table
SHOW INCREMENTAL CONFIG ON warehouse.orders;

-- Verify configuration after setting it
SET INCREMENTAL CONFIG ON staging.events
    COLUMNS (event_id)
    DATECOL created_at
    OVERLAP 3 DAYS
    DIALECT POSTGRES;

SHOW INCREMENTAL CONFIG ON staging.events;

Pitfalls

The table must be registered in the current session. If you receive a 'Table not registered' error, run OPEN DELTA TABLE or CREATE DELTA TABLE first.
This command shows only the persisted configuration. It does not show inline parameters that would be passed to INCREMENTAL FILTER at runtime. To see the effective configuration for a specific invocation, review both the stored config and the inline overrides.
NULL values indicate that a property has never been set (or has been removed via UNSET INCREMENTAL CONFIG). INCREMENTAL FILTER treats unset properties as absent unless overridden inline.