- User & Security DDL (Third-Party Service Integrations)
Removes an integration from the current/specified schema.
- See also:
- SHOW INTEGRATIONS
|CREATE SECURITY INTEGRATION|
DROP [ SECURITY ] INTEGRATION [ IF EXISTS ] <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.
If the integration identifier is not fully-qualified (in the form of
schema_name.integration_name), the command looks for the integration in the current schema for the session.
- Specifies the integration type.
- Dropped integrations cannot be recovered; they must be recreated.
Drop an integration:
SHOW INTEGRATIONS LIKE 't2%'; DROP INTEGRATION t2; SHOW INTEGRATIONS LIKE 't2%';
Drop the integration again, but don’t raise an error if the integration does not exist:
DROP INTEGRATION IF EXISTS t2;