Azure Data Factory | Dynamic Query

This Azure Data Factory v2 (ADF) step by step tutorial looks at the scenario where you want to get an incremental/delta data set from your Azure SQL Database or alternative source database, typically retrieving data for the last day or last 30 days. The challenge with this scenario is that you don't have access to the source database to do anything other than query it. We will look at how to generate dynamic queries using the ADF syntax and storing the query in a variable before executing the query against the source Azure SQL Database database using the ADF copy command. #ADF #AzureDataFactory #Azure #MicrosoftAzure #ETL #ELT #AzureTutorial #AzureTraining #AzureStepByStep YouTube: https://www.youtube.com/channel/UChqe3DQKKfIbXBtlilE4SCQ ADF Playlist: https://www.youtube.com/playlist?list=PLIZaQYhfO3ee0pqovkeXuJcnDu_hvkTu4 Web: https://bidesign.uk Resources: https://bidesign.uk/bi-design-resources/ Connect: https://www.linkedin.com/in/bidesign/