# Lakewright — solution briefs
> Self-hosted AI data ingestion into Apache Iceberg. Each brief
> answers one ingestion pattern; markdown is canonical for bots.

- [Convert BAI2 bank balance files to Iceberg tables Snowflake can query](https://lakewright.io/solutions/bai2-bank-reports-to-snowflake.md): BAI2 balance-reporting files from your banks become typed Iceberg tables — account balances and transaction detail with typed amounts — quer
- [Canvas Medical analytics: getting your EHI into Snowflake, governed](https://lakewright.io/solutions/canvas-medical-analytics.md): Canvas Medical has quietly become the system of record for a generation of digital-health companies, and it earned the position honestly: it
- [Load HL7 v2 messages into Apache Iceberg for Databricks analytics](https://lakewright.io/solutions/hl7-v2-to-databricks.md): HL7 v2 feeds (ADT, ORU, DFT) become queryable Iceberg tables that Databricks reads through Unity Catalog — one row per message, PHI flagged 
- [Load mainframe fixed-width files into Apache Iceberg](https://lakewright.io/solutions/mainframe-fixed-width-to-iceberg.md): Fixed-width mainframe extracts — no headers, no delimiters — become typed Iceberg tables. Lakewright infers the column layout from the data 
- [Convert NACHA ACH files to queryable Apache Iceberg tables](https://lakewright.io/solutions/nacha-ach-to-iceberg.md): 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](https://lakewright.io/solutions/network-share-file-server-assessment.md): A departmental file server — years of Excel dumps, CSV exports, PDFs, and vendor drops on an SMB or NFS share — becomes a complete, audited 
- [Migrate a Parquet data swamp to governed Apache Iceberg tables](https://lakewright.io/solutions/parquet-swamp-to-governed-iceberg.md): A bucket of accumulated Parquet files becomes a set of governed Iceberg tables — schemas read from footers, duplicates skipped by content di
- [Stream Postgres change data capture into Iceberg for Databricks MERGE](https://lakewright.io/solutions/postgres-cdc-to-databricks.md): You can tail a Postgres database's changes into an append-only Apache Iceberg changelog — no Kafka, no Debezium cluster, no JVM — and materi
- [Extract scanned PDFs and images into Apache Iceberg with self-hosted OCR](https://lakewright.io/solutions/scanned-pdfs-ocr-to-iceberg.md): Scanned invoices, faxes, and forms become searchable, structured rows in Iceberg — OCR runs on your own GPU with your own vision model, so d
- [Automate SFTP CSV drops into Apache Iceberg tables](https://lakewright.io/solutions/sftp-csv-drops-to-iceberg.md): The vendor CSV drop — daily files, shifting schemas, no contract — becomes a governed feed: detected, deduplicated, loaded to Iceberg, and w
- [Load X12 837 claims into Apache Iceberg and query them from Snowflake](https://lakewright.io/solutions/x12-837-claims-to-snowflake.md): You can turn raw X12 837 EDI claim files into governed Apache Iceberg tables that Snowflake queries directly — without a claims clearinghous