DROP INTEGRATION¶

Removes an integration from the account.

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

Syntax¶

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

Copy

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.

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.

When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.

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