We are using redshift, and have hundreds of tables across ~20 schemas.
Only a handful of schemas are relevant enough to our metabase application. Ideally there would be a way to toggle off visibility for entire schemas in metabase, rather than manually clicking through hundreds of tables.
I tried to accomplish this using user permissions in redshift, but even users without permission to schemas can still see that the schema exists.