Skip to main content

SHOW CREATE CONNECTION

Introduced or updated: v1.2.965

Shows the CREATE CONNECTION statement for a connection.

Syntax​

SHOW CREATE CONNECTION <connection_name>

Output​

The command returns one row with these columns:

ColumnDescription
ConnectionThe name of the connection.
Create ConnectionThe CREATE CONNECTION statement for the connection.

The command masks credentials such as access_key_id, secret_access_key, and session_token. If the connection has credentials, you cannot use the output statement to create the same connection again. Replace the masked values with the real credentials first. For the list of options that show in plain text, see Masked Values.

Access Control​

You must have the ACCESS CONNECTION privilege on the connection, or own the connection. For more information, see Access Control Privileges.

Examples​

This example creates a connection to an S3-compatible storage service and shows its CREATE CONNECTION statement:

CREATE CONNECTION my_s3_conn
STORAGE_TYPE = 's3'
ACCESS_KEY_ID = 'minioadmin'
SECRET_ACCESS_KEY = 'minioadmin'
ENDPOINT_URL = 'http://127.0.0.1:9900/'
REGION = 'us-east-1';

SHOW CREATE CONNECTION my_s3_conn;

┌────────────┬───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ Connection │ Create Connection │
├────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┤
│ my_s3_conn │ CREATE CONNECTION my_s3_conn STORAGE_TYPE = 's3' access_key_id = 'mi***in' endpoint_url = 'http://127.0.0.1:9900/' region = 'us-east-1' secret_access_key = 'mi***in' │
└────────────┴───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘
Try Databend Cloud for FREE

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.

Sign up and get $200 in credits.

Try it today