Github-Mirror/seaweedfs
1
0 Fork 0
mirror of https://github.com/seaweedfs/seaweedfs.git synced 2026-10-21 05:24:28 +02:00
Code Issues Packages Projects Releases Wiki Activity
Page: OLake Go Iceberg Integration
Pages
A typical step‐by‐step example AWS CLI with SeaweedFS AWS IAM CLI Actual Users Admin UI OIDC Admin UI Amazon IAM API Amazon S3 API Applications Async Backup Async Filer Metadata Backup Async Replication to Cloud Async Replication to another Filer Azure Blob Storage Authentication Benchmark SeaweedFS as a GlusterFS replacement Benchmarks from jinleileiking Benchmarks Blob Store Architecture Cache Remote Storage Choosing a Filer Store Client Libraries Cloud Drive Architecture Cloud Drive Benefits Cloud Drive Quick Setup Cloud Monitoring Cloud Tier Cluster Plan Day 2 Operations Cluster Plan Inventory Reference Cluster Plan Workflow Components Configure Remote Storage Cryptography and FIPS Compliance Customize Filer Store Data Backup Data Structure for Large Files Deployment to Kubernetes and Minikube Deployment with seaweed up Directories and Files Distributed POSIX Locks Distributing AI Model Files for Multi GPU Loading Docker Compose for S3 Docker Image Registry with SeaweedFS Doris Iceberg Integration Dremio Iceberg Integration DuckDB Iceberg Integration DuckDB Lance Integration EC Bitrot Detection Environment Variables Erasure Coding for warm storage Error reporting to sentry FAQ FIO benchmark FUSE Mount Failover Master Server File Operations Quick Reference Filer Active Active cross cluster continuous synchronization Filer Cassandra Setup Filer Change Data Capture Filer Commands and Operations Filer Data Encryption Filer JWT Use Filer Metadata Events Filer Notification Webhook Filer Operation Serialization Filer Redis Setup Filer Server API Filer Setup Filer Store Replication Filer Stores Filer as a Key Large Value Store Gateway to Remote Object Storage Getting Started HDFS via S3 connector Hadoop Benchmark Hadoop Compatible File System Hardware Helm Chart Recipes Hobbyest Tinkerer scale on premises tutorial Home Iceberg REST Catalog API Iceberg Table Maintenance Image Gateway Independent Benchmarks Kafka to Kafka Gateway to SMQ to SQL Kubernetes Backups and Recovery with K8up Kubernetes ServiceAccount Authentication Lakekeeper Iceberg Integration Lance Maintenance Worker LanceDB Integration Large File Handling Load Command Line Options from a file Master Server API Migrate Maintenance Scripts to Admin Script Plugin Migrate to Filer Store Mount Remote Storage Mount on Windows Mount over the Internet OIDC Integration OLake Go Iceberg Integration Optimization for Many Small Buckets Optimization P2P reading in weed mount POSIX Compliance Path Specific Configuration Path Specific Filer Store Plugin Worker Scheduling PostgreSQL compatible Server weed db Production Setup Pub Sub to SMQ to SQL Quick Start with weed mini Replication RisingWave Iceberg Integration Run Blob Storage on Public Internet Run Trino on SeaweedFS Rust Volume Server S3 API Audit log S3 API Benchmark S3 API FAQ S3 Bucket Policies S3 Bucket Quota S3 CORS S3 Conditional Operations S3 Configuration S3 Credentials S3 Lifecycle Architecture S3 Lifecycle Monitoring S3 Lifecycle Operator Guide S3 Lifecycle Recipes S3 Lifecycle Troubleshooting S3 Lifecycle vs Volume TTL S3 Lifecycle S3 Nginx Proxy S3 Object Lock and Retention S3 Object Versioning S3 Policy Conditions S3 Policy Variables S3 Rate Limiting S3 RenameObject S3 Table Bucket Commands S3 Table Bucket S3 Tables Security SFTP Server SQL Queries on Message Queue SQL Quick Reference SRV Service Discovery Seaweed Message Queue SeaweedFS Architecture SeaweedFS Iceberg Catalog SeaweedFS Java Client SeaweedFS Lance Catalog SeaweedFS in Docker Swarm Security Configuration Security Overview Server Side Encryption SSE C Server Side Encryption SSE KMS Server Side Encryption Server Startup via Systemd Simplest S3 Bucket and User Setup Spark Iceberg Integration Spark Lance Integration Store file with a Time To Live Structured Data Lake with SMQ and SQL Super Large Directories Supported APIs vs Minio System Metrics TUS Resumable Uploads TensorFlow with SeaweedFS Tiered Storage Trino Iceberg Integration UrBackup with SeaweedFS Use Cases Volume Files Structure Volume Management Volume Server API WebDAV Words from SeaweedFS Users Worker fstab and systemd mount nodejs with Seaweed S3 rclone with SeaweedFS restic with SeaweedFS run HBase on SeaweedFS run Spark on SeaweedFS s3cmd with SeaweedFS seaweed up Command Reference weed shell
Clone
1
OLake Go Iceberg Integration
GAURI edited this page 2026-10-20 16:19:40 +05:30
Table of Contents

