Replicate core Databricks functionality โ SQL workspace, notebooks, pipelines, catalog, and BI connectivity โ on a single Docker Compose stack. Zero cloud vendor lock-in.
-- Daily SQL aggregation from PostgreSQL raw ingestion
SELECT
date_trunc('day', order_date) AS order_day,
count(order_id) AS total_orders,
round(sum(revenue_usd), 2) AS daily_revenue
FROM main.sales.orders
GROUP BY 1
ORDER BY 1 DESC;
Click "Run Query" to compile and aggregate on Apache Spark.
Engineered with the modern data stack
Our Services
From raw ingestion to BI dashboards, Lakehouse Studio covers the full data engineering lifecycle with no external dependencies.
Multi-tab CodeMirror 6 editor with Spark SQL execution, Python notebooks, query history, and saved query folders โ all in the browser.
Explore every catalog, schema, and table registered in Unity Catalog. View column types, storage paths, Delta log versions, and owners without leaving the UI.
Ingest from PostgreSQL, MySQL, S3, Azure Blob, MinIO, or SFTP into Delta tables on a schedule โ hourly, daily, or on file arrival. Merge, append, or overwrite.
Schedule any SQL statement or notebook on a cron expression. Backed by pg-boss so jobs survive restarts. Full run history with output capture.
Apache Thrift Server exposes all Unity Catalog tables via JDBC/ODBC on port 10000. Power BI, Tableau, DBeaver, and Superset connect in minutes.
Role-based access (admin / editor / viewer), AES-256-GCM credential encryption, account lockout, immutable audit log, and a 7-day table recovery window.
Reference Architecture
Every byte flows through a single governed pipeline โ ingested, streamed, modeled, and served to analytics, AI, and the applications that run your business.
Get Started
Lakehouse Studio is designed to be operational in under an hour โ no cloud account required.
Clone the repo, run the setup wizard to generate your .env, then start the full stack โ Spark, Unity Catalog, Studio UI, Thrift Server, and Postgres โ with a single docker compose up.
โ Container lakehouse-unity-catalog Started
โ Container lakehouse-thrift-server Started
โ Container lakehouse-studio-ui Started
Register your PostgreSQL, MySQL, S3, Azure Blob, or SFTP sources in the Connections panel. Credentials are AES-256-GCM encrypted before storage.
Use the pipeline wizard to schedule automated ingestion into Delta tables. Write and run SQL or Python notebooks directly against your Spark cluster.
Copy the auto-generated JDBC connection string from Admin โ BI Connections and paste it into Power BI, Tableau, DBeaver, or Superset. Done.
Command to deploy the full stack
Supported data source types
BI tools supported out of the box
Day table recovery window
Deployment Models
From fully managed to fully air-gapped โ the same platform, the same governance, deployed to meet your security and sovereignty requirements.
Fully hosted, zero ops
Control plane + your VPC
Your infrastructure
Disconnected & classified
Engagement Models
Start free. Scale when you need more. All plans include the full self-hosted platform.
Perfect for individuals and small teams exploring data engineering.
For data teams that need reliability and priority support.
For organizations with compliance, scale, or custom deployment needs.
Testimonials
โWe replaced a $40k/year Databricks subscription with Lakehouse Studio running on two on-prem servers. Our pipeline latency is actually better now.โ
James Okafor
Lead Data Engineer ยท FinAxis Group
โSetting up our Power BI connection took less than 10 minutes. The auto-generated JDBC string just works. Our analysts were querying live Delta tables the same afternoon.โ
Priya Mehta
Data Analytics Manager ยท RetailEdge
โThe audit log and 7-day table recovery window were the features that convinced our security team. We had our GDPR compliance sign-off within a week of deployment.โ
Tobias Hoffmann
Platform Engineer ยท Nexora Health
โI ingested 15 years of SFTP partner files into Delta tables in a single afternoon using the pipeline wizard. No Spark code required โ the UI handled everything.โ
Sarah Lin
Data Engineer ยท LogiPath
Support
Security & Governance
Security and compliance aren't add-ons โ they're built into every layer of the platform, certified by independent auditors.
AES-256 at rest, TLS 1.3 in transit, customer-managed keys.
Row, column, and attribute-level RBAC with SSO & SCIM.
Every query, change, and access event captured and exportable.
Column-level lineage from source to dashboard, automatically.
Automatic classification with dynamic data masking policies.
Private networking, no public endpoints, least-privilege by default.
Independently audited & certified
Stop paying cloud compute markups. Deploy Lakehouse Studio on your own server today โ Community edition is free, open, and ready in under an hour.
Get In Touch
Tell us about your goals and challenges. We will get back to you within one business day to scope how we can help.
Email Support
hello@lakehousestudio.io