LAKEWRIGHT Start a conversation

We read the data nobody else can, and land it governed.

Claims files, HL7 feeds, mainframe extracts, scanned documents, database change streams — identified, classified, and written to Apache Iceberg tables inside your own environment. An AI proposes the plan. A person approves it. Nothing leaves the building.

X12 · EDIHL7 · FHIRDICOMNACHA · BAI2 fixed-widthPDF · OCRPostgres · MySQL · SQL Server · Oracle CDCParquet · Avro
Selected work

What it looks like in practice.

Each of these is a pattern we have built and run end to end.

Convert BAI2 bank balance files to Iceberg tables Snowflake can query Finance · Treasury BAI2 balance-reporting files from your banks become typed Iceberg tables — account balances and transaction detail with typed amounts — queryable from Snowflake without hand-written parsers. Canvas Medical analytics: getting your EHI into Snowflake, governed Healthcare · EHR Canvas Medical has quietly become the system of record for a generation of digital-health companies, and it earned the position honestly: it is the rare EHR that developers choose rather… Load HL7 v2 messages into Apache Iceberg for Databricks analytics Healthcare · Clinical HL7 v2 feeds (ADT, ORU, DFT) become queryable Iceberg tables that Databricks reads through Unity Catalog — one row per message, PHI flagged and masked before landing, no interface engine… Load mainframe fixed-width files into Apache Iceberg Legacy · Mainframe Fixed-width mainframe extracts — no headers, no delimiters — become typed Iceberg tables. Convert NACHA ACH files to queryable Apache Iceberg tables Finance · Payments NACHA ACH files — 94-character fixed-width bank records — become typed, queryable Iceberg tables with one scan-approve-load pass. Inventory a corporate file share (SMB/NFS) into Apache Iceberg Assessment · Shares A departmental file server — years of Excel dumps, CSV exports, PDFs, and vendor drops on an SMB or NFS share — becomes a complete, audited inventory in an afternoon: every feed… Migrate a Parquet data swamp to governed Apache Iceberg tables Lakehouse · Migration A bucket of accumulated Parquet files becomes a set of governed Iceberg tables — schemas read from footers, duplicates skipped by content digest, existing Delta/Iceberg/Hudi tables… Stream Postgres change data capture into Iceberg for Databricks MERGE Streaming · CDC You can tail a Postgres database's changes into an append-only Apache Iceberg changelog — no Kafka, no Debezium cluster, no JVM — and materialize current state in Databricks with one MERGE. Stream Postgres change data capture into Snowflake without Kafka or Snowpipe Streaming · CDC Postgres inserts, updates and deletes land in an append-only Apache Iceberg changelog that Snowflake reads in place — no Kafka, no Debezium cluster, no Snowpipe, and no connector running inside your warehouse. Copy a Postgres table into Apache Iceberg without Spark or Kafka Relational · Extract One command extracts a Postgres table — or any SELECT you can write — into a typed Apache Iceberg table your warehouse reads in place. No Spark cluster, no Kafka, no connector running inside Snowflake or Databricks. Extract scanned PDFs and images into Apache Iceberg with self-hosted OCR Documents · OCR Scanned invoices, faxes, and forms become searchable, structured rows in Iceberg — OCR runs on your own GPU with your own vision model, so documents with PHI or PII never leave your… Automate SFTP CSV drops into Apache Iceberg tables Files · Vendor drops The vendor CSV drop — daily files, shifting schemas, no contract — becomes a governed feed: detected, deduplicated, loaded to Iceberg, and watched for new arrivals under a human-approved… Load X12 837 claims into Apache Iceberg and query them from Snowflake Healthcare · Claims You can turn raw X12 837 EDI claim files into governed Apache Iceberg tables that Snowflake queries directly — without a claims clearinghouse, custom parsers, or your PHI leaving your…

Most engagements start with a read-only scan.

Nothing installed on your systems, nothing sent anywhere, and an inventory of what you actually hold — usually including a few things the team didn't know about. If that sounds useful, say hello.

Start a conversation
Lakewright — self-hosted governed ingestion into Apache Iceberg. For consultants · Patterns · Contact