How it works
Your data stays.
Your tools come and go.
A managed lakehouse for your files and tables. Connect your agents and tools, bring your own compute, and keep everything in open formats.
Managed in Europe · Self-hosting available
Bring data
Your LakehouseBox
Connect tools
A simple structure.
- Organization
- Catalog
- Tables & files
Control access at each level.
For admins
Set up once. Keep control.
-
01
Create a catalog
Organise your data in catalogs, namespaces and tables: one catalog per team, project or dataset.
-
02
Give access
Share with your team and their agents: read or write per catalog; with Enterprise, per table and through your identity provider.
-
03
Bring data in
Load files and tables from your sources, feeds and pipelines. Every load is one commit.
-
04
Observe
Read the audit log and your usage, and revoke any connection. We keep the tables healthy.
Use it with the tools you already love.
-
Agents with a shell
Claude Code, Codex or any agent: one approval in the browser, then DuckDB on its own machine.
Learn more -
Chat assistants
Ask about your data in natural language from Claude, ChatGPT or any MCP host.
Learn more -
The browser
Explore your data on the account page: tables, previews, maps and SQL that runs in the browser.
Learn more -
Engines & pipelines
Use your existing compute: DuckDB, PyIceberg, Spark, Trino, Polars; Snowflake reads.
Learn more -
Hosted agents Preview
A prompt we run next to your data, on a schedule, that emails you what it finds.
Learn more
A closer look under the hood.
Explore the capabilities, without the wall of text.
Open tables. Durable storage.
Your data is stored in open formats, with one catalog for tables, files and permissions.
- Apache IcebergAn open table format with atomic commits and schema evolution. Version 2 by default, version 3 for geometry.
- Files alongside tablesEach catalog has a file bucket for the files around its tables: source downloads, rasters, photos.
- Snapshots & historyRead a table as it was, or roll it back: 20 snapshots and 7 days by default, up to 90 days per catalog.
- Managed maintenanceCompaction, snapshot expiry and cleanup on every table every 6 hours, included. Geometry tables get automatic spatial clustering: compaction keeps their rows in spatial order as agents append, so a lookup by area stays cheap (how). Backups every hour, with a restore drilled weekly.
- Public tables from a CDNA published catalog is served from edge servers near each reader.
- Cold tierData untouched for 7 days moves to cheaper storage; the first read of it is slower. A catalog can stay hot.
SQL
SELECT * FROM acme_corp.analytics.events LIMIT 10;
Every way in ends as a table.
Files, feeds, devices, pipelines and messages: each load is one Iceberg commit.
- Writes from your engine
CREATE TABLE … AS SELECT,INSERTandCOPYfrom DuckDB, PyIceberg or Spark commit straight to the catalog. - File importMany Parquet, CSV or GeoParquet files loaded as one commit.
- Ingest sinksOne HTTP intake per table for a device or webhook, with a send-only key.
- Scheduled SQLA query over a URL on a schedule; we run it and commit the rows. No server of your own.
- Upload keys & drop boxA key that can only put files in one folder; FTP, FTPS or SFTP for cameras and scanners.
- WhatsApp PilotMembers' messages, photos, locations and voice notes become rows and files in a table of yours.
Shell
lhbox table import 'exports/*.parquet' --namespace raw --name ordersYour engine, or ours for a quick look.
Engines read the files straight from storage; rows never pass through our servers, except for the capped query a chat runs on our side.
- Verified enginesDuckDB 1.5.5+, PyIceberg 0.12, Spark 3.5, Trino 483 and Polars 1.44 read and write. ClickHouse and Snowflake read, with limits.
- One command to connect
lhbox duckdbopens a shell with the catalog attached;lhbox connectprints any engine's recipe. - MCP serverTen tools for any MCP host: list, describe, query on our side (20 s, 2,000 rows), writes when approved.
- SQL in the browserDuckDB compiled to WebAssembly on the account page; the site never sees the data.
Engines: versions and limitations
| Engine | Status | Notes |
|---|---|---|
| DuckDB 1.5.5+ | read and write, verified | 1.5.5 also writes format version 3 |
| PyIceberg 0.12 | read and write (version 2), verified | reads version 3, cannot write it |
| Spark 3.5 + Iceberg 1.11 | read and write, version 3 included | 2026-09-20, with a geometry column |
| Trino 483 | read and write, verified | 2026-09-28, format version 2 |
| Polars 1.44 + PyIceberg 0.12 | read and write, verified | 2026-09-28, reader_override="pyiceberg" |
| ClickHouse 25.8, 26.9 | reads with icebergS3 | not yet through its catalog engine |
| Snowflake | reads, on an account Snowflake Support has allowed | verified 2026-09-28 |
| Databricks | untested | no run, no recipe |
Shell
lhbox duckdb
Access a person approves.
Every person and agent holds exactly what it was granted, and loses it in one click.
- AccountsEmail and password or Google, with an authenticator app or a passkey.
- Roles & grantsAdmin or member; read or write on each catalog, for each person and each key.
- Agent connectionsApproved once in the browser; the key is saved, never shown, and revocable on its own.
- Isolation at the catalogA credential for one catalog cannot read another; storage credentials last an hour.
- Start without an account
lhbox newgives an agent a catalog at once; a person keeps it withlhbox claim. - SSO & SCIM EnterpriseYour OpenID Connect provider, SCIM provisioning, group rules, table grants, service accounts.
Shell
lhbox login
Tables that keep themselves fresh.
Feeds, devices and agents that run on a schedule, with no server of your own.
- Scheduled SQL“Read this URL every 20 minutes” is one command.
- Ingest sinksDevices, webhooks and scripts append rows over HTTP.
- Hosted agents PreviewA prompt we run on a schedule: it reads your tables, appends rows and emails you. The model runs in the EU.
- Skills for agentsAn open plugin for Claude Code and Codex that teaches them LakehouseBox.
Shell
lhbox agent run garden_morning --dry-run --wait
Run by us, visible to you.
What we measure, we publish; what is not there yet, we say.
- Backups & restoreData stored in Frankfurt, Germany, with a replicated copy in Stockholm, Sweden; the catalog's state backed up every 5 minutes.
- EncryptionTLS on every hostname; every chunk encrypted before it reaches a disk.
- Audit logEvery action with who did it, kept 400 days; with Enterprise, as a catalog you can query.
- Limits you can readThe API names each limit and its headroom; over the storage limit, reads keep working.
- Said plainlyOne host, recreated automatically in about 4 minutes; no standby and no SLA yet.
Shell
lhbox audit
Our cloud or yours.
The same product, operated by us in Europe or by you on your own servers.
- Our cloudOperated by Lakehousebox, S.L. in Frankfurt, Germany, with a replicated copy of the data in Stockholm, Sweden; no US-controlled company operates any part of it.
- Self-hostedThe same containers on your servers, air-gapped if needed, with signed releases.
- Your data stays openParquet files and Iceberg metadata in a bucket you can list; copy them out at any time.
Where LakehouseBox fits.Compare storage, compute and operations.Compare with cloud platforms
| LakehouseBox | Snowflake | BigQuery | Databricks | Microsoft Fabric | |
|---|---|---|---|---|---|
| Who operates it | Lakehousebox, S.L. (Spain), in Germany; or you, self-hosted | Snowflake (US), on AWS, Azure or Google Cloud | Google (US), on Google Cloud | Databricks (US), on AWS, Azure or Google Cloud | Microsoft (US), on Azure |
| Table format | Apache Iceberg, every table | its own format; Iceberg tables as an option | its own storage; Iceberg tables through BigLake | Delta Lake; Iceberg through Unity Catalog | Delta Lake in OneLake; Iceberg through shortcuts |
| Where queries run | in your engine or agent; small queries from a chat on our side | Snowflake's warehouses | BigQuery's engine | Databricks clusters and SQL warehouses | Fabric capacity |
| What you pay for | storage only; 5 GB free | compute credits, storage, services | bytes scanned or slots, storage | compute units, plus your cloud bill | capacity units, storage |
| How an agent starts | lhbox new with no account, or one approval by a person | an account, a project or workspace, and credentials set up by a person | |||
Those platforms sell storage and compute together; LakehouseBox is the storage half, as open tables, and your engine brings the compute. Side-by-side pages with sources: Compare.
Start with your data.
Explore pricing or create your first catalog. We meter storage only: 5 GB free, no card.