CREATE <object>¶

Creates a new object of the specified type.

See also:: ALTER <object> , DESCRIBE <object> , SHOW <objects>

Syntax¶

CREATE [ OR REPLACE ] <object_type> [ IF NOT EXISTS ] <object_name>
  [ <object_type_properties> ]
  [ <object_type_params> ]
  [ COMMENT = '<string_literal>' ]

Copy

Where object_type_properties and object_type_params are specific to the object type.

For specific syntax, usage notes, and examples, see:

Account Objects:

CREATE API INTEGRATION

CREATE APPLICATION

CREATE APPLICATION PACKAGE

CREATE CATALOG INTEGRATION

CREATE CONNECTION

CREATE DATABASE , CREATE DATABASE … CLONE

CREATE DATABASE ROLE

CREATE EXTERNAL ACCESS INTEGRATION

CREATE EXTERNAL VOLUME

CREATE NETWORK POLICY

CREATE NOTIFICATION INTEGRATION

CREATE RESOURCE MONITOR

CREATE ROLE

CREATE SECURITY INTEGRATION

CREATE SHARE

CREATE STORAGE INTEGRATION

CREATE USER

CREATE WAREHOUSE

Database Objects:

CREATE ALERT

CREATE DYNAMIC TABLE

CREATE EVENT TABLE

CREATE EXTERNAL FUNCTION

CREATE EXTERNAL TABLE

CREATE FILE FORMAT , CREATE FILE FORMAT … CLONE

CREATE FUNCTION

CREATE ICEBERG TABLE

CREATE MASKING POLICY

CREATE MATERIALIZED VIEW

CREATE NETWORK RULE

CREATE PACKAGES POLICY

CREATE PASSWORD POLICY

CREATE PIPE

CREATE PROCEDURE

CREATE ROW ACCESS POLICY

CREATE SCHEMA , CREATE SCHEMA … CLONE

CREATE SECRET

CREATE SEQUENCE , CREATE SEQUENCE … CLONE

CREATE SESSION POLICY

CREATE STAGE , CREATE STAGE … CLONE

CREATE STREAM , CREATE STREAM … CLONE

CREATE STREAMLIT,

CREATE TABLE , CREATE TABLE … CLONE

CREATE TAG

CREATE TASK , CREATE TASK … CLONE

CREATE VIEW

Classes:

CREATE SNOWFLAKE.CORE.BUDGET

CREATE SNOWFLAKE.ML.ANOMALY_DETECTION

CREATE SNOWFLAKE.ML.FORECAST

General Usage Notes¶

OR REPLACE and IF NOT EXISTS clauses are mutually exclusive; they cannot both be used in the same statement.
CREATE OR REPLACE <object> statements are atomic. That is, when an object is replaced, the old object is deleted and the new object is created in a single transaction.