On this page
Warning:
GA releases for CockroachDB v23.1 are no longer supported. Cockroach Labs will stop providing LTS Assistance Support for v23.1 LTS releases on November 13, 2025. 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:
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;