UNSET INCREMENTAL CONFIG

Removes all incremental loading configuration from a Delta table's properties.

Category: incrementalDeltaForge extension

Syntax

UNSET INCREMENTAL CONFIG ON <table>

Description

## Overview UNSET INCREMENTAL CONFIG removes all five `delta.forge.incremental.*` table properties from the Delta table's transaction log. After this operation, INCREMENTAL FILTER can no longer fall back to stored defaults and requires all parameters to be provided inline. ## Properties Removed The following properties are removed in a single atomic commit: | Property | Description | |----------|-------------| | `delta.forge.incremental.columns` | Key-based incremental columns | | `delta.forge.incremental.dateColumn` | Date/timestamp column | | `delta.forge.incremental.overlapDays` | Overlap buffer in days | | `delta.forge.incremental.filter` | Static filter condition | | `delta.forge.incremental.dialect` | SQL dialect preference | ## Implementation Details The command uses AlterTableBuilder to unset each property from the Delta log. All five properties are removed in a single commit, ensuring atomicity. If a property was not previously set, the unset operation for that property is a no-op. After execution, SHOW INCREMENTAL CONFIG returns NULL for all five properties. ## When to Use - **Full replacement**: Clear all stored configuration before applying a new SET INCREMENTAL CONFIG, ensuring no stale properties remain from a previous configuration. - **Decommissioning**: Remove incremental configuration when a table is no longer loaded incrementally (e.g., switched to full refresh or snapshot-based loading). - **Troubleshooting**: Remove configuration to verify that inline parameters produce the expected filter without interference from stored defaults. ## Data Safety This command only removes metadata (table properties). It does not delete table data, modify the table schema, or affect the table's transaction history. The removal itself is recorded as a new commit in the Delta log and can be seen via DESCRIBE HISTORY.

Parameters

Name	Type	Description
`table`		Specifies the Delta table from which to remove all incremental loading configuration. 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

-- Remove all incremental configuration from a table
UNSET INCREMENTAL CONFIG ON warehouse.orders;

-- Replace incremental configuration by clearing and re-setting
UNSET INCREMENTAL CONFIG ON staging.events;

SET INCREMENTAL CONFIG ON staging.events
    COLUMNS (event_id)
    DATECOL updated_at
    OVERLAP 5 DAYS
    DIALECT MSSQL;

-- Verify removal
UNSET INCREMENTAL CONFIG ON warehouse.orders;
SHOW INCREMENTAL CONFIG ON warehouse.orders;

Pitfalls

This command removes all five incremental properties at once. There is no way to unset a single property selectively. To change one property while preserving others, use SET INCREMENTAL CONFIG with only the properties you want to update.
After running UNSET INCREMENTAL CONFIG, any pipeline that calls INCREMENTAL FILTER without inline parameters will receive NULL filters. Update pipelines to provide inline parameters or re-apply SET INCREMENTAL CONFIG before the next pipeline run.
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.
Running UNSET on a table that has no incremental configuration is safe and creates a log commit with no effective changes.