Forum Discussion

rashmi's avatar
rashmi
New Contributor III
3 years ago

Redshift queries with multiple create and 1 select

Hi All, Is it possible to run multiple create statement first to create multiple temp tables and select statement (redshift query) which has to then fetch columns from those temp tables and need to...
koryknick's avatar
koryknick
Employee
3 years ago

Here is an example pipeline that performs as I described above. It can create the temporary tables, then query from them. Note that you may want to drop the tables as I have done in my example in case they are still present in your session due to connection pooling.

Redshift script execute_2023_03_20.slp (8.8 KB)

I hope this helps!

Related Content