> ## Documentation Index
> Fetch the complete documentation index at: https://cockroachlabs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
# SHOW CREATE EXTERNAL CONNECTION
export const InternalLink = ({version, path = "", children, ...props}) => {
let detectedVersion = version || "stable";
if (typeof window !== 'undefined' && !version) {
const match = window.location.pathname.match(/\/docs\/([^/]+)/);
if (match) {
detectedVersion = match[1];
}
}
const normalizedPath = path.startsWith("/") ? path.slice(1) : path;
return
{children}
;
};
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. `SHOW CREATE EXTERNAL CONNECTION` displays the connection name and the creation statements for active external connections.
You can also use the following SQL statements to work with external connections:
* `CREATE EXTERNAL CONNECTION`
* `SHOW EXTERNAL CONNECTION`
* `DROP EXTERNAL CONNECTION`
## Required privileges
Without the `admin` role, users can only view the external connections that they own. Users own external connections that they have created with `CREATE EXTERNAL CONNECTION`.
Users with the `admin` role can view all external connections with `SHOW CREATE EXTERNAL CONNECTION`.
## Synopsis
### Parameters
| Parameter | Description |
| ------------------ | -------------------------------------------------------------------- |
| `connection\_name` | The name of the external connection to pass in operation statements. |
## Examples
### Show all external connection create statements
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
SHOW CREATE ALL EXTERNAL CONNECTIONS;
```
This will return a list of of active external connection names along with the `CREATE EXTERNAL CONNECTION` statements that were used to create them, including the **unredacted** URI:
```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
connection_name | create_statement
------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
backup_bucket_1 | CREATE EXTERNAL CONNECTION 'backup_bucket' AS 's3://bucket_name?AWS_ACCESS_KEY_ID={access key}&AWS_SECRET_ACCESS_KEY={secret access key}'
backup_bucket_2 | CREATE EXTERNAL CONNECTION 'backup_bucket_2' AS 's3://bucket_name?AWS_ACCESS_KEY_ID={access key}&AWS_SECRET_ACCESS_KEY={secret access key}'
kafka | CREATE EXTERNAL CONNECTION 'kafka' AS 'kafka://broker.address.com:9092?topic_prefix=bar_&tls_enabled=true&ca_cert={certificate}&sasl_enabled=true&sasl_user={sasl user}&sasl_password={url-encoded password}&sasl_mechanism=SCRAM-SHA-256'
(4 rows)
```
### Show an external connection create statement
To display the `CREATE` statement for a specific external connection, pass the name of the connection similar to the following:
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
SHOW CREATE EXTERNAL CONNECTION backup_bucket_1;
```
```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
connection_name | create_statement
------------------+-------------------------------------------------------------------------------------------------------------------------------------------
backup_bucket_1 | CREATE EXTERNAL CONNECTION 'backup_bucket' AS 's3://bucket_name?AWS_ACCESS_KEY_ID={access key}&AWS_SECRET_ACCESS_KEY={secret access key}'
```
## See also
* Use Cloud Storage
* Changefeed Sinks