Support
Search Shortcut cmd + k | ctrl + k
Search cmd+k ctrl+k
0.10 (stable)
AWS Extension

The aws extension adds functionality (e.g., authentication) on top of the httpfs extension’s S3 capabilities, using the AWS SDK.

Installing and Loading

To install and load the aws extension, run:

INSTALL aws;
LOAD aws;

Features

Function Type Description
load_aws_credentials PRAGMA function Automatically loads the AWS credentials through the AWS Default Credentials Provider Chain

Usage

Load AWS Credentials

To load the AWS credentials, run:

CALL load_aws_credentials();
loaded_access_key_id loaded_secret_access_key loaded_session_token loaded_region
AKIAIOSFODNN7EXAMPLE NULL us-east-2

The function takes a string parameter to specify a specific profile:

CALL load_aws_credentials('minio-testing-2');
loaded_access_key_id loaded_secret_access_key loaded_session_token loaded_region
minio_duckdb_user_2 NULL NULL

There are several parameters to tweak the behavior of the call:

CALL load_aws_credentials('minio-testing-2', set_region = false, redact_secret = false);
loaded_access_key_id loaded_secret_access_key loaded_session_token loaded_region
minio_duckdb_user_2 minio_duckdb_user_password_2 NULL NULL

aws depends on httpfs extension capablities, and both will be autoloaded on the first call to load_aws_credentials. If autoinstall or autoload are disabled, you can always explicitly install and load them as follows:

INSTALL aws;
INSTALL httpfs;
LOAD aws;
LOAD httpfs;

Usage

See the httpfs extension’s S3 capabilities for instructions.

About this page

Last modified: 2024-04-25