IF NOT EXISTS

Create table option

Description

If any table exists with the same name, the CREATE statement has no effect. Cannot appear with OR REPLACE.

If not exists option is fully supported by Snowflake.

Sample Source

BigQuery (Input Code)

CREATE TABLE IF NOT EXISTS table1 ( 
    col1 integer
);

Snowflake (Output Code)

CREATE TABLE IF NOT EXISTS table1 ( 
    col1 integer
);