Snowflake users need to download this report to understand how Kyvos:
- Delivers up to 50% cost savings on Snowflake
- Ensures 3x faster query performance at higher user concurrency
- Builds a single source of truth for enterprise-wide users
- Offers AI-powered smart aggregation for hyper-speed analytics
- Connects with all data sources and warehouses
- Has built-in SQL and MDX engines for seamless BI tool connectivity
- Supports business-driven hierarchies and advanced OLAP functions
Executive Summary
This document demonstrates how Kyvos can help save up to 50% of the Snowflake cost and offer many other additional advantages over its data warehouse architecture.
A typical cloud data warehouse like Snowflake charges based on warehouse size and running time. For each query, it performs joins and aggregates, which leads to higher query execution time and eventually, higher costs.
With Kyvos semantic performance layer between Snowflake and BI tools, enterprises can drastically reduce costs, improve query performance and experience many other benefits of a true semantic layer.
Kyvos creates smart aggregates from underlying data sources to serve all queries. This eliminates load on the underlying data warehouses during querying time, which further results in lower costs. The platform’s distributed architecture and high-performance analytical aggregate cache boost query performance by serving the queries directly from these smart aggregates.
A Quick Reckoner
| Feature | Snowflake | Snowflake with Kyvos |
|---|---|---|
| Query Cost | ||
| Query Processing Cost | Higher by 40-50% | Price-performant |
| Additional Source Cost | Yes | No |
| Incremental Refresh | No limit | 1M row capacity |
| License Type | Pay-per-use | Subscription or pay-per-use |
| Semantic Layer Capabilities | ||
| Semantic Layer | Not available | Available |
| Distinct Count Function | Manual calculation | Inbuilt |
| Automated Incremental Build | Requires Snowpipe | Bundled |
| Query Performance | ||
| Query Push-Down | Yes | No |