DROP EXTERNAL CONNECTION

You can use external connections to specify and interact with resources that are external from CockroachDB. When creating an external connection, you define a name for an external connection while passing the provider URI and query parameters. The DROP EXTERNAL CONNECTION statement allows you to delete external connections. You can also use the following SQL statements to work with external connections:

CREATE EXTERNAL CONNECTION
SHOW CREATE EXTERNAL CONNECTION

Required privileges

Users must have the DROP privilege or be a member of the admin role to drop an external connection. For example:

GRANT DROP ON EXTERNAL CONNECTION backup_bucket TO user;

Synopsis

Parameters

Parameter	Description
`connection_name`	The name of the external connection to pass in operation statements.

Examples

Drop an external connection

To delete an external connection named backup_storage, run the following:

DROP EXTERNAL CONNECTION backup_storage;

Statements

Syntax

Data Types

Spatial Data

Constraints

DROP EXTERNAL CONNECTION

Required privileges

Synopsis

Parameters

Examples

Drop an external connection

See also

​Required privileges

​Synopsis

​Parameters

​Examples

​Drop an external connection

​See also

Required privileges

Synopsis

Parameters

Examples

Drop an external connection

See also