Getting files and folders in the datalake while reading from datafactory

Question

While reading azure sql table data (which actually consists of path of the directories) from azure data factory by using the paths how to dynamically get the files from the datalake.

Can any one tell me what should I give in the dataset

Screenshot

Answer 1

You could use lookup activity to read data from azure sql, and then following it by an foreach activity. And then, pass @item(). to your dataset parameter k1.