metabase-clickhouse-driver icon indicating copy to clipboard operation
metabase-clickhouse-driver copied to clipboard

Published 20 hours ago • verified publisher icon ClickHouse

Ability to exclude some tables from loading into Metabase

Open ppavlov39 opened this issue 9 months ago • 2 comments

Hi! In our environment we use Clickhouse as DWH, Metabase as BI, DBT as a tool for building analytical marts.

DBT creates temporary views during its work. These views can contain very heavy queries that are usually executed on a small amount of data (incremental build of marts is used). And when Metabase finds such a view, it tries to get its content without using restrictions on the volume of data to be selected and cannot do this, because the query fails. This also leads to a high load on the DWH.

It would be great if there was a way to exclude some tables and views from scanning Metabase by its name.

ppavlov39 avatar Feb 17 '25 13:02 ppavlov39

Would you like to contribute? I think this should be a fairly easy task, and I can provide guidance if you DM me in public Slack.

slvrtrn avatar Feb 25 '25 19:02 slvrtrn

Hi! Unfortunately, I have neither experience with Clojure nor the opportunity to find time to learn it :(

ppavlov39 avatar Feb 26 '25 07:02 ppavlov39