I am trying to create a views in my unity catalog but unable to create the views and getting error as below like, also, I have two compute which is one enabled unity catalog with shared resource and another one which is SQL warehouse compute both i tried use but no luck.
sample query
create view catalogname.catalogshcema.viewname as
select * from hive_metastore.data_vault.tablename
`AnalysisException: [UC_COMMAND_NOT_SUPPORTED.WITHOUT_RECOMMENDATION] The command(s): Creating a persistent view that references both Unity Catalog and Hive Metastore objects are not supported in Unity Catalog.`
Kindly assist