Snowflake

Open Snowflake in the Results Explorer

Snowflake on BenchBox: 47 published runs across 19 benchmarks. Latest run 2026-10-03.

Benchmarks

Score definitions

Power score
Power@Size: scale factor × 3600 divided by the geometric mean of the query times of the final iteration, in seconds. Unit: queries per hour at scale factor size; higher is better. Definition in the benchmark methodology.
Geomean query time
Geometric mean of the displayed per-query times of the run. Unit: milliseconds, shown as seconds from 1,000 ms; lower is better. Definition in the benchmark methodology.

Ranked runs

BenchmarkScalePhaseVersionRun dateScoreGeomeanRankingExecution environmentTuning modeTrust label
AMPLabSF 0.1powerv10.33.1012026-09-20—407 msRankedCloud, X-SmallNo tuningMaintainer Run
AMPLabSF 1powerv10.33.1012026-09-20—311 msRankedCloud, X-SmallNo tuningMaintainer Run
ClickBenchSF 1powerv10.33.1012026-09-20—259 msRankedCloud, X-SmallNo tuningMaintainer Run
CoffeeShopSF 0.1powerv10.33.1012026-09-19—494 msRankedCloud, X-SmallNo tuningMaintainer Run
CoffeeShopSF 1powerv10.33.1012026-09-19—766 msRankedCloud, X-SmallNo tuningMaintainer Run
Flight DataSF 0.1powerv10.35.1012026-10-01—384 msRankedCloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
Flight DataSF 1powerv10.35.1012026-10-01—638 msRankedCloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
Flight DataSF 10powerv10.35.1012026-10-01—2.34 sRankedCloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
H2ODBSF 0.1powerv10.33.1012026-09-19—279 msRankedCloud, X-SmallNo tuningMaintainer Run
H2ODBSF 1powerv10.33.1012026-09-19—354 msRankedCloud, X-SmallNo tuningMaintainer Run
JoinOrderSF 1powerv10.33.1012026-09-20—634 msRankedCloud, X-SmallNo tuningMaintainer Run
NYC TaxiSF 0.1powerv10.35.1012026-10-01—361 msRankedCloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
NYC TaxiSF 1powerv10.34.1012026-09-25—305 msRankedCloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
NYC TaxiSF 10powerv10.35.1012026-10-01—615 msRankedCloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
SSBSF 0.1powerv10.33.1012026-09-19—333 msRankedCloud, X-SmallNo tuningMaintainer Run
SSBSF 1powerv10.33.1012026-09-19—388 msRankedCloud, X-SmallNo tuningMaintainer Run
SSBSF 10powerv10.33.1012026-09-19—571 msRankedCloud, X-SmallNo tuningMaintainer Run
TPC-DSSF 0.1powerv10.35.1012026-10-03341.8856 msRankedCloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TPC-DSSF 1powerv10.35.1012026-10-033,709974 msRankedCloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TPC-DSSF 10powerv10.35.1012026-10-0328,9181.21 sRankedCloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TSBS DevOpsSF 0.1powerv10.35.1012026-09-29—274 msRankedCloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TSBS DevOpsSF 1powerv10.35.1012026-09-29—314 msRankedCloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TSBS DevOpsSF 10powerv10.35.1012026-09-29—450 msRankedCloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run

Runs not included in rankings

24 runs are published with their numbers and receipt but are not ranked. Reason: Non-standard runs are unofficial and are not ranked. (2); Mismatched query set. (1); Known defective data. (21)

BenchmarkScalePhaseVersionRun dateScoreGeomeanReason not rankedExecution environmentTuning modeTrust label
ClickBenchSF 0.1powerv10.33.1012026-09-20—258 msNon-standard runs are unofficial and are not ranked.Cloud, X-SmallNo tuningMaintainer Run
ClickBenchSF 10powerv10.33.1012026-09-19—341 msNon-standard runs are unofficial and are not ranked.Cloud, X-SmallNo tuningMaintainer Run
MetadataSF 1powerv10.35.1012026-10-01—987 msMismatched query set.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
Read PrimitivesSF 0.1powerv10.35.1012026-10-01—405 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
Read PrimitivesSF 0.01powerv10.35.1012026-10-01—358 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TPC-DS-OBTSF 1powerv10.35.1012026-10-01—420 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TPC-HSF 0.1powerv10.35.1012026-10-03372904 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TPC-HSF 1powerv10.35.1012026-10-033,645943 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TPC-HSF 10powerv10.35.1012026-10-0329,8761.25 sKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TPC-H Data VaultSF 0.1powerv10.34.1012026-09-26—587 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TPC-H Data VaultSF 1powerv10.34.1012026-09-25—874 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TPC-H Data VaultSF 10powerv10.35.1012026-09-30—2.92 sKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TPC-H SkewSF 0.1powerv10.34.1012026-09-25—345 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TPC-H SkewSF 1powerv10.34.1012026-09-25—389 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TPC-H SkewSF 10powerv10.35.1012026-09-29—805 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TPC-HavocSF 0.1powerv10.35.1012026-09-30—345 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TPC-HavocSF 1powerv10.35.1012026-09-30—468 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TPC-HavocSF 10powerv10.35.1012026-09-30—885 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TransactionsSF 0.01powerv10.35.1012026-10-01—2.76 sKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TransactionsSF 0.1powerv10.35.1012026-10-01—2.67 sKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
TransactionsSF 1powerv10.35.1012026-10-01—2.64 sKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
Write PrimitivesSF 0.1powerv10.35.1012026-09-30—1.07 sKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
Write PrimitivesSF 0.01powerv10.35.1012026-09-30—1.09 sKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
Write PrimitivesSF 1powerv10.35.1012026-10-01—1.29 sKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run