system.licenses - ClickHouse Documentation

Sitelet https://clickhouse.com/docs/reference/system-tables/licenses

Description

Contains licenses of third-party libraries that are located in the contrib directory of ClickHouse sources.

Columns

library_name (String) — Name of the library.
license_type (String) — License type — e.g. Apache, MIT.
license_path (String) — Path to the file with the license text.
license_text (String) — License text.

Example

SELECT library_name, license_type, license_path FROM system.licenses LIMIT 15

┌─library_name───────┬─license_type─┬─license_path────────────────────────┐
│ aws-c-common       │ Apache       │ /contrib/aws-c-common/LICENSE       │
│ boost              │ Boost        │ /contrib/boost/LICENSE_1_0.txt      │
│ brotli             │ MIT          │ /contrib/brotli/LICENSE             │
│ [...]              │ [...]        │ [...]                               │
└────────────────────┴──────────────┴─────────────────────────────────────┘

Last modified on September 8, 2026