ClickHouse databases flattened as “All tables” in SQL Editor

Ask the Community
1

Hi,

When connecting ClickHouse to Holistics, the SQL Editor shows all tables under “(All tables)” instead of grouping them by database.

However, in ClickHouse we actually have multiple databases, and queries like this work correctly:

SHOW DATABASES;

SELECT database, name
FROM system.tables
ORDER BY database, name;

So the database metadata exists and is accessible.

But in Holistics SQL Editor, everything is flattened into (All tables) and database folders are not shown.

Is this expected behavior for the ClickHouse connector, or is there a way to enable database-level grouping?

Thanks!

2

Hi @Dawei, we’ve replied to your support ticket regarding this issue with a few follow-up questions. Could you please check your email when you have a chance? Thank you!