Working with tables

Keeping in mind the location of the data and servers, temporary tables are a powerful tool that can work with intermediate result sets. There are a few options for temporary tables. They can be created either with a traditional create statement, with an into statement, or with a create table as (CTAS) syntax. However, do keep in mind that the create table as syntax, regardless of whether it is temporary or permanent, will not carry forward your column-compression encoding. You can use any create table statement syntax that normally applies to tables, and by adding the TEMP or TEMPORARY keyword in the statement, the table will reside in a temporary schema.


Both of these statements will create a table with the same columns ...

Get Getting Started with Amazon Redshift now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.