OR REPLACE

Create table option

Description

Replaces any table with the same name if it exists. Cannot appear with IF NOT EXISTS.

OR REPLACE option is fully supported by Snowflake.

Sample Source

BigQuery (Input Code)

CREATE OR REPLACE TABLE table1 ( 
    col1 integer
);

Snowflake (Output Code)

CREATE OR REPLACE TABLE table1 ( 
    col1 integer
);