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
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