How to prompt user for runtime parameters?
We want to use Matillion to fill in a table for financial forecasting and analysis. Controllers want to manually start the ETL job and specify which period and version to select. What would be the best way of building such a user interaction?
We can use environment variables in the filter conditions, and ask the controllers to change the value of those environment variables before running. However, that's not really convenient for the user. Ideally we'd have some kind of prompt at starting the job.
I know Matillion is not a query and reporting tool, but in this particular case, building this data set with Matillion seems to be the best way of meeting user needs.