...
While tuning the ImportAmalgamate the following sql can be used. Please enable the appropriate appropriate 7 day condition on creationTime for your database flavour to see what Tasks have been produced over the last week with external historical timeseries.
...