Create Temp Tables in Redshift
Is there a way to create temp tables in Redshift using standard components like the RDS Query component?
In Redshift, temp tables (tables created with CREATE TEMPORARY...) can be written to more quickly because it doesn't mirror blocks as it's writing them, so write performance can be twice as fast.
When I'm staging data that I know I'm going to dump after finishing my ELT, I'd love to be able to put that data into temporary tables to get that bit of performance gain.
But, other than creating the tables manually, I don't see a way in Matillion to specify in components that I want the destination table to be a temporary table.