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:

Required privileges

Users must have the or be a member of the 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;

See also