Skip to content

Kinetica vs. Snowflake

Performance Benchmarks

At Kinetica, our product is our super power. We’re more performant, cost effective, and feature rich than any other data warehouse on the market today. To prove it to you, we’ve undertaken a comprehensive benchmarking exercise against today’s popular data warehousing solutions.

In our results against Snowflake, Kinetica is able to process queries 2x to 16x faster, while offering annual cost savings of 15% to 40%. You can find the full benchmarking results below.

Summary

We performed benchmarking using the TPC Benchmark DS (TPC-DS), a decision support benchmark that models several generally applicable aspects of a decision support system, including queries and data maintenance. The benchmark provides a representative evaluation of performance as a general purpose decision support system.

Snowflake Setup

Snowflake Large (equal to 8 nodes per cluster) and Snowflake 4x Large (equal to 64 nodes per cluster) on 15th October 2020

Kinetica Setup

Kinetica Release: 7.1.1

Azure VM type GPU per node VCPU per node RAM per node Storage per node # of nodes
NV48s v3 4 24 448 GB 2TB 1

Performance Results

Both Kinetica and Snowflake support all 99 TPC-DS queries. Our observations on performance were the following:

  • The price/performance ratio is computed as annual cost / average query execution time for the TPC-DS query. The lower the ratio, the better the performance. Kinetica's price/performance = 9.22 vs Snowflake Large's 66.63 and Snowflake 4X Large of 502.21.
  • We define the average query performance factor for a benchmark run as equal to the average of query execution time of a query for Kinetica / query execution time of the same query for a benchmark run, across all 99 TPC-DS queries. This way, we get a normalized performance factor between a Kinetica run and a Snowflake run. Each row in the table below is a benchmark run.

Cost Assumption: We consider Snowflake Enterprise and Kinetica Premium Edition pricing.

Snowflake Large Cluster vs Kinetica Single Node

  TPC-DS Price/Performance Ratio Avg Query Performance Factor INFRA cost License Annual cost
Snowflake Large cluster (8 nodes) 66.63 1.1 Included in snowflake subscription $3*8 per hour compute cost + $0.064/TB per hour $210K
Kinetica NV48s v3 Single node 9.23 2.05 $3.024/hour = 26.5K/year $104K per year $130.5K
Kinetica Performance
Snowflake Performance

Kinetica queries twice as fast as Snowflake, on average

Kinetica Annual Cost
$K
Snowflake Annual Cost
$K

Kinetica costs an average of 40% less than Snowflake annually

Snowflake 4X Large Cluster vs Kinetica Eight Nodes

  TPC-DS Price/Performance Ratio Avg Query Performance Factor INFRA cost License Annual cost
Snowflake 4X Large cluster (64 nodes) 502.21 1.0 Included in snowflake subscription $3*64 per hour compute cost + $0.064/TB per hour $1.68 Million
Kinetica NV48s v3 Eight nodes 10.1 16.21 $3.024*8/hour = 211K/year $104*8K per year $1.43 Million
Kinetica Performance
Snowflake Performance

Kinetica queries 16x faster than Snowflake, on average

Kinetica Annual Cost
$M
Snowflake Annual Cost
$M

Kinetica costs an average of 15% less than Snowflake annually

Want to learn more about Kinetica and how we compare to Snowflake?