Skip to main content
Comparisons

Comparisons betweenDatabend Cloud and Snowflake

We are dedicated to building the world's most powerful data cloud, determination to provide exceptional service

TPC-H Benchmark
The TPC-H benchmark is a standard for evaluating decision support systems, focusing on complex queries and data maintenance. In this analysis, we compare Databend Cloud with Snowflake using the TPC-H SF100(SF1 = 6 Million Rows) dataset, encompassing 100GB of data and approximately 600 million rows across 22 queries.
Benchmark Environment
 
Edition
Standard
 
Standard
Warehouse Size
Small
 
Small
vCPU
16
 
16
Price
$2/hour
 
$4/hour
AWS Region
us-east-2
 
us-east-2
Storage
AWS S3
 
AWS S3
Data Loading Benchmark
In the Data Loading Benchmark
The total elapsed time is 695 seconds, costing $0.77.
The total elapsed time is 446 seconds, costing $0.25.
About 36% faster
0100s200s300s400s500s
customer
15,000,000 Rows
18.137s
13.436s
lineitem
600,037,902 Rows
477.740s
305.812s
nation
25 Rows
1.347s
0.708s
orders
150,000,000 Rows
103.088s
64.323s
part
20,000,000 Rows
19.908s
12.192s
partsupp
80,000,000 Rows
67.410s
45.346s
region
5 Rows
0.743s
0.725s
supplier
10,000,000 Rows
3.000s
3.687s
Query Benchmark: Cold Run
The data warehouse was suspended and resumed before executing the queries.
In the Query Benchmark: Cold Run
The total elapsed time is 207 seconds, costing $0.23.
The total elapsed time is 166 seconds, costing $0.09.
About 20% faster
11.703 s
Databend Cloud logo8.036 s
TPC-H 1
4.524 s
Databend Cloud logo3.786 s
TPC-H 2
8.908 s
Databend Cloud logo6.04 s
TPC-H 3
8.108 s
Databend Cloud logo4.462 s
TPC-H 4
9.202 s
Databend Cloud logo7.014 s
TPC-H 5
1.237 s
Databend Cloud logo3.234 s
TPC-H 6
9.082 s
Databend Cloud logo7.345 s
TPC-H 7
10.886 s
Databend Cloud logo8.976 s
TPC-H 8
18.152 s
Databend Cloud logo13.34 s
TPC-H 9
13.525 s
Databend Cloud logo12.891 s
TPC-H 10
2.582 s
Databend Cloud logo2.183 s
TPC-H 11
10.099 s
Databend Cloud logo8.839 s
TPC-H 12
13.458 s
Databend Cloud logo7.206 s
TPC-H 13
8.001 s
Databend Cloud logo4.612 s
TPC-H 14
8.737 s
Databend Cloud logo4.621 s
TPC-H 15
4.864 s
Databend Cloud logo1.645 s
TPC-H 16
5.363 s
Databend Cloud logo14.315 s
TPC-H 17
19.971 s
Databend Cloud logo12.058 s
TPC-H 18
9.893 s
Databend Cloud logo12.579 s
TPC-H 19
8.538 s
Databend Cloud logo8.836 s
TPC-H 20
16.439 s
Databend Cloud logo12.27 s
TPC-H 21
3.744 s
Databend Cloud logo1.926 s
TPC-H 22
Query Benchmark: Hot Run
The data warehouse is not suspended, local disk cache is used.
In the Query Benchmark: Hot Run
The total elapsed time is 138 seconds, costing $0.15.
The total elapsed time is 124 seconds, costing $0.07.
About 10% faster
8.934 s
Databend Cloud logo7.568 s
TPC-H 1
3.018 s
Databend Cloud logo3.125 s
TPC-H 2
6.089 s
Databend Cloud logo5.234 s
TPC-H 3
4.914 s
Databend Cloud logo3.392 s
TPC-H 4
5.8 s
Databend Cloud logo4.857 s
TPC-H 5
0.891 s
Databend Cloud logo2.142 s
TPC-H 6
5.381 s
Databend Cloud logo4.389 s
TPC-H 7
5.724 s
Databend Cloud logo5.887 s
TPC-H 8
10.283 s
Databend Cloud logo9.621 s
TPC-H 9
10.368 s
Databend Cloud logo8.524 s
TPC-H 10
1.165 s
Databend Cloud logo1.364 s
TPC-H 11
7.052 s
Databend Cloud logo5.352 s
TPC-H 12
12.829 s
Databend Cloud logo6.18 s
TPC-H 13
3.288 s
Databend Cloud logo2.725 s
TPC-H 14
3.475 s
Databend Cloud logo2.748 s
TPC-H 15
4.094 s
Databend Cloud logo1.124 s
TPC-H 16
4.203 s
Databend Cloud logo13.757 s
TPC-H 17
18.583 s
Databend Cloud logo11.63 s
TPC-H 18
3.888 s
Databend Cloud logo7.881 s
TPC-H 19
6.379 s
Databend Cloud logo5.797 s
TPC-H 20
10.287 s
Databend Cloud logo9.806 s
TPC-H 21
1.573 s
Databend Cloud logo1.122 s
TPC-H 22
Reference Source: [TPC-H Benchmark: Databend Cloud vs. Snowflake]
Architectures
We are on a quest to build a better
 
Open Source
Open source (Core components)
 
Proprietary
Language
Rust (Fast & memory safe)
 
C++
SQL Support
 
Separation of Computing and Storage
 
Task
In Seconds
 
In Minutes
Warehouse Auto-suspending
In seconds
 
In Minutes
Storage Format
Parquet - open data format
Accessible to downstream applications
 
Legacy micro-partition
NOT accessible to downstream applications
Semi-Structured Data
 
Query Result Caching
 
Enterprise Grade Encryption
 
References:[Databend vs. Snowflake Features and Capabilities]
Scalability
Unlimited and so on
 
Scheduling
Kubernetes pod-based
 
Virtual machines-based
Elasticity
Compute node unit
 
Cluster unit; No choice of node size
Costs
More technologies, less costs.
 
Transparent Pricing
 
Cloud Service isn't transparent pricing.
Pricing
50% of Snowflake's Pricing
 
100%
Costs
Economic
Per-second billing
Provisioning compute resources in seconds
 
Expensive
Per-minute billing
Provisioning compute resources in minutes
401 RYLAND ST. STE 200-A, Reno, NV 89502, USA
© 2024 Databend Cloud. All Rights Reserved.