DROP CATALOG INTEGRATION¶
Removes a catalog integration from the account.
DROP CATALOG INTEGRATION [ IF EXISTS ] <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,
Access control requirements¶
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.
Dropped catalog integrations cannot be recovered; they must be recreated.
Drop a catalog integration:
DROP CATALOG INTEGRATION myInt;
Drop the catalog integration again, but don’t raise an error if the integration doesn’t exist:
DROP CATALOG INTEGRATION IF EXISTS myInt;