If Not Exists

Create table option

Description

If any table exists with the same name, the CREATE statement has no effect.

If not exists option is fully supported by Snowflake.

Sample Source

Hive

CREATE TABLE IF NOT EXISTS table1 ( 
    col1 integer
);

Snowflake

CREATE TABLE IF NOT EXISTS table1 ( 
    col1 integer
); 

Known Issues

No issues were found.

Related EWIs

No related EWIs.