I will suggest the below links will help you,

For exposing your Hive_metastore multiple catalogs,

1) Create 3 catalogs for each environment under single metastore by using Unity Catalog

2) Now expose the Unity Catalog using DELTA SHARING to your BI app/tool

i) Create a SHARE and tag your tables. views from all the required CATALOGS

ii) Create a RECEPIENT and attach that SHARE with necessary GRANT privileges

Here data won't be replicated or transferred, but it will provide authorized views for all your apps.

Follow this, it works

Share data securely using Delta Sharing - Azure Databricks | Microsoft Learn