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.

  • Disabling or dropping the integrations may not take effect immediately, since integrations may be cached. It is recommended to remove the integration privilege from the cloud provider to take effect sooner.

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