Active management of files being processed in enterprise data warehouses utilizing time series predictions

A computing device, comprising:

• a processor;
• and
• a computer-readable medium including instructions that, when executed by the processor, cause the processor to perform operations comprising:
• receiving historical data from a staging area and a target database of a data warehouse;
• generating a feature for a machine learning model based at least in part on the historical data;
• generating a forecasted time interval between receipt of data at the staging area and receipt of the data at the target database using the machine learning model and based at least in part on the generated feature, the data to be transmitted from the staging area to the target database;
• comparing the forecasted time interval with an expected time interval for a file received at the staging area;
• and
• generating a work ticket associated with the file based at least in part on the comparison.

A non-transitory computer-readable medium having stored thereon a sequence of instructions that, when executed by a processor, causes the processor to perform operations comprising:

• receiving historical data from a staging area and a target database of a data warehouse;
• generating a feature for a machine learning model based at least in part on the historical data;
• generating a forecasted time interval between receipt of data at the staging area and receipt of the data at the target database using the machine learning model and based at least in part on the generated feature, the data to be transmitted from the staging area to the target database;
• comparing the forecasted time interval with an expected time interval for a file received at the staging area;
• and
• generating a work ticket associated with the file based at least in part on the comparison.