Automatically change the alias of a table in metabase and hide tables

1

I have a few tables in a database from a big enterprise system that are created based on an automated process triggered by a customer (they upload some data in esoteric formats and we create relational tables that represent that data). In metabase. In our system, we have a data dictionary in a separate schema that has that information

Is there an API or a programmatic way that we can use to:

  1. hide all tables in a particular schema? For example, the database has the schema public.* - we want to show all the tables in that schema. But is also has a schema called private.* - we want to automatically hide all tables in that schema.

  2. programatically create aliases for that table (e.g. dataset_1234 should be called ‘report_result’)?

Thanks!