Skip to main content
These settings are available in system.settings and are autogenerated from source.

ignore_cold_parts_seconds

Only has an effect in ClickHouse Cloud. Exclude new data parts from SELECT queries until they’re either pre-warmed (see cache_populated_by_fetch) or this many seconds old. Only for Replicated-/SharedMergeTree.

ignore_data_skipping_indices

Ignores the skipping indexes specified if used by the query. Consider the following example:
The query without ignoring any indexes:
Ignoring the xy_idx index:
Works with tables in the MergeTree family.

ignore_drop_queries_probability

If enabled, server will ignore all DROP table queries with specified probability (for Memory and JOIN engines it will replace DROP to TRUNCATE). Used for testing purposes

ignore_format_null_for_explain

If enabled, FORMAT Null will be ignored for EXPLAIN queries and default output format will be used instead. When disabled, EXPLAIN queries with FORMAT Null will produce no output (backward compatible behavior).

ignore_materialized_views_with_dropped_target_table

Ignore MVs with dropped target table during pushing to views
Last modified on July 24, 2026