OLake Go Iceberg Integration

OLake Go syncs data from supported sources to Iceberg destinations. This example uses PostgreSQL as the source and SeaweedFS as the Iceberg REST catalog and S3-compatible storage.

Prerequisites

  • OLake Go v0.12.3

Source and Destination Setup

OLake Go provides source-specific drivers and configurations for multiple connectors, including PostgreSQL, MongoDB, MySQL, Oracle, Kafka, DB2, S3, and Microsoft SQL Server (MSSQL). This walkthrough uses PostgreSQL.

Start SeaweedFS

docker volume create seaweed-data

docker run -d --name seaweedfs \
  -e AWS_ACCESS_KEY_ID=admin -e AWS_SECRET_ACCESS_KEY=password \
  -p 8333:8333 -p 8181:8181 -p 9333:9333 \
  -v seaweed-data:/data \
  chrislusf/seaweedfs:latest \
  mini -dir=/data -tableBucket=warehouse

PostgreSQL Source

To try a local setup, start the PostgreSQL source with CDC enabled. Download it with:

curl -fsSL https://raw.githubusercontent.com/datazip-inc/olake-docs/master/docs/community/docker-compose.yml \
  -o docker-compose.source.yml

To start the sample PostgreSQL database:

docker compose -f docker-compose.source.yml --profile postgres up -d

Once all the services are up, quickly check the sample data by running the below query:

docker exec -it primary_postgres psql -U main -d main -c "SELECT * FROM public.sample_data;"

Configure the PostgreSQL source in source.json:

{
  "host": "localhost",
  "port": 5431,
  "database": "main",
  "username": "main",
  "password": "password",
  "jdbc_url_params": {},
  "ssl": {
    "mode": "disable"
  },
  "update_method": {
    "replication_slot": "postgres_slot",
    "publication": "olake_publication",
    "initial_wait_time": 120
  },
  "reader_batch_size": 1000,
  "max_threads": 10
}

Iceberg Destination

Configure SeaweedFS as the Iceberg destination in destination.json:

{
  "type": "ICEBERG",
  "writer": {
    "catalog_type": "seaweedfs",
    "rest_catalog_url": "http://localhost:8181",
    "rest_auth_type": "OAuth2",
    "credential": "admin:password",
    "oauth2_uri": "http://localhost:8181/v1/oauth/tokens",
    "s3_endpoint": "http://localhost:8333",
    "iceberg_s3_path": "s3://warehouse",
    "aws_access_key": "admin",
    "aws_secret_key": "password",
    "aws_region": "us-east-1",
    "iceberg_db": "olake_iceberg",
    "catalog_name": "olake_iceberg"
  }
}

Sync PostgreSQL to Iceberg

Run these commands from the directory containing the PostgreSQL driver executable and the JSON configuration files. Discover the available PostgreSQL streams:

./build.sh driver-postgres discover --config $(pwd)/source.json

Discovery creates streams.json. Set the selected stream's sync_mode to the value for the strategy you want:

Sync mode What it does
full_refresh Copies the selected table's current contents on each run.
cdc Performs an initial full load, then captures inserts, updates, and deletes using CDC.
incremental Performs an initial full load, then reads new or changed rows using a cursor. It does not detect deletes.

Run the sync command:

./build.sh driver-postgres sync --config $(pwd)/source.json --catalog $(pwd)/streams.json --destination $(pwd)/destination.json

After the full refresh, run the next sync with state flag added to only capture the changes in source:

./build.sh driver-postgres sync --config $(pwd)/source.json --catalog $(pwd)/streams.json --destination $(pwd)/destination.json --state $(pwd)/state.json

See also

For more about OLake Go's sources, sync strategies, and Iceberg ingestion options, explore the OLake documentation.

Introduction

API

Configuration

Filer

Filer Stores

Management

Advanced Filer Configurations

FUSE Mount

WebDAV

SFTP Server

Cloud Drive

AWS S3 API

S3 Table Bucket

Iceberg Integrations

Lance Integrations

S3 Authentication & IAM

Server-Side Encryption

S3 Client Tools

Machine Learning

HDFS

Replication and Backup

Metadata Change Events

Messaging

Use Cases

Operations

Rust Volume Server

Advanced

Security

Misc Use Case Examples