Parameters for Data Transformation Flows
When I create a Data Transformation Flow pulling data from my SQL database, I would like to be able to manage parameters for that flow. For example, if I only want to copy over data for a particular date range, I want to be able to specify a start and end date parameter every time I manually execute the report. My freehand SQL query can then reference these parameters to only select the data that I am interested in. If I find and correct an error in my source data and want to copy over the corrected data to my output database but don't expect other data to have changed, I'm not copying over a whole bunch of data with identical data. When the transformation is scheduled, the parameters would also need to be given values which could be based on the date or time that the report is running.