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

create_if_not_exists

Enable IF NOT EXISTS for CREATE statement by default. If either this setting or IF NOT EXISTS is specified and a table with the provided name already exists, no exception will be thrown.

create_index_ignore_unique

Ignore UNIQUE keyword in CREATE UNIQUE INDEX. Made for SQL compatibility tests.

create_replicated_merge_tree_fault_injection_probability

The probability of a fault injection during table creation after creating metadata in ZooKeeper

create_table_empty_primary_key_by_default

Allow to create *MergeTree tables with empty primary key when ORDER BY and PRIMARY KEY not specified

create_token_default_ttl_seconds

The lifetime, in seconds, given to a token created by CREATE TOKEN which does not specify its own VALID UNTIL or VALID FOR clause. The default is 30 minutes, so a token that is not asked to live longer is short-lived. Possible values:
  • Positive integer — the token expires this many seconds after it is created.
  • 0 — a token without an explicit clause never expires.
This is only a default. An explicit VALID UNTIL or VALID FOR clause of the query always wins, including VALID UNTIL 'infinity', which creates a token that never expires regardless of this setting.
Last modified on September 7, 2026