DROP INTEGRATION

Removes an integration from the account.

See also:

CREATE INTEGRATION , ALTER INTEGRATION , SHOW INTEGRATIONS , DESCRIBE INTEGRATION

API integrations

CREATE API INTEGRATION

catalog integrations

CREATE CATALOG INTEGRATION

External access integrations

CREATE EXTERNAL ACCESS INTEGRATION

Notification integrations

CREATE NOTIFICATION INTEGRATION

Security integrations

CREATE SECURITY INTEGRATION

Storage integrations

CREATE STORAGE INTEGRATION

Syntax

DROP [ { API | CATALOG | EXTERNAL ACCESS | NOTIFICATION | SECURITY | STORAGE } ] INTEGRATION [ IF EXISTS ] <name>
Copy

Parameters

name

Specifies the identifier for the integration to drop. If the identifier contains spaces, special characters, or mixed-case characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive (e.g. "My Object").

API | CATALOG | EXTERNAL ACCESS | NOTIFICATION | SECURITY | STORAGE

Specifies the integration type.

Usage Notes

  • Dropped integrations cannot be recovered; they must be recreated.

Examples

Drop an integration:

SHOW INTEGRATIONS LIKE 't2%';

DROP INTEGRATION t2;

SHOW INTEGRATIONS LIKE 't2%';
Copy

Drop the integration again, but don’t raise an error if the integration does not exist:

DROP INTEGRATION IF EXISTS t2;
Copy