I have a simple query the returns 7k records and is queried against the local storage. I’ve created an automation that would run this query and store it to a new table in local storage (I’ve also tried as snapshot). The query executes fine on its own and in automation. I have tested this by creating a CSV export before the “Execute Script” step that stores the output to a new table on local storage. Everything runs fine until the log shows “Start saving to Local Storage” when this begins it never completes. I let this run for over an hour (the csv export is done in 6 minutes). When I try to cancel at this point Toad Data Point freezes and I am forced to kill the process.
Any help or insight would be greatly appreciated.