I want to use a pipline ADF to call an API REST which used an sql table and extracts one or more files. API should return 3 files if the table contains 3 different regions, for this reason I used the following activities: A lokupctivity : it’s a query ( distinct on the column Regions) to get all the regions
Tag: azure-data-factory
Excel into Azure Data Factory into SQL
I read a few threads on this but noticed most are outdated, with excel becoming an integration in 2020. I have a few excel files stored in Drobox, I would like to automate the extraction of that data into azure data factory, perform some ETL functions with data coming from other sources, and finally push the final, complete table to