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

The iceberg extension supports reading Iceberg tables through the Amazon SageMaker Lakehouse (a.k.a. AWS Glue) catalog. Make sure you have the Iceberg extension installed by following the steps at Installing and Loading

Connecting to Amazon SageMaker Lakehouse

Configure your role, region, and credential provider (or explicit credentials) 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'
);

Then, connect to the catalog using the ENDPOINT_TYPE glue option:

ATTACH 'account_id:s3tablescatalog/namespace_name' 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