DROP EXTERNAL CONNECTION

On this page Carat arrow pointing down
Warning:
CockroachDB v22.2 is no longer supported as of June 5, 2024. For more details, refer to the Release Support Policy.
Note:

This feature is in preview. This feature is subject to change. To share feedback and/or issues, contact Support.

New in v22.2: 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