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

show_data_lake_catalogs_in_system_tables

Enables showing data lake catalogs in system tables.

show_processlist_include_internal

Show internal auxiliary processes in the SHOW PROCESSLIST query output. Internal processes include dictionary reloads, refreshable materialized view reloads, auxiliary SELECTs executed in SHOW ... queries, auxiliary CREATE DATABASE ... queries executed internally to accommodate broken tables and more.

show_remote_databases_in_system_tables

Enables showing MySQL and PostgreSQL databases in system tables.

show_table_uuid_in_table_create_query_if_not_nil

Sets the SHOW TABLE query display. Possible values:
  • 0 — The query will be displayed without table UUID.
  • 1 — The query will be displayed with table UUID.
Last modified on July 22, 2026