We previously discussed how to use Power BI on top of Databricks Lakehouse efficiently. However, the well-designed and efficient Lakehouse itself is the basement for overall performance and good user experience. We will discuss recommendations for physical layout of Delta tables, data modeling, as well as recommendations for Databricks SQL Warehouses.
These tips and techniques proved to be efficient based on our field experience. We hope you will find them relevant for your Lakehouse implementations too.
Read on for these tips.