Iceberg

The IcebergS3 engine provides read-only access to Iceberg tables stored in S3:

IcebergTable.ts

import { OlapTable, ClickHouseEngines, mooseRuntimeEnv } from '@514labs/moose-lib'; // Iceberg table with AWS credentials (recommended with mooseRuntimeEnv)export const icebergEvents = new OlapTable<Event>("iceberg_events", {  engine: ClickHouseEngines.IcebergS3,  path: "s3://my-bucket/warehouse/db/table/",  format: "Parquet", // or "ORC"  awsAccessKeyId: mooseRuntimeEnv.get("AWS_ACCESS_KEY_ID"),  awsSecretAccessKey: mooseRuntimeEnv.get("AWS_SECRET_ACCESS_KEY"),});

IcebergS3 is read-only

IcebergS3 tables are read-only and provide access to the latest state of your Iceberg table
orderByFields, orderByExpression, partitionBy, and are not supported

sampleByExpression