⌘+k ctrl+k
1.4 (stable)
Search Shortcut cmd + k | ctrl + k
Amazon SageMaker Lakehouse (AWS Glue)

Support for Amazon SageMaker Lakehouse (AWS Glue) is currently experimental.

The iceberg extension supports reading Iceberg tables through the Amazon SageMaker Lakehouse (a.k.a. AWS Glue) catalog.

Requirements

To use it, install the following extensions:

INSTALL aws;
INSTALL httpfs;
INSTALL iceberg;

If you want to switch back to using extensions from the core repository, follow the extension documentation.

Connecting to Amazon SageMaker Lakehouse (AWS Glue)

Create an S3 secret using the Secrets Manager:

CREATE SECRET (
    TYPE s3,
    PROVIDER credential_chain,
    CHAIN sts,
    ASSUME_ROLE_ARN 'arn:aws:iam::account_id:role/role',
    REGION 'us-east-2'
);

In this example we use an STS token, but other authentication methods are supported.

Then, connect to the catalog:

ATTACH 'account_id' AS glue_catalog (
    TYPE iceberg,
    ENDPOINT 'glue.REGION.amazonaws.com/iceberg'
    AUTHORIZATION_TYPE 'sigv4'
);

Or alternatively:

ATTACH 'account_id' AS glue_catalog (
    TYPE iceberg,
    ENDPOINT_TYPE 'glue'
);

To check whether the attachment worked, list all tables:

SHOW ALL TABLES;

You can query a table as follows:

SELECT count(*)
FROM glue_catalog.namespace_name.table_name;
About this page
© 2025 DuckDB Foundation, Amsterdam NL
Code of Conduct Trademark Use