Data Warehousing & Lakehouse
Warehouses and lakehouses store large volumes of structured data and answer analytical SQL queries over it.
4 results in Data Warehousing & Lakehouse
Active Pro listings from this category appear first. Your sort applies within Pro and Free results.
Shortlists for Data Warehousing & Lakehouse
Explore collections with tools relevant to this category, grouped by deployment, source model or workload.
IT tools with an API →
8 matching tools from this category
Self-hosted IT tools →
5 matching tools from this category
Open-source IT tools →
4 matching tools from this category
How to choose Data Warehousing & Lakehouse tools
Warehouses and lakehouses store large volumes of structured data and answer analytical SQL queries over it. Some listings are managed cloud warehouses with separate storage and compute, others build table formats on object storage so many engines can read the same files, and others federate queries across existing databases without copying data. Transformation frameworks and distributed object stores that underpin these architectures also appear, while ingestion pipelines and dashboards belong to neighbouring categories.
Who uses these tools
- Data platform engineers designing analytical storage
- Analysts writing SQL against shared datasets
- Data leads controlling compute spend
Capabilities to compare
- Separation of storage and compute
- Open table format support and interoperability
- Federated queries across lakes and databases
- Governance, access control and data sharing
- In-warehouse SQL transformation and testing
Operating considerations
- Compute credits drive most of the bill
- Proprietary storage formats complicate exit
- Region choice for regulated datasets
- Idle clusters and runaway queries waste budget
Selection checklist
- Benchmark your heaviest real queries and concurrency levels during a trial rather than relying on synthetic benchmarks.
- Set budgets, auto-suspend rules and query limits before giving analysts broad access.
- Check whether data stays in open formats that other engines can read without exporting.
- Confirm row and column level security meets the needs of your most sensitive datasets.
What belongs in this category: Products qualify when they store analytical data, query it at scale, provide the open table or object storage layer beneath a lakehouse, or transform data inside the warehouse.
Typical use cases
- Centralising company data for reporting and analysis
- Querying files in object storage with SQL
- Sharing governed datasets with partners or subsidiaries
- Running version-controlled SQL transformations with tests
Trade-offs to model
- Fully managed warehouses minimise tuning work, whereas open lakehouse stacks avoid lock-in but require more engineering to operate.
- Serverless engines suit small or bursty workloads, while provisioned clusters give steadier cost for constant heavy queries.
Common mistakes
- Migrating every table before agreeing on naming, ownership and access rules, which recreates the old mess in a new place.
- Leaving warehouses running around the clock with no auto-suspend, turning idle compute into a large monthly cost.
Data Warehousing & Lakehouse on iThub in figures
iThub lists 9 tools in Data Warehousing & Lakehouse. 4 of 9 are open source, 5 of 9 can be self-hosted, 7 of 9 have a free, freemium or open-source pricing model and 8 of 9 offer an API.
- Tools listed
- 9
- Open source
- 4
- Self-hostable
- 5
- Free to start
- 7
- With an API
- 8
- Web app
- 4
- Desktop app
- 2
Recently added: Starburst, ClickHouse, Fivetran, Parseable
Compare Snowflake and Databricks Data engineering and orchestration Analytics and BI
Continue the technical evaluation
Use the resources that match your decision stage. Profile data and linked sources were refreshed through November 16, 2026.
