Temporary

Create table option

Description

Temporary tables let you save intermediate results to a table. A table that has been created as a temporary table will only be visible to the current session. For more information please refer to Create a Temporary Table.

Temporary tables are fully supported by Snowflake.

Sample Source

Hive

CREATE TEMPORARY TABLE table1 ( 
    col1 integer
);

Snowflake

CREATE TEMPORARY TABLE table1 ( 
    col1 integer
);

Known Issues

No issues were found.

Related EWIs

No related EWIs.