Data Cookbook Kitchen

Did you know that ClickHouse has a built in schema visualizer? It was introduced in version 26.6 and it shows not only databases and tables, but also - and this is what I get asked about time and again - the internal data flows through materialized views and dictionary update cycles!

In an unsecured local environment, you point your browser to http://localhost:8123/schema to access it.

But with version 26.6 being rolled out in the Fast channel, this feature is also coming to ClickHouse Cloud! Simply use the endpoint URL you get from the Connect button in the Cloud console. You will have to enter the password for database user default before you can access the schema. Here’s a screenshot:

Schema visualizer screenshot

You can see:

  • regular tables in light brown
  • integration “tables” (in this case Kafka) in dark brown
  • incremental materialized views in purple
  • refreshable materialized views in magenta.

Dictionaries would show up in blue and also have an arrow pointing from the source table toward them.

The red insert in the materialized view at the bottom shows aggregated metrics for that materialized view. That way, you get a quick view on your materialized views, how active they are, and the amount of resources they use.

“This image is taken from Page 377 of Praktisches Kochbuch für die gewöhnliche und feinere Küche” by Medical Heritage Library, Inc. is licensed under CC BY-NC-SA 2.0 .