📅 Wednesday, May 14, 2025 📅
🕜 5:15 pm @ Jones Creek Library
Lighting Round: Doug Lubey
Architecting 1000s of APis to work together!
Main Speaker: Thomas LeBlanc
The Fabric capacity allows you, a data engineer versus a T-SQL analyst, to use Delta Tables in OneLake. This consistent Data Lake storage is an open-source structure that stores data in a column-store, compressed format. Column-store is faster for analytical reporting than rows in a database. The session starts with importing csv files and creating tables in a Lakehouse. The Monitor Hub will show the Spark engine processing the request. After creating a shortcut to parquet files in a storage account, a notebook will be shown to import that shortcut to a Lakehouse table. This data will then be ETL-ed into a Warehouse with a dataflow. Finally, we will create a Direct Lake semantic model for reporting in Power BI.