Forum Discussion

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
1 year ago
Solved

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 view...
data engineering
lakehouse
notebook
  • v-prasare's avatar
    v-prasare
    1 year ago

    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

     

     

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
1 year ago

Yes you are right. You can not create views in Fabric Datawarehouse. The only way forward is Materialized Views in Silver tables in Lakehouse. Databricks has advantage here than Microsoft...But Microsoft in long run is beneficial....