DROP EXTERNAL CONNECTION

On this page Carat arrow pointing down
Warning:
Cockroach Labs will stop providing Assistance Support for v23.1 on November 15, 2024. Prior to that date, upgrade to a more recent version to continue receiving support. For more details, refer to the Release Support Policy.

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 DROP privilege or be a member of the admin role to drop an external connection.

For example:

icon/buttons/copy
GRANT DROP ON EXTERNAL CONNECTION backup_bucket TO user;

Synopsis

DROP EXTERNAL CONNECTION connection_name

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:

icon/buttons/copy
DROP EXTERNAL CONNECTION backup_storage;

See also


Yes No
On this page

Yes No