Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.snowflake.com/en/sql-reference/sql/drop-integration below:

Website Navigation

• Reference
• SQL command reference
• Integrations

DROP INTEGRATION | Snowflake Documentation

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

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

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4