Hi,
I have a pipeline that simply selects data from a sql db and exports the data to csv into blob storage, works fine.
The data is sometimes only needed to be run once in a week and other times maybe 10 times in a day, the users will control when they need the data.
Just need advice on what I should be looking at to achieve this and what you think are best ways.
I originally was thinking something like a webpage with a button they click to run the pipeline.
I've had a quick look and some are saying use Web Activity or Logic App or Power Automate when email received etc. but I don't want to head down any of these avenues without knowing what is the recommended/standard way of doing above.
Any advice you can give would be much appreciated.
Thanks.