I'm using a copydata activity inside datafactory to connect to azure datalake and insert a range of csv files into Azure data warehouse.
My question is : what is the best way to filter a csv file before inserting it into data base.
What is the drawbacks of insertion of all file's rows and then use a stores procedure to come with a filtering action.
PS: I don't privilege data flow
Thanks for your help