Data Warehouse

Businesses rely on a single version of truth to operate effectively and the tool of choice for data-driven organizations around the globe has long been the data warehouse. Names such as Ralph Kimball and Bill Inmon are synonymous with design patterns, and Kimball’s The Data Warehouse Toolkit could be found on the desk of just about any BI developer in the 2010s. While the technology has changed and the lakehouse is becoming more popular, the value of a data warehouse remains and companies are embarking on new warehouse projects every day.

The decision between a data warehouse and a lakehouse in Fabric is largely one of skillset rather than technology. Data Factory ETL tooling, Power BI datasets, SQL, and Spark all work seamlessly over both lakehouses and warehouses, and they both deliver massive scale and high performance. The primary difference comes down to the skillset: Spark for lakehouses versus T-SQL for data warehouses.

If companies have developer...