Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.streamnative.io/llms.txt

Use this file to discover all available pages before exploring further.

This guide describes how to prepare an AWS S3Table catalog for use with StreamNative Ursa as an Iceberg catalog.
Important: The StreamNative Ursa cluster must run in the same region as the S3Table bucket. Cross-region access is not supported and will fail with an AWS client error.

​
Prerequisites

  • An AWS account with permissions to create S3Table buckets and modify IAM roles
  • A StreamNative Ursa cluster (the cluster’s IAM role will be granted access to the S3Table bucket)

​
1. Create an S3Table Bucket

In the AWS S3 console, create an S3Table bucket in the same region as the Ursa cluster. Record the bucket ARN, which has the form: 
arn:aws:s3tables:<region>:<account-id>:bucket/<bucket-name>

​
2. Grant S3Table Permissions via a Table Bucket Policy

Apply a table bucket policy on the S3Table bucket so that the StreamNative Ursa cluster’s IAM role can read and write tables in the bucket.

​
2.1 Find the StreamNative cluster role ARN

The role ARN to grant access to is the IAM role bound to the broker pods of the StreamNative cluster. When you enable Lakehouse Table for Amazon S3 Tables at the cluster, namespace, or topic level in the StreamNative Cloud Console, the dialog displays the exact IAM role ARN that needs access to your S3Table bucket. Copy that ARN. For details on enabling S3 Tables, see Enable Lakehouse Table.

​
2.2 Apply the table bucket policy

In the AWS S3 console, open your S3Table bucket and go to the Permissions tab. Choose Edit under Table bucket policy and paste the following JSON, replacing <streamnative-cluster-role-arn> with the ARN you copied in the previous step and <your-region>, <your-aws-account>, and <your-bucket-name> with the values for your bucket. 
{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Sid": "S3ListTableBucket",
      "Effect": "Allow",
      "Principal": {
        "AWS": "<streamnative-cluster-role-arn>"
      },
      "Action": [
        "s3tables:ListTableBuckets"
      ],
      "Resource": ["*"]
    },
    {
      "Sid": "DataAccessPermissionsForS3TableBucket",
      "Effect": "Allow",
      "Principal": {
        "AWS": "<streamnative-cluster-role-arn>"
      },
      "Action": [
        "s3tables:GetTableBucket",
        "s3tables:CreateNamespace",
        "s3tables:GetNamespace",
        "s3tables:ListNamespaces",
        "s3tables:CreateTable",
        "s3tables:GetTable",
        "s3tables:ListTables",
        "s3tables:UpdateTableMetadataLocation",
        "s3tables:GetTableMetadataLocation",
        "s3tables:GetTableData",
        "s3tables:PutTableData"
      ],
      "Resource": [
        "arn:aws:s3tables:<your-region>:<your-aws-account>:bucket/<your-bucket-name>",
        "arn:aws:s3tables:<your-region>:<your-aws-account>:bucket/<your-bucket-name>/*"
      ]
    }
  ]
}
The policy panel is on the Permissions tab of the table bucket, as shown below: Set the S3 Table bucket policy Configuration example Configuration example IAM permissions example By default, S3 Tables retains snapshots for 120 hours (5 days). For production workloads, StreamNative recommends shortening this window to 6 hours.
SettingDefaultRecommended
MaximumSnapshotAge120 hours (5 days)6 hours
Why this matters. S3 Tables enforces a fixed 5 MB cap on the Iceberg metadata file size. Long retention windows cause many unexpired snapshots to accumulate in the metadata file. When the metadata file grows beyond 5 MB, subsequent snapshot commits will fail, which stops new data from being written into the lakehouse table. A shorter MaximumSnapshotAge keeps the metadata file under the cap. You can update the snapshot management settings from the S3 Table bucket console or via the AWS CLI after the bucket is created. See S3 Tables maintenance — Snapshot management for the full list of maintenance settings.

​
4. (Optional) Configure AWS Athena Access

