Bulk Hide Tables

#1

Hi,

I have a database with lots of extraneous tables. its impractical to go through hiding tables one-by-one, is there a bulk hide capability?

Best regards,

Marc

#2

Hi @mdm20

You can use the API:
https://github.com/metabase/metabase/blob/master/docs/api-documentation.md#put-apitableid
https://github.com/metabase/metabase/wiki/Using-the-REST-API

You might be able to set column visibility_type = hidden in table metabase_table of your metadata (the Metabase backend database) - I’m not sure if this might mess things up, since it’s not recommended to mess around with metadata directly, so make sure you have a backup.

#3

I’ve used the update to the sql tables frequently. Works a treat, but as @flamber says, not supported.
Personally, I’d prefer everything hidden by default as I tend to use views, but the option to hide all the tables when you initially create the db connection would be great.

1 Like