---
title: "What Is Snowflake? Complete Guide to the Cloud Data Platform | Dawiso"
description: "Snowflake separates compute and storage in a multi-cluster shared-data architecture. Learn its layers, virtual warehouses, pricing, Cortex AI, and use cases."
url: "https://www.dawiso.com/glossary/snowflake"
language: "en"
---

May 7, 2026

snowflakecloud data platformdata warehousesnowflake architecturevirtual warehouse

# What Is Snowflake?

**Snowflake** is a cloud-native data platform built on a unique **multi-cluster shared-data architecture** that separates compute, storage, and metadata into independently scalable layers. Incorporated in 2012 and [listed on the New York Stock Exchange in September 2020](https://www.snowflake.com/news/snowflake-announces-closing-of-initial-public-offering-and-full-exercise-of-underwriters-option-to-purchase-additional-shares/), Snowflake helped make the decoupling of compute from storage a mainstream pattern in cloud data warehousing.

This guide explains how Snowflake works, why its architecture matters, what it costs, and where it fits alongside Databricks, BigQuery, and Microsoft Fabric in 2026.

TL;DR

**Snowflake** is a SaaS cloud data platform with three independent layers: **storage** (data on cloud object storage in proprietary columnar format), **compute** (multiple independently sized virtual warehouses), and **cloud services** (metadata, security, query optimization). Customers pay separately for storage and for compute, which is billed per second with a 60-second minimum each time a warehouse starts. Snowflake runs on AWS, Azure, and GCP and supports sharing and replication across regions and clouds. The platform now spans warehousing, data engineering, data sharing, applications, and AI through Snowflake Cortex.

## What Is Snowflake?

Snowflake is delivered as a fully managed service - there are no servers to provision, no clusters to size manually, no software to patch. Customers connect to a Snowflake account through a web UI, SQL clients, drivers, or the REST API. Behind the scenes, Snowflake runs on top of one or more public clouds (AWS, Azure, or GCP) but exposes a consistent SQL interface and operational model regardless of the underlying provider.

The product has expanded well beyond its origins as a SQL data warehouse. Snowflake today includes: a data marketplace, native applications, Snowpark (Python, Java, Scala for in-warehouse processing), Streamlit-based UI hosting, Snowflake Cortex (LLMs and ML), and Iceberg table support - alongside the original SQL warehouse.

## Architecture: Multi-Cluster Shared Data

Snowflake's signature design is the **three-layer architecture**. Each layer scales independently. This separation is what enables features like elastic compute, zero-copy cloning, and Time Travel.

### Why the architecture matters

In traditional MPP warehouses (Teradata, Netezza, on-prem Vertica) compute and storage are tightly coupled. Adding capacity means adding nodes that bring compute and storage together. Workload isolation requires copying data into a second cluster.

Snowflake's separation lets you:

- Spin up a new compute cluster (virtual warehouse) in seconds without copying data.
- Pay for compute only while warehouses run - warehouses can auto-suspend after an idle period you configure.
- Run multiple workloads (ETL, BI, data science) on the same data with different compute clusters that do not interfere with each other.
- Resize compute up or down with a single SQL command, without redistributing data.

## Virtual Warehouses Explained

A **virtual warehouse** is a compute cluster sized in T-shirt sizes: X-Small, Small, Medium, Large, X-Large, 2X-Large, up to 6X-Large. Each step doubles the [credit consumption rate](https://docs.snowflake.com/en/user-guide/warehouses-overview), from 1 credit per hour for X-Small to 512 for 6X-Large; 5X-Large and 6X-Large are generally available in AWS and Azure regions.

Virtual warehouses can be:

- **Auto-suspended** - stop after N minutes of inactivity. Storage costs continue but compute does not.
- **Auto-resumed** - resume on the next query. Snowflake describes [provisioning](https://docs.snowflake.com/en/user-guide/warehouses-considerations) as generally very fast, for example 1 or 2 seconds, though it can take longer.
- **Multi-cluster** - for high-concurrency workloads, spawn additional clusters of the same size as load increases. Used for BI workloads where many users query simultaneously. [Multi-cluster warehouses](https://docs.snowflake.com/en/user-guide/warehouses-multicluster) require Enterprise Edition or higher.
- **Scaled in seconds** - resize up or down with a single SQL `ALTER WAREHOUSE`. No data redistribution.

Most Snowflake customers run several virtual warehouses tuned to specific workloads - a large one for nightly ETL, a smaller multi-cluster one for BI, a separate one for ad-hoc analyst queries - to prevent workload contention.

## Storage Layer

Snowflake stores data in **micro-partitions**: immutable, automatically created units that each hold [between 50 MB and 500 MB of uncompressed data](https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions), stored compressed in columnar form. Snowflake's native format is proprietary and managed by Snowflake on the underlying cloud provider's object storage (S3, ADLS Gen2, GCS).

Three storage features stand out:

- **Time Travel** - query data as of any point within a configurable [retention window](https://docs.snowflake.com/en/user-guide/data-time-travel): 1 day by default, up to 1 day on Standard Edition and up to 90 days for permanent objects on Enterprise Edition and higher. `SELECT * FROM customers AT(TIMESTAMP => '2026-04-01 10:00:00')` returns the table as it existed at that moment.
- **Zero-copy cloning** - `CLONE` creates a new table, schema, or database that [shares micro-partitions with the original](https://docs.snowflake.com/en/user-guide/tables-storage-considerations), so the clone uses no additional storage until either side changes. Snowflake notes that [cloning is fast but not instantaneous](https://docs.snowflake.com/en/user-guide/object-clone) for large objects.
- **Continuous data protection** - a dropped object can be restored with `UNDROP` while it is still inside its Time Travel window. After that, a non-configurable 7-day [Fail-safe](https://docs.snowflake.com/en/user-guide/data-failsafe) period follows, from which only Snowflake can recover data, on a best-effort basis.

Since 2024, Snowflake has offered generally available **Apache Iceberg** tables: [tables in the open Iceberg format](https://docs.snowflake.com/en/user-guide/tables-iceberg) whose Parquet files can sit in customer-managed Amazon S3, Google Cloud Storage, or Azure storage through an external volume, with either Snowflake or an external catalog managing the table. This brings Snowflake closer to the open-lakehouse pattern also associated with Databricks.

## Cloud Services Layer

The cloud services layer is the brain of Snowflake. It coordinates everything that is not pure compute or storage:

- Metadata management - table schemas, statistics, micro-partition info.
- Query optimization and parsing.
- Authentication, authorization, and SSO integration with Microsoft Entra, Okta, etc.
- Transaction management - Snowflake supports ACID transactions.
- Security functions - encryption key management, network policies, dynamic data masking.
- Result caching - Snowflake [persists query results for 24 hours](https://docs.snowflake.com/en/user-guide/querying-persisted-results), a period that resets each time a result is reused, up to 31 days from the first run; an identical query can return the stored result without re-running while the underlying data is unchanged.

Cloud services usage is [billed only when its daily consumption exceeds 10%](https://docs.snowflake.com/en/user-guide/cost-understanding-compute) of that day's warehouse usage.

## Key Features

- **Snowpark** - write Python, Java, or Scala that runs inside Snowflake. Pandas-like DataFrames execute against the warehouse without data movement.
- **Streams & Tasks** - change-data-capture and lightweight orchestration native to the platform.
- **Dynamic Tables** - [tables that materialize the results of a query](https://docs.snowflake.com/en/user-guide/dynamic-tables-about) and refresh automatically to meet a target lag that sets how fresh the data must be.
- **Snowflake Marketplace** - curated data products from third-party providers, available without ETL.
- **Secure Data Sharing** - share live data with other Snowflake accounts (or via Reader Accounts) with [no data copied](https://docs.snowflake.com/en/user-guide/data-sharing-intro). A direct share works within one region; listings with cross-cloud auto-fulfillment reach consumers elsewhere. Often a deciding feature for B2B data exchange.
- **Native Apps** - package code, UI (Streamlit), and data into a distributable application that runs in a customer's Snowflake account.
- **Snowsight** - modern web UI for SQL, Streamlit dashboards, and data exploration.

## Snowflake vs Traditional Warehouses

Compared to legacy MPP warehouses (Teradata, Netezza) and earlier cloud warehouses (Redshift original architecture):

- **Elasticity** - Snowflake scales compute in seconds; traditional warehouses require resizing or migration projects.
- **Workload isolation** - multiple warehouses on the same data instead of contention or copies.
- **Less tuning** - no indexes to build, no statistics maintenance, no vacuum. Snowflake's optimizer and micro-partition pruning do most of the work, with clustering keys and search optimization available when needed.
- **SaaS operations** - no patching, no backup management, no DBA infrastructure work.
- **Pricing model** - usage-based by the second instead of fixed-capacity license.

The trade-off is reduced control. For standard tables you cannot pick the storage format or manually optimize physical layout (beyond clustering keys), and other engines cannot read the files directly; Iceberg tables are the route for data that has to stay open. For many organizations this is the right trade.

## Pricing Model

Snowflake separates two cost streams:

- **Storage** - billed monthly per TB on the average amount stored after compression, at a rate that depends on cloud, region, and whether it is bought on demand or as pre-paid capacity.
- **Compute** - billed in **credits**. An X-Small warehouse consumes 1 credit per hour, and larger warehouses consume credits in proportion to their size: a Medium = 4 credits/hour, a Large = 8, etc. Billing is per second, with a 60-second minimum each time a warehouse starts. The price of a credit depends on the [edition](https://docs.snowflake.com/en/user-guide/intro-editions) (Standard, Enterprise, Business Critical, or Virtual Private Snowflake), the cloud region, and the contract, and rises with the edition ([Snowflake cost overview](https://docs.snowflake.com/en/user-guide/cost-understanding-overall)).

The combination of per-second billing and auto-suspend means a well-managed Snowflake account often costs far less than the on-paper credit rate suggests - but ungoverned access to large warehouses is a common route to a surprise cloud bill. Resource monitors, query timeouts, and warehouse size limits are essential.

**Snowflake cost surprises usually come from one of three places.** First, oversized warehouses left on (a 4X-Large running 24/7 consumes 128 credits every hour, more than 3,000 credits a day). Second, query patterns that miss the result cache and scan large tables repeatedly. Third, unbounded compute for ad-hoc analyst access. All three are preventable with resource monitors and warehouse policies - but only if someone is watching.

## Snowflake Cortex AI

**Snowflake Cortex** is Snowflake's AI suite, integrated directly into the SQL surface. Highlights:

- **Cortex AI Functions** - call hosted LLMs via SQL with [functions such as AI_COMPLETE, AI_CLASSIFY, and AI_SUMMARIZE](https://docs.snowflake.com/en/user-guide/snowflake-cortex/aisql), over models from providers including OpenAI, Anthropic, Meta, Mistral AI, and DeepSeek: `SELECT AI_COMPLETE('model_name', prompt) FROM ...`.
- **Cortex Search** - managed retrieval over text columns; powers RAG patterns inside Snowflake.
- **Cortex Analyst** - natural-language to SQL over a semantic view that defines business concepts, metrics, and table relationships, intended for self-service analytics.
- **Cortex Agents** - orchestrated multi-step LLM workflows that combine tools, retrieval, and Cortex models.

Cortex's distinguishing feature is the data-residency story: Snowflake states that, unless you choose otherwise, [all AI models run inside its security and governance perimeter](https://docs.snowflake.com/en/guides-overview-ai-features). [Cross-region inference](https://docs.snowflake.com/en/user-guide/snowflake-cortex/cross-region-inference) is on by default for many accounts: the prompt and response can be processed transiently in another region while stored data stays in the account's region, so teams with residency requirements set `CORTEX_ENABLED_CROSS_REGION` explicitly. For customers in regulated industries, keeping inference inside Snowflake's perimeter, with the cross-region setting matched to their residency rules, is a meaningful differentiator over patterns that route data to external LLM providers.

## Common Use Cases

- **Enterprise data warehousing** - the original use case. SQL analytics over consolidated business data.
- **Multi-cloud analytics** - Snowflake [replicates data across regions and cloud platforms](https://docs.snowflake.com/en/user-guide/account-replication-intro) (AWS, Azure, and GCP); failover and failback require Business Critical Edition or higher.
- **Data sharing and B2B data exchange** - Secure Data Sharing eliminates the need to FTP files or stand up extract APIs.
- **SaaS application back-end** - Native Apps and Snowpark let ISVs ship analytical applications inside customers' Snowflake accounts.
- **Marketing analytics and customer 360** - high-cardinality joins across CRM, web analytics, and ad platforms.
- **Real-time pipelines** - Streams + Tasks + Dynamic Tables handle micro-batch CDC patterns; [Snowpipe Streaming](https://docs.snowflake.com/en/user-guide/snowpipe-streaming/data-load-snowpipe-streaming-overview) offers ingest-to-query latency as low as 5 seconds.
- **RAG and AI applications** - Cortex provides retrieval, models, and orchestration without data movement.

Snowflake's reach has expanded considerably since 2020. It is no longer "just" a warehouse - it is a data platform that competes with Databricks for ML workloads, with Microsoft Fabric for BI integration, and with cloud-native AI vendors for enterprise generative AI. The original architectural decision to separate compute and storage remains the foundation that makes all of it possible. Inside the platform, [Snowflake Horizon](https://docs.snowflake.com/en/user-guide/snowflake-horizon) groups governance such as sensitive-data classification, object tags, masking and row access policies, access history, lineage, and data-quality monitoring, several of them on Enterprise Edition or higher, and it is administered from within a Snowflake account. Dawiso's [Snowflake connector](https://help.dawiso.com/actual/snowflake/) brings Snowflake metadata into the same catalog as the rest of the data stack, where ownership, business definitions, and cross-platform lineage are documented; column-level lineage for Snowflake comes from SQL lineage parsing, enabled through Dawiso Customer Success, rather than from a native feed.

## Sources

- Snowflake - [Snowflake Announces Closing of Initial Public Offering](https://www.snowflake.com/news/snowflake-announces-closing-of-initial-public-offering-and-full-exercise-of-underwriters-option-to-purchase-additional-shares/)
- U.S. SEC - [Snowflake Inc. annual report: Organization and Description of Business](https://www.sec.gov/Archives/edgar/data/1640147/000164014721000073/R9.htm)
- Snowflake Documentation - [Snowflake editions](https://docs.snowflake.com/en/user-guide/intro-editions)
- Snowflake Documentation - [Understanding overall cost](https://docs.snowflake.com/en/user-guide/cost-understanding-overall)
- Snowflake Documentation - [Understanding compute cost](https://docs.snowflake.com/en/user-guide/cost-understanding-compute)
- Snowflake Documentation - [Overview of warehouses](https://docs.snowflake.com/en/user-guide/warehouses-overview)
- Snowflake Documentation - [Warehouse considerations](https://docs.snowflake.com/en/user-guide/warehouses-considerations)
- Snowflake Documentation - [Multi-cluster warehouses](https://docs.snowflake.com/en/user-guide/warehouses-multicluster)
- Snowflake Documentation - [Micro-partitions & Data Clustering](https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions)
- Snowflake Documentation - [Understanding & using Time Travel](https://docs.snowflake.com/en/user-guide/data-time-travel)
- Snowflake Documentation - [Understanding and viewing Fail-safe](https://docs.snowflake.com/en/user-guide/data-failsafe)
- Snowflake Documentation - [Data storage considerations](https://docs.snowflake.com/en/user-guide/tables-storage-considerations)
- Snowflake Documentation - [Cloning considerations](https://docs.snowflake.com/en/user-guide/object-clone)
- Snowflake Documentation - [Apache Iceberg tables](https://docs.snowflake.com/en/user-guide/tables-iceberg)
- Snowflake Documentation - [Using Persisted Query Results](https://docs.snowflake.com/en/user-guide/querying-persisted-results)
- Snowflake Documentation - [Dynamic tables](https://docs.snowflake.com/en/user-guide/dynamic-tables-about)
- Snowflake Documentation - [About Secure Data Sharing](https://docs.snowflake.com/en/user-guide/data-sharing-intro)
- Snowflake Documentation - [Introduction to replication and failover across multiple accounts](https://docs.snowflake.com/en/user-guide/account-replication-intro)
- Snowflake Documentation - [Snowpipe Streaming](https://docs.snowflake.com/en/user-guide/snowpipe-streaming/data-load-snowpipe-streaming-overview)
- Snowflake Documentation - [Snowflake Cortex AI Functions](https://docs.snowflake.com/en/user-guide/snowflake-cortex/aisql)
- Snowflake Documentation - [Snowflake AI and ML](https://docs.snowflake.com/en/guides-overview-ai-features)
- Snowflake Documentation - [Cross-region inference](https://docs.snowflake.com/en/user-guide/snowflake-cortex/cross-region-inference)
- Snowflake Documentation - [Snowflake Horizon Catalog](https://docs.snowflake.com/en/user-guide/snowflake-horizon)
- Dawiso Help - [Snowflake connector](https://help.dawiso.com/actual/snowflake/)

[See it in action](https://www.dawiso.com/product/data-catalog)

Data & Analytics Catalog

Create a unified view of your data assets and gain insights faster with automated data discovery.

### Table of contents

What Is Snowflake?Architecture: Multi-Cluster Shared DataVirtual Warehouses ExplainedStorage LayerCloud Services LayerKey FeaturesSnowflake vs Traditional WarehousesPricing ModelSnowflake Cortex AICommon Use CasesSources

## Related Terms

### [Context Layer for Snowflake & Horizon Catalog](https://www.dawiso.com/glossary/context-layer-for-snowflake)

A context layer gives Snowflake data the governed business meaning AI needs. Learn how it works with Snowflake Horizon Catalog and Cortex, and what spans beyond Snowflake.

Read more →

### [What Is the Snowflake MCP Server? Tools, Setup and Limits](https://www.dawiso.com/glossary/snowflake-mcp-server)

The Snowflake-managed MCP server gives AI agents Cortex Agents, Analyst, Search and SQL as MCP tools. Setup, OAuth, access control, limits and where it fits.

Read more →

### [Snowflake Pricing: Credits, Storage, and What You Actually Pay](https://www.dawiso.com/glossary/snowflake-pricing)

Snowflake bills per-second compute credits, storage separately, and more per credit at higher editions. Real cost scenarios and how to control spend.

Read more →

### [Databricks vs Snowflake - Which Data Platform is Right for You](https://www.dawiso.com/glossary/databricks-vs-snowflake-which-data-platform-is-right-for-you)

Compare Databricks and Snowflake: architecture, use cases, performance, and how to choose the right platform

Read more →

### [ETL vs ELT: What's the Difference and Which Should You Use?](https://www.dawiso.com/glossary/etl-elt)

ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) are the two dominant patterns for moving data between systems. Learn how they differ, when to use each, and why lineage and governance matter for both.

Read more →

### [What Is a Data Lakehouse?](https://www.dawiso.com/glossary/data-lakehouse)

A data lakehouse combines the low-cost storage of a data lake with the query performance and governance capabilities of a data warehouse. Learn how the lakehouse architecture works, who it's for, and what governance it requires.

Read more →