If you intend to query the S3Table data via AWS Athena, you must integrate it with AWS Lake Formation.

​
4.1 Prerequisites

Refer to S3 Tables integration prerequisites. In summary:
  • Attach AWSLakeFormationDataAdmin to your IAM principal
  • Add glue:PassConnection and lakeformation:RegisterResource permissions
  • Use the latest version of the AWS CLI
When the S3Table bucket is created with AWS analytics services enabled, AWS automatically provisions a role (for example, S3TablesRoleForLakeFormation_1). S3Tables role Add the following inline policy to your IAM principal to grant Lake Formation operations: 
{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Sid": "AWSLakeFormationDataAdminAllow",
      "Effect": "Allow",
      "Action": [
        "lakeformation:*",
        "cloudtrail:DescribeTrails",
        "cloudtrail:LookupEvents",
        "glue:CreateCatalog", "glue:UpdateCatalog", "glue:DeleteCatalog",
        "glue:GetCatalog", "glue:GetCatalogs",
        "glue:GetDatabase", "glue:GetDatabases",
        "glue:CreateDatabase", "glue:UpdateDatabase", "glue:DeleteDatabase",
        "glue:GetConnections", "glue:SearchTables",
        "glue:GetTable", "glue:CreateTable", "glue:UpdateTable", "glue:DeleteTable",
        "glue:GetTableVersions", "glue:GetPartitions", "glue:GetTables",
        "glue:ListWorkflows", "glue:BatchGetWorkflows", "glue:DeleteWorkflow",
        "glue:GetWorkflowRuns", "glue:StartWorkflowRun", "glue:GetWorkflow",
        "glue:PassConnection",
        "s3:ListBucket", "s3:GetBucketLocation", "s3:ListAllMyBuckets", "s3:GetBucketAcl",
        "iam:ListUsers", "iam:ListRoles", "iam:GetRole", "iam:GetRolePolicy"
      ],
      "Resource": "*"
    },
    {
      "Sid": "AWSLakeFormationDataAdminDeny",
      "Effect": "Deny",
      "Action": ["lakeformation:PutDataLakeSettings"],
      "Resource": "*"
    }
  ]
}
A resource link provides a Glue Data Catalog reference to your S3Table namespace. See Creating a resource link. 
aws glue create-database --region <region> --catalog-id "<account-id>" --database-input '{
  "Name": "<resource-link-name>",
  "TargetDatabase": {
    "CatalogId": "<account-id>:s3tablescatalog/<table-bucket-name>",
    "DatabaseName": "<namespace>"
  },
  "CreateTableDefaultPermissions": []
}'

​
4.3 Grant Lake Formation Permissions

​
On the Table

In the AWS Lake Formation console, navigate to Data permissions -> Grant and configure:
  1. Principals: the IAM user, role, or SAML group that will run queries.
  2. LF-Tags or catalog resources: choose Named Data Catalog resources.
  3. Catalogs: the Glue Data Catalog created when the table bucket was integrated (<account-id>:s3tablescatalog/<table-bucket-name>).
  4. Databases: the S3Table namespace.
  5. Tables: the S3Table table.
  6. Table permissions: Super.
Grant table permission Grant table permission Resource links require their own grants in addition to the underlying namespace/table grants:
  1. Principals: the IAM user/role/group.
  2. Catalogs: your account’s default catalog.
  3. Databases: the resource link from step 4.2.
  4. Resource link permissions: Describe.
Grant resource link permission

​
Catalog Information Summary

When the steps above are complete, collect the following values for the StreamNative Ursa compaction service:
ValueDescription
iceberg.catalog-backends3table
iceberg.urihttps://s3tables.<region>.amazonaws.com/iceberg (region-specific endpoint — see the S3 Tables regions list)
iceberg.warehouseThe S3Table bucket ARN: arn:aws:s3tables:<region>:<account>:bucket/<bucket-name>
iceberg.rest.signing-regionThe region of the S3Table bucket
Athena query For the next steps, see Configure Lakehouse Catalogs.