cancel
Showing results for 
Search instead for 
Did you mean: 
Data Governance
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

quakenbush
by Contributor
  • 3813 Views
  • 4 replies
  • 5 kudos

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

  • 3813 Views
  • 4 replies
  • 5 kudos
Latest Reply
Senthil1
Contributor
  • 5 kudos

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
3 More Replies
Labels