Richer variable support
Allow me to have custom variables at a pipeline and Factory level, which can be refreshed at a specified schedule from a dataset -- the closest analogue for this would be SSIS variables
One use case for this would be for me to store a set of UTC offsets in a SQL table for each data source, and query this table at pipe runtime to retrieve the correct offset for each source. This offset can then be stored in variables for each pipeline
Very essential to me as well. No idea why it is not implemented yet.
something similar to Application Settings in Azure Functions would be perfect: https://docs.microsoft.com/en-us/azure/azure-functions/functions-how-to-use-azure-function-app-settings
I use SSIS and when I saw Data Factory first time i expected something like SSIS.... But guys. you have not implemented good stuffs that are in SSIS. I was surprised that Data Factory does not have a user variables and a lot of other functionality.
Peter Gadsby commented
To me this is essential