Storage Connection

A Storage Connection stores authentication credentials for object storage services, enabling External Volumes and External Tables to securely access cloud storage.

Use Cases

When creating an External Volume or external table, you need to first create a Storage Connection to configure cloud storage access keys, avoiding exposing credentials in plaintext within SQL.

External Volume / External Table └── Storage Connection (stores access credentials) └── OSS / COS / S3

Creation Examples

-- Alibaba Cloud OSS CREATE STORAGE CONNECTION my_oss_conn TYPE OSS access_id = 'LTAIxxxxxxxxxxxx' access_key = 'T8Gexxxxxxxx' ENDPOINT = 'oss-cn-hangzhou-internal.aliyuncs.com'; -- Tencent Cloud COS CREATE STORAGE CONNECTION my_cos_conn TYPE COS ACCESS_KEY = '<access_key>' SECRET_KEY = '<secret_key>' REGION = 'ap-shanghai' APP_ID = '1310000503'; -- Amazon S3 CREATE STORAGE CONNECTION my_s3_conn TYPE S3 ACCESS_KEY = '<access_key>' SECRET_KEY = '<secret_key>' REGION = 'us-east-1';

Related Documentation

• CREATE STORAGE CONNECTION — Full syntax
• External Volume — Mount object storage using a Storage Connection
• Connection Overview