I have a workflow that inputs data into a table and then runs some post-sql scripts that runs an update query based on the data that was just loaded into the table. The problem is that the post-sql script appears to be running before the data is loaded and therefore the new data is not in the update.
It is also concerning that the pre-sql runs before the workflow has processed the data. This has caused issues where the "Drop table" pre-sql runs and just to have an up-line tool error and leave the table dropped.
This happens both on my desktop(2020.3.5) and on the server. Are these bugs in the pre/post sql process?