Comparison

Updated October 25, 2026

· ~2 min read

Redshift vs Snowflake vs Databricks on AWS in 2026: Pricing Models, Open Tables and Fit

Amazon Redshift
Snowflake
Databricks
Data Warehouse
Apache Iceberg

The warehouse decision used to lock in your data. It locks in much less now. Redshift, Snowflake and Databricks can all read and write Apache Iceberg tables in S3, so the storage layer can be shared and the compute engine chosen per workload.

What still differs is how each one bills, how much of the platform you get beyond SQL, and how naturally it fits the rest of an AWS account.

How each one bills

Amazon Redshift

Snowflake

Databricks

Compute unit

Serverless: $0.375 per RPU-hour, base from 4 RPUs; or provisioned RA3 nodes (ra3.4xlarge $3.26/hour)

Credits: $2.00 Standard, $3.00 Enterprise, $4.00 Business Critical (on-demand, AWS US East); warehouse size sets credits per hour

DBUs priced by SKU and tier; serverless SQL includes compute, classic compute adds your EC2 bill

Idle

Serverless bills only while queries run

Warehouses auto-suspend; per-second billing with a 60-second minimum

Serverless warehouses auto-stop

Storage

Managed storage $0.024/GB-month

From $23 per compressed TB-month

Your S3, at S3 prices

Commitments

Serverless reservations: up to 24% off for 1 year, 45% for 3 years

Capacity contracts at lower credit prices

Committed-use contracts

Worked example: a reporting workload, 8 hours a day, 22 days a month

Setup

Approximate monthly compute

Assumption

Redshift Serverless at 32 RPU

~$2,110

176 hours of active queries

Snowflake Medium warehouse, Enterprise

~$2,110

4 credits an hour for 176 hours

Databricks SQL Serverless

Depends on warehouse size and DBU rate

Price it with your negotiated rate

Platform beyond SQL

Amazon Redshift

Snowflake

Databricks

Open tables

Queries Iceberg in S3 and S3 Tables

Iceberg tables, managed or external

Delta Lake and Iceberg through Unity Catalog

Loading from AWS databases

Zero-ETL from Aurora, RDS and DynamoDB

Connectors and Openflow; partner tools

Lakeflow connectors; partner tools

ML and AI

Redshift ML; Bedrock and SageMaker alongside

Snowpark, Cortex AI functions

Full ML platform: notebooks, MLflow, model serving

Sharing data between companies

Data sharing, AWS Data Exchange

Secure data sharing and Marketplace, a core strength

Delta Sharing

Where it runs

Your AWS account

Snowflake's account on AWS; PrivateLink on Business Critical

Control plane in Databricks' account; serverless or your VPC for classic compute

Which one

Question 1 of 3

Who writes most of the queries?

Our verdict

**Redshift:** your data and pipelines are on AWS, you want zero-ETL from Aurora, RDS and DynamoDB, and you prefer one bill and one IAM model. Serverless removes most of the cluster management. **Snowflake:** analysts and SQL are the center of the work, you want the least administration and strong data sharing between companies. You pay a premium for that simplicity. **Databricks:** engineering-heavy teams doing data engineering, ML and SQL on the same platform, comfortable with notebooks and Spark. The broadest platform and the most to configure. At list prices, similar workloads land in similar ranges. Concurrency, idle time and how well the team tunes each platform move the bill more than the rate card.

Related solutions

AWS Data Lakehouse Platform

A production data lakehouse on AWS (S3-backed data lake with Glue, Iceberg, Athena, and Redshift) structured for analytics, ML feature stores, and governed data sharing.

4–10 weeks
$25k–$60k
View

AWS Cost Optimization & FinOps Sprint

Reduce your AWS bill by 20–60% while improving performance and reliability.

1–3 weeks
$6k–$18k
View

Get your data platform designed and costed

We work with startups and growing companies on AWS architecture decisions. Tell us about your situation and we will recommend the right approach.

As of October 25, 2026. Provided as is, for general information, and accurate to the best of our knowledge on the date shown. Not legal, compliance, tax, financial or other professional advice. Prices, limits and vendor services change; check current vendor documentation before relying on anything here. Terms of use.