# Snowflake

> Managed cloud data warehouse with separated storage and compute

Snowflake is a commercial cloud data platform offering elastic SQL warehouses, cross-account data sharing, and multi-cloud availability as a fully managed service.

Website: https://www.snowflake.com

## Use it when

- Operational simplicity is the priority: no infrastructure to run, warehouses that pause and resume, and scaling that is a size setting.
- Workload isolation matters; separate virtual warehouses for ETL, BI, and data science bill independently against one copy of the data.
- Data sharing across accounts and clouds is a first-class need; it runs on AWS, Azure, and Google Cloud.
- Snowpipe Streaming, semi-structured data, and managed Iceberg cover your ingestion and format needs without extra systems.

## Think twice when

- Cost discipline is weak; per-second credits with a 60-second minimum reward tuning and punish always-on warehouses, which is where most Snowflake bill stories start.
- Openness is the strategy; storage is proprietary micro-partitions (Iceberg support notwithstanding), where Databricks SQL keeps tables engine-neutral.
- The workload is high-QPS application serving; ClickHouse-shaped engines hold sub-second latency at concurrency more cheaply.

## How it runs

Fully managed across the three clouds: independent virtual warehouses (MPP compute) scale and pause per workload over shared storage; multi-cluster warehouses absorb concurrency automatically. Governance runs on a role hierarchy with masking and row-access policies under the Horizon catalog. Time travel is a day by default, up to 90 on Enterprise.

## Details

### General

| Attribute | Value |
| --- | --- |
| License | Commercial |
| Deployment | Managed |
| Operational complexity | Low |
| Pricing | Subscription |
| Documentation | https://docs.snowflake.com |

### Data Warehouses

| Attribute | Value |
| --- | --- |
| Where it runs | AWS, Azure and Google Cloud, across three geographic segments |
| Compute and storage | MPP, separated storage: compute is per-warehouse and independent |
| Storage format | Proprietary micro-partitions; managed and external Iceberg tables |
| SQL dialect | Snowflake SQL (ANSI-based) |
| Streaming ingest | Native: Snowpipe Streaming, seconds to queryable, including into managed Iceberg |
| Concurrent users | Multi-cluster warehouses auto-scale to a max cluster count, on a standard or economy policy |
| Acceleration | Automatic clustering, search optimization and materialized views; result cache and query acceleration |
| Billing unit | Credit-second per virtual warehouse, 60-second minimum; storage per TB-month |
| Time travel | 1 day; up to 90 days on Enterprise |
| Access control | Role hierarchy with row access and masking policies, tag-based policies; Horizon catalog and lineage |

## Capabilities

- [Data Warehouses](https://matca.io/capabilities/data-warehouse)

---

Source: https://matca.io/snowflake
Last updated: 2026-08-31T11:40:49.768Z