Best Data Warehouses Software & Tools

Compare data warehouses on user reviews: query speed, concurrency, storage and compute separation, cost controls and surprise bills.

10 products

Amazon Redshift is a cloud data warehouse from Amazon Web Services, run as provisioned clusters or Serverless with usage-based pricing, for teams on AWS.

Features

Has Independent scaling of storage and compute
Has Serverless query execution
Has Multi-cluster concurrency scaling
Missing Time travel to prior table states
Missing Zero-copy cloning of databases
Has Auto-refreshing materialized views
Has Native semi-structured columns
Has External tables on data lake files
Has Open table format interoperability
Has Streaming row ingestion into tables
Has Live data sharing across accounts
Has Column masking policies
Has Row access policies
Has Automatic query result reuse
Has Workload management queues
Has Compute spend limits and alerts
Missing Cross-region warehouse replication
Missing In-warehouse Python execution

Azure Synapse Analytics is Microsoft's cloud data warehouse and analytics service, joining T-SQL pools, Spark and pipelines on Azure with pay-as-you-go billing.

Features

Has Independent scaling of storage and compute
Has Serverless query execution
Missing Multi-cluster concurrency scaling
Has Time travel to prior table states
Missing Zero-copy cloning of databases
Has Auto-refreshing materialized views
Missing Native semi-structured columns
Has External tables on data lake files
Has Open table format interoperability
Has Streaming row ingestion into tables
Missing Live data sharing across accounts
Has Column masking policies
Has Row access policies
Has Automatic query result reuse
Has Workload management queues
Has Compute spend limits and alerts
Missing Cross-region warehouse replication
Missing In-warehouse Python execution

BigQuery is Google Cloud's serverless data warehouse for SQL analytics, machine learning and streaming data, billed by data scanned or by slot capacity.

Features

Has Independent scaling of storage and compute
Has Serverless query execution
Has Multi-cluster concurrency scaling
Has Time travel to prior table states
Has Zero-copy cloning of databases
Has Auto-refreshing materialized views
Has Native semi-structured columns
Has External tables on data lake files
Has Open table format interoperability
Has Streaming row ingestion into tables
Has Live data sharing across accounts
Has Column masking policies
Has Row access policies
Has Automatic query result reuse
Has Workload management queues
Has Compute spend limits and alerts
Has Cross-region warehouse replication
Has In-warehouse Python execution
ClickHouse

by ClickHouse

No reviews yet

ClickHouse is an open-source column-oriented database for real-time analytics and data warehousing, run self-hosted or as usage-billed ClickHouse Cloud.

Features

Has Independent scaling of storage and compute
Missing Serverless query execution
Missing Multi-cluster concurrency scaling
Missing Time travel to prior table states
Missing Zero-copy cloning of databases
Has Auto-refreshing materialized views
Has Native semi-structured columns
Has External tables on data lake files
Has Open table format interoperability
Has Streaming row ingestion into tables
Missing Live data sharing across accounts
Has Column masking policies
Has Row access policies
Has Automatic query result reuse
Has Workload management queues
Has Compute spend limits and alerts
Missing Cross-region warehouse replication
Has In-warehouse Python execution

Databricks is a data lakehouse platform for SQL warehousing, data engineering, machine learning and AI agents on open table formats, sold pay as you go.

Features

Has Independent scaling of storage and compute
Has Serverless query execution
Has Multi-cluster concurrency scaling
Has Time travel to prior table states
Has Zero-copy cloning of databases
Has Auto-refreshing materialized views
Has Native semi-structured columns
Has External tables on data lake files
Has Open table format interoperability
Has Streaming row ingestion into tables
Has Live data sharing across accounts
Has Column masking policies
Has Row access policies
Has Automatic query result reuse
Missing Workload management queues
Has Compute spend limits and alerts
Has Cross-region warehouse replication
Has In-warehouse Python execution
Exasol

