Lakeouse questions

1. Can you create views in SQL warehouse (the warehouse counterpart of a lakehouse; and not a standalone warehouse with no lakehouse) from the delta files directly? (I know that you can't create views, not materialized views in Lakehouse the same way you can in databricks catalog, from the delta files from volume/external storage).

select 
    base.*,    
from delta.`Files/test` as base

2. Can you read the parquet files (written in lakehouse files from daily fetch) directly with SQL endopint (warehouse counterpart of the lakehouse) somehow (I was thinking OPENROWSET, but I am getting an error).

create view dbo.p2 
as
select 
    base.*    
from openrowset( 
BULK 'https://onelake.dfs.fabric.microsoft.com/server/lakehouse_testing.Lakehouse/Files/test',
FORMAT = 'DELTA'
) as base

/* this does not work*/

So far, I have  concluded that there is no way to create a view in sql warehouse (counterpart) directly from the files of daily fetch. I am not interested in creating a SQL view of a table that already exists or creating a materialized view in Lakehouse. I simply intersted in determining whether FAbric can create Logical views the same way databricks can from delta?

@v-prasare 

@