Extensions
Legacy Features
> **Deprecated.  ** The `load_aws_credentials` function is deprecated.  
Prior to version 0.10.0, DuckDB did not have a [Secrets manager](#docs:sql:statements:create_secret), to load the credentials automatically, the AWS extension provided
a special function to load the AWS credentials in the [legacy authentication method](#docs:extensions:httpfs:s3api_legacy_authentication).  
| Function | Type | Description |
|---|---|-------|
| `load_aws_credentials` | `PRAGMA` function | Loads the AWS credentials through the [AWS Default Credentials Provider Chain](https://docs.aws.amazon.com/sdk-for-java/latest/developer-guide/credentials-chain.html). |  
#### Load AWS Credentials (Legacy) {#docs:extensions:aws::load-aws-credentials-legacy}  
To load the AWS credentials, run:  
```sql
CALL load_aws_credentials();
```  
<div class="narrow_table monospace_table"></div>  
| loaded_access_key_id | loaded_secret_access_key | loaded_session_token | loaded_region |
|----------------------|--------------------------|----------------------|---------------|
| AKIAIOSFODNN7EXAMPLE | `<redacted>`             | NULL                 | us-east-2     |  
The function takes a string parameter to specify a specific profile:  
```sql
CALL load_aws_credentials('minio-testing-2');
```  
<div class="narrow_table monospace_table"></div>  
| loaded_access_key_id | loaded_secret_access_key | loaded_session_token | loaded_region |
|----------------------|--------------------------|----------------------|---------------|
| minio_duckdb_user_2  | `<redacted>`             | NULL                 | NULL          |  
There are several parameters to tweak the behavior of the call:  
```sql
CALL load_aws_credentials('minio-testing-2', set_region = false, redact_secret = false);
```  
<div class="narrow_table monospace_table"></div>  
| loaded_access_key_id | loaded_secret_access_key     | loaded_session_token | loaded_region |
|----------------------|------------------------------|----------------------|---------------|
| minio_duckdb_user_2  | minio_duckdb_user_password_2 | NULL                 | NULL          |