Skip to content

Add support for requester pays with credential_chain #100

@jterry64

Description

@jterry64

DuckDB recently added support for AWS requester pays. However it only seems to work when specifying credentials using config proivider with key_id/secret:

CREATE OR REPLACE SECRET secret (
    TYPE s3,
    KEY_ID '<key>',
    SECRET '<secret>',
    REGION 'us-east-1',
    REQUESTER_PAYS true
);

But using it with credentials chain gives: duckdb.duckdb.BinderException: Binder Error: Unknown parameter 'requester_pays' for secret type 's3' with provider 'credential_chain

CREATE OR REPLACE SECRET secret (
    TYPE s3,
    PROVIDER credential_chain,
    CHAIN config,
    REQUESTER_PAYS true
);

This is inconvenient for using it in AWS services with task role-based credentials, where there's not an easy way to directly get explicit key_id/secret tokens.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions