For more information about secrets, refer to Section 14.5.
duckdb.create_simple_secret(type TEXT, key_id TEXT, secret TEXT, region TEXT, optional_parameters) returns void
#Creates a simple secret for accessing cloud storage services, such as S3, GCS, or R2.
Example 21.38.
-- Create an S3 secret
SELECT duckdb.create_simple_secret(
type := 'S3',
key_id := 'your_access_key',
secret := 'your_secret_key',
region := 'us-east-1'
);
-- Create an S3 secret with session token
SELECT duckdb.create_simple_secret(
type := 'S3',
key_id := 'your_access_key',
secret := 'your_secret_key',
region := 'us-east-1',
session_token := 'your_session_token'
);
Required parameters:
|
Name |
Type |
Description |
|---|---|---|
|
|
|
The type of secret (e.g., |
|
|
|
The access key ID or equivalent |
|
|
|
The secret key or equivalent |
Optional parameters:
|
Name |
Type |
Description |
|---|---|---|
|
|
|
Session token for temporary credentials |
|
|
|
Custom endpoint URL |
|
|
|
URL style. Possible values:
|
use_ssl
|
text
|
Specifies whether to use SSL. Possible values:
Default value: true. |
|
|
|
Scope for the secret. Default value: '' |
|
|
|
The region for the service |