Snowflake Paid

Cloud data warehouse with separated storage and compute

Snowflake is a cloud data warehouse where storage and computing are billed separately. You load data once, then spin up warehouses of different sizes against it – and because compute bills per second, a query that runs for 40 seconds costs 40 seconds.

What is Snowflake?

It is a SQL data platform that runs on AWS, Azure or Google Cloud but manages its own storage layer, so you are not locked to one cloud’s file format. Analysts query with normal SQL; the engine handles concurrency by assigning separate compute clusters per workload.

Snowflake went public in 2020 and reported more than 12,000 customers by 2025. Cortex, its AI layer, adds functions like SENTIMENT, SUMMARIZE and COMPLETE that run inside SQL – which means an analyst can summarize 50,000 support tickets without leaving a worksheet.

Product Features

  • Separated storage and compute. Add a warehouse for the data science team without copying data or doubling storage costs.
  • Per-second billing. Warehouses bill per second with a 60-second minimum when resumed; auto-suspend after 60 seconds idle is the default.
  • Time Travel. Query data as it existed up to 90 days ago on Enterprise edition, and restore dropped tables.
  • Zero-copy clones. Clone a 10TB schema instantly for a dev environment at storage-delta cost only.
  • Cortex AI functions. SQL-callable LLM and ML functions for summarization, sentiment, classification and forecasting.
  • Snowpark. Run Python, Java or Scala inside the platform rather than extracting data to a separate cluster.

Product Highlights

  • No infrastructure to tune – warehouses are sized in credits, not servers.
  • Works across AWS, Azure and GCP with one governance model.
  • Cortex puts LLM calls directly into SQL.
  • Time Travel and cloning make recovery and experimentation cheap.

How much does Snowflake cost?

Credits, not dollars. Compute is priced per credit, roughly $2 to $4 depending on cloud and region; an X-Small warehouse burns one credit per hour, so an hour of small-warehouse compute sits near $3. Storage runs about $23 per terabyte per month on-demand, less with upfront capacity.

The failure mode is well documented: an oversized warehouse left running, or a dashboard that refreshes every five minutes against a Large warehouse, can burn thousands a month. Set resource monitors and statement timeouts on day one. Cortex LLM calls bill per token on top of compute.

Who is Snowflake for?

Best for companies past the point where a single Postgres instance chokes – typically 50GB to petabytes, with a mix of BI dashboards, data science and ad-hoc analysis hitting the same tables. Mid-market and enterprise teams with a data engineer on staff get the most out of it.

Not for a 20-person startup with 2GB of transactional data; a managed Postgres or BigQuery free tier is cheaper and simpler. Also a poor fit if your team has zero SQL skill – nothing here replaces an analyst.

Use cases

  1. Consolidating billing, CRM and product data for BI dashboards.
  2. Running Cortex sentiment analysis on support tickets in SQL.
  3. Cloning production data for a machine learning experiment.
  4. Recovering a table a developer dropped yesterday with Time Travel.
  5. Giving finance a separate warehouse so month-end runs stop blocking analysts.

Quick Summary

  • Snowflake is a cloud data warehouse with separated storage and compute.
  • Compute bills per credit, roughly $2-4 each; an X-Small warehouse burns one credit an hour.
  • Storage costs about $23 per TB per month on-demand.
  • Cortex adds SQL-callable LLM functions for summarization and sentiment.
  • Best for teams with 50GB+ of analytics data and a data engineer; overkill for small startups.