Hi @Jason W ,
Welcome to Microsoft Q&A Platform. Thanks for posting the query.
Dataflows in data factory is a suitable cloud ETL tool for such requirements that has lot of transformation activities which will help in working with the data before loading from source to sink.
Event Triggers in Azure Data Factory are useful in running the pipelines as soon as files are added into the ADLS and incremental load approach using last modified date in data factory is useful in controlling loading files uploaded in certain time duration.
Please suggest for further queries and we will be glad to assist.
- Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
- Want a reminder to come back and check responses? Here is how to subscribe to a notification.