Creating a persistent view that references both Unity Catalog and Hive Metastore objects is not supported in Unity Catalog
I tried to create a view in hive_metastore.default which would access a table from a different catalog. Is there any chance to do so?eg.create view myTest as select * from someCatalog.someSchema.someTable
- 6416 Views
- 4 replies
- 5 kudos
Latest Reply
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 Catalog2) Now expose the Unity Catalog using DELTA SHARING to your BI ap...
- 5 kudos