ClickHouse documents itself

Mark Needham

ClickHouse's documentation doesn't just live on our website, it ships with the product too. You can look things up with the help command in the terminal, browse everything in a built-in docs UI, or query the system tables underneath it all. In this video, we try all three with clickhouse local, no server required.

In this video:

• help bar, help session_query_ids_history_size and other lookups right in the terminal
• Typo suggestions when you get a name slightly wrong
• Serving the docs UI from clickhouse local with SYSTEM START LISTEN HTTP
• Searching, copying code and following links in the docs UI
• Querying system.documentation, system.functions and system.settings directly

Links:

• system.documentation
• system.functions
• system.settings
• system.settings_changes
• clickhouse-local