Folders plugin or otherwise for organising tables in a database?

Get Help
1

We connect to metabase from postgres, redshift and clickhouse.

For postgres and redshift, tables within a database are organised into folders in the UI based on their schema.

Clickhouse doesn’t have schemas, so we’re wondering how we can get similar grouping of tables in the database view.

If we could wave a magic wand, we would have a plugin that would allow us to create dynamic folders based on a regex on the table name. I don’t suppose any such thing exists?

What other solutions to the problem of too many tables appearing in the database view making navigation very difficult?

2

What other solutions to the problem of too many tables appearing in the database view making navigation very difficult?

Some quick thoughts:

Use Table Metadata to hide tables that aren’t useful for notebook queries. You can still reference them in SQL queries.

Build Models as the entry point to important tables. Have your users look at models first. Make other reusable pieces so you don’t have to dig through the raw database table list.

Clean up the Clickhouse, drop those old unused tables :slight_smile:

Use DuckDB or some other proxy database to apply an organization layer.