Forum Discussion
koryknick
3 years agoEmployee
I have not tested with Redshift, but I know it works for other databases. You could try to use a Redshift account with Auto Commit disabled and pass the statements into a Redshift Execute snap one at a time. You will need a Router or Filter after the Execute to ignore the “success” records from the Create Table commands vs. the Select output.
If that doesn’t work, can you use CTE (with clause) to sub-query your data rather than build temporary tables?