Spark Data Engineering Patterns Optimizing Delta Tables for Power Bi in Microsoft Fabric

[@lukaszk4388]

i appreciate you explained scenario when v-order are not used

[@Milhouse77BS]

Nice explanation and demonstration. Thanks.

[@NISHILJAIN]

Disabling V-Order in Bronze layer will inpact data movement from Bronze to Silver layer as the SQL reads will be slower. So if a minor write penatly in Bronze layer is acceptable then it should not be disabled. But totally agree that V-Order will help with presentation layer (Power BI reports).

[@NeumsFor9]

As an architect I always list out all my potential consumers of every layer..... especially once a data quality susbsystem is involved with the ETL.

[@NeumsFor9]

Can V-Order and Z-Order co-exist? If so what is the overhead?

[@dbrx4]

Good job Microsoft team having your own Databricks product 🤭