We use Redshift to store our Final tables, which we use to refresh the data on a daily basis using Alteryx.
However, our Alteryx Workflows can become stuck if the table is locked,
and we won't be able to load the data unless we manually release the lock with PG_CANCEL_BACKEND(PID);
We want to set up our workflow so that when we start our daily refresh, it first checks to see if all of the tables are free or locked.
Continue with the workflow run if they are free; if not, release the lock from the table and begin the run.
Please assist with these scenarios and, if feasible, please attach sample workflows.
Thanks & Regards,
Shashank R. Shukla
