1. MooseStack
  3. Engines
  5. Iceberg S3

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 sampleByExpression are not supported
  • The table automatically reflects the current state of the Iceberg table in S3
  • Supported formats: Parquet and ORC only

See Also

  • ClickHouse Iceberg Engine — ClickHouse official documentation

On this page

See Also
FiveonefourFiveonefour
Fiveonefour Docs
MooseStackTemplatesGuides
Release Notes
Source523
  • Overview
Build a New App
  • 5 Minute Quickstart
  • Browse Templates
  • Existing ClickHouse
Add to Existing App
  • Next.js
  • Fastify
Fundamentals
  • Moose Runtime
  • MooseDev MCP
  • Data Modeling
Moose Modules
  • Moose OLAP
  • Moose Streaming
  • Moose Workflows
  • Moose APIs & Web Apps
Deployment & Lifecycle
  • Moose Migrate
  • Moose Deploy
Reference
  • API Reference
  • Data Types
  • Table Engines
  • CLI
  • Configuration
  • Observability Metrics
  • Help
  • Release Notes
Contribution
  • Documentation
  • Framework
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"),});