Set up docs MCPThese settings are available in system.settings and are autogenerated from source.
show_data_lake_catalogs_in_system_tables
Type
Bool
Default
0
Version history
| Version | Default value | Comment |
|---|---|---|
| 25.8 | 1 | New setting |
| 25.10 | 0 | Disable catalogs in system tables by default |
Enables showing data lake catalogs in system tables.
show_processlist_include_internal
Type
Bool
Default
1
Version history
| Version | Default value | Comment |
|---|---|---|
| 25.11 | 1 | New setting. |
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
Type
Bool
Default
1
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.7 | 1 | New setting to control whether `MySQL` and `PostgreSQL` databases are shown in `system.tables`, `system.columns` and `system.completions`. |
| 26.2 | 1 | New setting to control whether `MySQL` and `PostgreSQL` databases are shown in `system.tables`, `system.columns` and `system.completions`. |
Enables showing MySQL and PostgreSQL databases in system tables.
show_table_uuid_in_table_create_query_if_not_nil
Type
Bool
Default
0
Version history
| Version | Default value | Comment |
|---|---|---|
| 20.7 | 0 | Stop showing UID of the table in its CREATE query for Engine=Atomic |
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.