Data Staging Framework Example
Process Diagram
This project uses a robust process using a combination of Alteryx and SQL stored procedures to test and log all staged inputs to ensure optimized data objects are ready before the object is created. This prevents empty tables when upstream processes are down or having load issues. This process also uses the event notification framework to notify the developer(s) and/or manager(s) that we are using the previous data load when the process doesn't finish so it can be re-run at a later time.