I'll be discussing how to build an Azure Data Lake ingestion framework using Data Factory, Azure SQL, and Data Vault modeling during an upcoming Cloud PASS virtual event:
Date: June 27th
In the mean time check out these other blogs on Azure Data Factory: