DROP CATALOG INTEGRATION

Removes a catalog integration from the account.

See also:

CREATE CATALOG INTEGRATION , SHOW CATALOG INTEGRATIONS , DESCRIBE CATALOG INTEGRATION

Syntax

DROP CATALOG INTEGRATION [ IF EXISTS ] <name>
Copy

Parameters

name

Specifies the identifier for the catalog 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 (for example, "My Catalog").

Access control requirements

A role used to execute this SQL command must have the following privileges at a minimum:

Privilege

Object

Notes

OWNERSHIP

Integration (catalog)

OWNERSHIP is a special privilege on an object that is automatically granted to the role that created the object, but can also be transferred using the GRANT OWNERSHIP command to a different role by the owning role (or any role with the MANAGE GRANTS privilege).

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

Usage notes

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

Examples

Drop a catalog integration:

DROP CATALOG INTEGRATION myInt;
Copy

Drop the catalog integration again, but don’t raise an error if the integration doesn’t exist:

DROP CATALOG INTEGRATION IF EXISTS myInt;
Copy