Data Lakehouse Workshop

The data lakehouse is a data architecture pattern that combines functional aspects of the data warehouse, with the data lake, on one platform. This workshop will walk through an example of how the data lakehouse pattern can be facilitated in Azure with Azure Synapse Analytics.

📃 Agenda

🤔 Prerequisites

• An Azure account with an active subscription.
  • If you are working through this content as part of a proctored workshop, your proctor may be able to provide you with an Azure Pass. Instructions on how to activate an Azure Pass can be found here.
  • Alternatively, if you don't have access to an Azure subscription, you may be able to sign up for a free account.
• You must have the necessary privileges within your Azure subscription to create resources, perform role assignments, register resource providers (if required), etc.

🧪 Lab Environment Setup

• Azure Pass Activation
• Resource Provider Registration
• Lab Environment

📚 Learning Modules

1. Customers
   • 1A. Incremental Copy to Raw (using Change Data Capture)
   • 1B. Dimension Table - Initial Load
   • 1C. Dimension Table - Incremental Load (SCD Type 2)
   • 1D. Automation using Triggers
2. Orders
   • 2A. Incremental Copy to Raw (using High Watermark)
   • 2B. Fact Table - Incremental Load
   • 2C. Automation using Triggers
3. Logical Data Warehouse
4. Data Visualization

↥ back to top

🔗 Workshop URL

aka.ms/lakehouselab