Using S3 Table for Startburst Trino

Verify Iceberg Catalog¶

Connect to Starburst Trino and start the Trino CLI (see Run Starburst Trino CLI for detailed connection steps).

1
2
3

-- List all available catalogs
SHOW CATALOGS;
-- Verify iceberg catalog is listed

Create and Access S3 Table¶

Before proceeding, create the required Iceberg catalog policies in the Privacera Portal. Add these policies to the privacera_trino service under Access Management → Resource Policies.

Create Schema¶

1

CREATE SCHEMA IF NOT EXISTS iceberg.test_schema;

Permission Details:

• Trino Catalog: iceberg
• Trino Schema: <SCHEMA_NAME>
• Permissions: CREATE

Create Table¶

1
2
3
4
5

CREATE TABLE iceberg.test_schema.test_table (
    sale_date DATE,
    product_category VARCHAR,
    sales_amount DOUBLE
);

Permission Details:

• Trino Catalog: iceberg
• Trino Schema: <SCHEMA_NAME>
• Trino Table: <TABLE_NAME>
• Permissions: CREATE

Insert Data¶

1
2
3
4

INSERT INTO iceberg.test_schema.test_table
VALUES 
   (DATE '2026-03-04', 'Furniture', 2150.00),
   (DATE '2026-03-05', 'Books', 150.99);

Permission Details:

• Trino Catalog: iceberg
• Trino Schema: <SCHEMA_NAME>
• Trino Table: <TABLE_NAME>
• Permissions: UPDATE

Select/Query Data¶

1

SELECT * FROM iceberg.test_schema.test_table;

Permission Details:

• Trino Catalog: iceberg
• Trino Schema: <SCHEMA_NAME>
• Trino Table: <TABLE_NAME>
• Trino Columns: <COLUMN_NAME>
• Permissions: SELECT