S3)Use the S3 engine for direct read/write access to S3 storage without streaming semantics:
import { OlapTable, ClickHouseEngines, mooseRuntimeEnv } from '@514labs/moose-lib'; // S3 table with credentials (recommended with mooseRuntimeEnv)export const s3Data = new OlapTable<DataRecord>("s3_data", { engine: ClickHouseEngines.S3, path: "s3://my-bucket/data/file.json", format: "JSONEachRow", awsAccessKeyId: mooseRuntimeEnv.get("AWS_ACCESS_KEY_ID"), awsSecretAccessKey: mooseRuntimeEnv.get("AWS_SECRET_ACCESS_KEY"), compression: "gzip"}); // Public S3 bucket (no authentication)export const publicS3 = new OlapTable<DataRecord>("public_s3", { engine: ClickHouseEngines.S3, path: "s3://public-bucket/data/*.parquet", format: "Parquet", noSign: true // Use NOSIGN for public buckets});Both engines support the same credential management and format options.