TEMP/TEMPORARY

Create table option

Description

Temporary tables let you save intermediate results to a table. These temporary tables exist at the session level, so you don't need to save or maintain them in a dataset. For more information please refer to Create a temporary table.

Temporary tables are fully supported by Snowflake.

Sample Source

BigQuery (Input Code)

CREATE TEMP TABLE table1 ( 
    col1 integer
);

CREATE TEMPORARY TABLE table2 ( 
    col1 integer
);

Snowflake (Output Code)

CREATE TEMP TABLE table1 ( 
    col1 integer
);

CREATE TEMPORARY TABLE table2 ( 
    col1 integer
);