This demo-filled session will show how to populate a data warehouse (SQL Server, Azure SQL, or Fabric warehouse) by using a meta-data driven, parameterized approach with Data Factory. We'll discuss what metadata needs to be captured to achieve goals such as increased reusability and restartability and minimized deployment and maintenance effort. And we'll look at common Data Factory orchestration and execution patterns.

You will learn:

• Demonstrate how to build metadata-driven pipelines
• Discuss the benefits of metadata-driven pipelines
• Demonstrate use of control tables to capture and serve metadata