by Exasol

No reviews yet

Exasol is an in-memory analytics database and data warehouse for many concurrent users and AI agents, deployable as SaaS, on premises or in hybrid setups.

Features

Missing Independent scaling of storage and compute
Missing Serverless query execution
Missing Multi-cluster concurrency scaling
Missing Time travel to prior table states
Missing Zero-copy cloning of databases
Missing Auto-refreshing materialized views
Missing Native semi-structured columns
Missing External tables on data lake files
Missing Open table format interoperability
Missing Streaming row ingestion into tables
Missing Live data sharing across accounts
Missing Column masking policies
Missing Row access policies
Has Automatic query result reuse
Has Workload management queues
Missing Compute spend limits and alerts
Missing Cross-region warehouse replication
Has In-warehouse Python execution
Firebolt

by Firebolt

No reviews yet

Firebolt is an open-source analytical database and data warehouse for engineers, run yourself or as a usage-billed managed service on AWS.

Features

Has Independent scaling of storage and compute
Missing Serverless query execution
Has Multi-cluster concurrency scaling
Missing Time travel to prior table states
Has Zero-copy cloning of databases
Missing Auto-refreshing materialized views
Has Native semi-structured columns
Has External tables on data lake files
Missing Open table format interoperability
Has Streaming row ingestion into tables
Missing Live data sharing across accounts
Missing Column masking policies
Missing Row access policies
Has Automatic query result reuse
Missing Workload management queues
Missing Compute spend limits and alerts
Missing Cross-region warehouse replication
Has In-warehouse Python execution
MotherDuck

by MotherDuck

No reviews yet

MotherDuck is a serverless data warehouse built on DuckDB that gives every user, customer and AI agent its own compute instance, billed by usage.

Features

Has Independent scaling of storage and compute
Has Serverless query execution
Has Multi-cluster concurrency scaling
Has Time travel to prior table states
Has Zero-copy cloning of databases
Missing Auto-refreshing materialized views
Has Native semi-structured columns
Has External tables on data lake files
Has Open table format interoperability
Missing Streaming row ingestion into tables
Has Live data sharing across accounts
Has Column masking policies
Has Row access policies
Missing Automatic query result reuse
Missing Workload management queues
Missing Compute spend limits and alerts
Missing Cross-region warehouse replication
Missing In-warehouse Python execution
Snowflake

by Snowflake

No reviews yet

Snowflake is a cloud data warehouse and lakehouse for analytics, data engineering and AI teams, with usage-based pricing in compute credits plus storage.

Features

Has Independent scaling of storage and compute
Has Serverless query execution
Has Multi-cluster concurrency scaling
Has Time travel to prior table states
Has Zero-copy cloning of databases
Has Auto-refreshing materialized views
Has Native semi-structured columns
Has External tables on data lake files
Has Open table format interoperability
Has Streaming row ingestion into tables
Has Live data sharing across accounts
Has Column masking policies
Has Row access policies
Has Automatic query result reuse
Missing Workload management queues
Has Compute spend limits and alerts
Has Cross-region warehouse replication
Has In-warehouse Python execution
Teradata

by Teradata

No reviews yet

Teradata is an enterprise data warehouse and AI platform that runs in Teradata Cloud, a customer's own cloud or on premises, sold on consumption pricing.

Features

Has Independent scaling of storage and compute
Missing Serverless query execution
Has Multi-cluster concurrency scaling
Has Time travel to prior table states
Missing Zero-copy cloning of databases
Has Auto-refreshing materialized views
Has Native semi-structured columns
Has External tables on data lake files
Has Open table format interoperability
Has Streaming row ingestion into tables
Missing Live data sharing across accounts
Missing Column masking policies
Has Row access policies
Missing Automatic query result reuse
Has Workload management queues
Missing Compute spend limits and alerts
Missing Cross-region warehouse replication
Has In-warehouse Python execution
0 selected