system.build_options - ClickHouse Documentation

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 July 2, 2026

system.certificatesContains information about available certificates and their sources.