Description
Contains information about the ClickHouse server’s build options.
Columns
name (String) — Name of the build option.
value (String) — Value of the build option.
Example
SELECT * FROM system.build_options LIMIT 5
┌─name─────────────┬─value─┐
│ USE_BROTLI │ 1 │
│ USE_BZIP2 │ 1 │
│ USE_CAPNP │ 1 │
│ USE_CASSANDRA │ 1 │
│ USE_DATASKETCHES │ 1 │
└──────────────────┴───────┘
Last modified on June 8, 2026