I have an MS SQL server database that has several schemas we need to ingest data from. Call them "SCHEMA1" tables and "SCHEMA2" tables. Let's call the server S and the database D. In unity catalog I have a catalog called "staging" where the staging (bronze) data from all sources ends up in.

In staging I have a schema called "S_D", which is fine. However to distinguish the tables from the two different source schemas I end up calling them "SCHEMA1_TableName", "SCHEMA2_TableName", etc. That is, I use underscores to distinguish the two source schemas.

Is there a better way to handle this? Or is there a best practice? I would rather not have a separate catalog for each staging data source.