Azure Data Factory | Dynamic Incremental Load

preview_player
Показать описание
This Azure Data Factory v2 (ADF) step by step tutorial guides you through a method of performing a dynamic incremental load in Azure Data Factory driven by metadata stored in Azure SQL Database and utilising the brilliant Azure Data Factory foreach loop.

#ADF #AzureDataFactory #Azure #MicrosoftAzure #ETL #ELT #AzureTutorial #AzureTraining #AzureStepByStep

Рекомендации по теме
Комментарии
Автор

Hi man,
Very good content! Usually people create the same step by step with basic and you are exploring the tool with a optimization perspective. Thank you for share!

skaina
Автор

The approach taken is really excellent. Appreciate your good work and thanks for sharing.

alladamk
Автор

Add....
Usually data team don't have permission to create object on source database. Only on the target. My ideia is read tables filtering a period (or any other column).

Do you know how can I customize a query with a filter parameters (ex: date) on a source connection? Of course, thinking to use that with a dynamic pipeline in the future.
Thanks!

skaina
Автор

The approach taken is really excellent. Appreciate your good work and thanks for sharing.

alladamk