Forum Discussion
Lakeouse questions
Hi smpa01
Thanks for actively participating in MS fabric community support.
There is currently no supported way to create a logical (non-materialized) view directly over Lakehouse files (e.g., daily Parquet/Delta fetches) in SQL Warehouse. This is a limitation of Microsoft Fabric compared to Databricks, which allows logical views directly over Delta locations.
please refer to below doc for more info:
https://learn.microsoft.com/en-us/fabric/data-warehouse/limitations
Currently, supported use cases include:
-
Creating logical views over existing registered tables in the Lakehouse.
-
Creating materialized views on those tables.
-
Using OPENROWSET to read Parquet or CSV files.
To work with Delta files in SQL, the data must first be loaded into a table within the Lakehouse, after which views can be created as needed.
Thanks,
Prashanth Are
MS Fabric community support
-
Hi smpa01
Thanks for actively participating in MS fabric community support.
There is currently no supported way to create a logical (non-materialized) view directly over Lakehouse files (e.g., daily Parquet/Delta fetches) in SQL Warehouse. This is a limitation of Microsoft Fabric compared to Databricks, which allows logical views directly over Delta locations.
please refer to below doc for more info:
https://learn.microsoft.com/en-us/fabric/data-warehouse/limitations
Currently, supported use cases include:
-
Creating logical views over existing registered tables in the Lakehouse.
-
Creating materialized views on those tables.
-
Using OPENROWSET to read Parquet or CSV files.
To work with Delta files in SQL, the data must first be loaded into a table within the Lakehouse, after which views can be created as needed.
Thanks,
Prashanth Are
MS Fabric community support