CREATE INTEGRATION¶

Creates a new integration in the system or replaces an existing integration. An integration is a Snowflake object that provides an interface between Snowflake and third-party services.

See also:: ALTER INTEGRATION, DROP INTEGRATION, SHOW INTEGRATIONS , DESCRIBE INTEGRATION

Syntax¶

CREATE [ OR REPLACE ] <integration_type> INTEGRATION [ IF NOT EXISTS ] <object_name>
  [ <integration_type_params> ]
  [ COMMENT = '<string_literal>' ]

Copy

Where integration_type_params are specific to the integration type.

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

CREATE API INTEGRATION
CREATE EXTERNAL ACCESS INTEGRATION
CREATE NOTIFICATION INTEGRATION
CREATE SECURITY INTEGRATION
CREATE STORAGE INTEGRATION

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.