We have a large MS SQL Database which has multiple schemas and large number of tables, which takes a lot of time to initialize. Most of the schemas/tables are not required to be pulled into metabase.
Is it possible to Select individual schemas/tables while creating the Data source?
Is there any way to minimize the initialization time?
We are aware of the Hiding Option in the Data Model
Does hiding help in reduction of initialization time ?
What is your definition of "large"? Hundreds, thousands, ...
If the database user, which Metabase uses, only has privileges to specific schemas and tables, then Metabase will only be able to see those, so that would be the main recommendation to setup.
Since you cannot hide tables before the initial load, then Metabase will have to sync first.
But once you hide a table, then Metabase will not sync this table again.