Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

delta_lake_* session settings

These settings are available in system.settings and are autogenerated from source.

delta_lake_enable_engine_predicate

Type
Bool
Default
1
Version history
VersionDefault valueComment
25.81New setting

Enables delta-kernel internal data pruning.

delta_lake_enable_expression_visitor_logging

Type
Bool
Default
0
Version history
VersionDefault valueComment
25.80New setting

Enables Test level logs of DeltaLake expression visitor. These logs can be too verbose even for test logging.

delta_lake_insert_max_bytes_in_data_file

Type
NonZeroUInt64
Default
1073741824
Version history
VersionDefault valueComment
25.91073741824New setting.

Defines a bytes limit for a single inserted data file in delta lake.

delta_lake_insert_max_rows_in_data_file

Type
NonZeroUInt64
Default
1000000
Version history
VersionDefault valueComment
25.91000000New setting.

Defines a rows limit for a single inserted data file in delta lake.

delta_lake_log_metadata

Type
Bool
Default
0
Version history
VersionDefault valueComment
25.100New setting.

Enables logging delta lake metadata files into system table.

delta_lake_reload_schema_for_consistency

Type
Bool
Default
0
Version history
VersionDefault valueComment
26.30New setting to control whether DeltaLake reloads schema before each query for consistency.

If enabled, schema is reloaded from the DeltaLake metadata before each query execution to ensure consistency between the schema used during query analysis and the schema used during execution.

delta_lake_snapshot_end_version

Type
Int64
Default
-1
Version history
VersionDefault valueComment
25.12-1New setting.

End version of delta lake snapshot to read. Value -1 means to read latest version (value 0 is a valid snapshot version).

delta_lake_snapshot_start_version

Type
Int64
Default
-1
Version history
VersionDefault valueComment
25.12-1New setting.

Start version of delta lake snapshot to read. Value -1 means to read latest version (value 0 is a valid snapshot version).

delta_lake_snapshot_version

Type
Int64
Default
-1
Version history
VersionDefault valueComment
25.8-1New setting

Version of delta lake snapshot to read. Value -1 means to read latest version (value 0 is a valid snapshot version).

delta_lake_throw_on_engine_predicate_error

Type
Bool
Default
0
Version history
VersionDefault valueComment
25.80New setting

Enables throwing an exception if there was an error when analyzing scan predicate in delta-kernel.

Navigation