Snowflake
Open Snowflake in the Results Explorer
Snowflake on BenchBox: 47 published runs across 19 benchmarks. Latest run 2026-10-03.
Benchmarks
- AMPLab, 2 runs
- ClickBench, 3 runs
- CoffeeShop, 2 runs
- Flight Data, 3 runs
- H2ODB, 2 runs
- JoinOrder, 1 run
- Metadata, 1 run
- NYC Taxi, 3 runs
- Read Primitives, 2 runs
- SSB, 3 runs
- TPC-DS, 3 runs
- TPC-DS-OBT, 1 run
- TPC-H, 3 runs
- TPC-H Data Vault, 3 runs
- TPC-H Skew, 3 runs
- TPC-Havoc, 3 runs
- Transactions, 3 runs
- TSBS DevOps, 3 runs
- Write Primitives, 3 runs
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
| Benchmark | Scale | Phase | Version | Run date | Score | Geomean | Ranking | Execution environment | Tuning mode | Trust label |
|---|---|---|---|---|---|---|---|---|---|---|
| AMPLab | SF 0.1 | power | v10.33.101 | 2026-09-20 | — | 407 ms | Ranked | Cloud, X-Small | No tuning | Maintainer Run |
| AMPLab | SF 1 | power | v10.33.101 | 2026-09-20 | — | 311 ms | Ranked | Cloud, X-Small | No tuning | Maintainer Run |
| ClickBench | SF 1 | power | v10.33.101 | 2026-09-20 | — | 259 ms | Ranked | Cloud, X-Small | No tuning | Maintainer Run |
| CoffeeShop | SF 0.1 | power | v10.33.101 | 2026-09-19 | — | 494 ms | Ranked | Cloud, X-Small | No tuning | Maintainer Run |
| CoffeeShop | SF 1 | power | v10.33.101 | 2026-09-19 | — | 766 ms | Ranked | Cloud, X-Small | No tuning | Maintainer Run |
| Flight Data | SF 0.1 | power | v10.35.101 | 2026-10-01 | — | 384 ms | Ranked | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| Flight Data | SF 1 | power | v10.35.101 | 2026-10-01 | — | 638 ms | Ranked | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| Flight Data | SF 10 | power | v10.35.101 | 2026-10-01 | — | 2.34 s | Ranked | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| H2ODB | SF 0.1 | power | v10.33.101 | 2026-09-19 | — | 279 ms | Ranked | Cloud, X-Small | No tuning | Maintainer Run |
| H2ODB | SF 1 | power | v10.33.101 | 2026-09-19 | — | 354 ms | Ranked | Cloud, X-Small | No tuning | Maintainer Run |
| JoinOrder | SF 1 | power | v10.33.101 | 2026-09-20 | — | 634 ms | Ranked | Cloud, X-Small | No tuning | Maintainer Run |
| NYC Taxi | SF 0.1 | power | v10.35.101 | 2026-10-01 | — | 361 ms | Ranked | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| NYC Taxi | SF 1 | power | v10.34.101 | 2026-09-25 | — | 305 ms | Ranked | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| NYC Taxi | SF 10 | power | v10.35.101 | 2026-10-01 | — | 615 ms | Ranked | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| SSB | SF 0.1 | power | v10.33.101 | 2026-09-19 | — | 333 ms | Ranked | Cloud, X-Small | No tuning | Maintainer Run |
| SSB | SF 1 | power | v10.33.101 | 2026-09-19 | — | 388 ms | Ranked | Cloud, X-Small | No tuning | Maintainer Run |
| SSB | SF 10 | power | v10.33.101 | 2026-09-19 | — | 571 ms | Ranked | Cloud, X-Small | No tuning | Maintainer Run |
| TPC-DS | SF 0.1 | power | v10.35.101 | 2026-10-03 | 341.8 | 856 ms | Ranked | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| TPC-DS | SF 1 | power | v10.35.101 | 2026-10-03 | 3,709 | 974 ms | Ranked | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| TPC-DS | SF 10 | power | v10.35.101 | 2026-10-03 | 28,918 | 1.21 s | Ranked | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| TSBS DevOps | SF 0.1 | power | v10.35.101 | 2026-09-29 | — | 274 ms | Ranked | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| TSBS DevOps | SF 1 | power | v10.35.101 | 2026-09-29 | — | 314 ms | Ranked | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| TSBS DevOps | SF 10 | power | v10.35.101 | 2026-09-29 | — | 450 ms | Ranked | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer 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)
| Benchmark | Scale | Phase | Version | Run date | Score | Geomean | Reason not ranked | Execution environment | Tuning mode | Trust label |
|---|---|---|---|---|---|---|---|---|---|---|
| ClickBench | SF 0.1 | power | v10.33.101 | 2026-09-20 | — | 258 ms | Non-standard runs are unofficial and are not ranked. | Cloud, X-Small | No tuning | Maintainer Run |
| ClickBench | SF 10 | power | v10.33.101 | 2026-09-19 | — | 341 ms | Non-standard runs are unofficial and are not ranked. | Cloud, X-Small | No tuning | Maintainer Run |
| Metadata | SF 1 | power | v10.35.101 | 2026-10-01 | — | 987 ms | Mismatched query set. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| Read Primitives | SF 0.1 | power | v10.35.101 | 2026-10-01 | — | 405 ms | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| Read Primitives | SF 0.01 | power | v10.35.101 | 2026-10-01 | — | 358 ms | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| TPC-DS-OBT | SF 1 | power | v10.35.101 | 2026-10-01 | — | 420 ms | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| TPC-H | SF 0.1 | power | v10.35.101 | 2026-10-03 | 372 | 904 ms | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| TPC-H | SF 1 | power | v10.35.101 | 2026-10-03 | 3,645 | 943 ms | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| TPC-H | SF 10 | power | v10.35.101 | 2026-10-03 | 29,876 | 1.25 s | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| TPC-H Data Vault | SF 0.1 | power | v10.34.101 | 2026-09-26 | — | 587 ms | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| TPC-H Data Vault | SF 1 | power | v10.34.101 | 2026-09-25 | — | 874 ms | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| TPC-H Data Vault | SF 10 | power | v10.35.101 | 2026-09-30 | — | 2.92 s | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| TPC-H Skew | SF 0.1 | power | v10.34.101 | 2026-09-25 | — | 345 ms | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| TPC-H Skew | SF 1 | power | v10.34.101 | 2026-09-25 | — | 389 ms | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| TPC-H Skew | SF 10 | power | v10.35.101 | 2026-09-29 | — | 805 ms | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| TPC-Havoc | SF 0.1 | power | v10.35.101 | 2026-09-30 | — | 345 ms | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| TPC-Havoc | SF 1 | power | v10.35.101 | 2026-09-30 | — | 468 ms | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| TPC-Havoc | SF 10 | power | v10.35.101 | 2026-09-30 | — | 885 ms | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| Transactions | SF 0.01 | power | v10.35.101 | 2026-10-01 | — | 2.76 s | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| Transactions | SF 0.1 | power | v10.35.101 | 2026-10-01 | — | 2.67 s | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| Transactions | SF 1 | power | v10.35.101 | 2026-10-01 | — | 2.64 s | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| Write Primitives | SF 0.1 | power | v10.35.101 | 2026-09-30 | — | 1.07 s | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| Write Primitives | SF 0.01 | power | v10.35.101 | 2026-09-30 | — | 1.09 s | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| Write Primitives | SF 1 | power | v10.35.101 | 2026-10-01 | — | 1.29 s | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |