At present I read all the data inside a .csv file which sits in the blobstorage container.
On each run of the data factory, based on the parameters based I want to select only certain rows, i.e.
select * from (dataset of the csv) where field1 = @param1 and field3 = @param2
Is this possible?
I can do the exact same thing in copy activity pointing to sql server but not sure how this is achieved reading from csv.