❄️ Snowflake Platform Cheat Sheet (2026 June Edition)

Snowflake cheat sheet

1. Core Architecture

Separation of Storage & Compute — independent scaling of both layers

Cloud-Native Storage — micro-partitioning, columnar storage

Virtual Warehouses — compute clusters for SQL workloads

Multi-Cluster Warehouses — auto-scale for concurrency

Serverless Compute — Snowpipe, Tasks, Search Optimization, etc.

Time Travel — historical data access

Fail-safe — 7-day recovery window

Zero-Copy Cloning — instant, metadata-only clones

Data Retention Policies — table-level retention settings

2. Data Ingestion & Integration

Snowpipe — continuous ingestion

Snowpipe Streaming — low-latency streaming ingestion

COPY INTO — bulk loading

External Stages — S3, ADLS, GCS

Internal Stages — user, table, named stages

Storage Integrations — secure cloud storage access

Streams — change data capture (CDC)

Tasks — scheduled or continuous pipelines

Kafka Connector

Snowflake Connector for Spark

Partner ETL Integrations — Fivetran, Matillion, Informatica

3. Data Engineering & Processing

Snowpark — Python, Java, Scala

Snowpark Container Services — run containerized workloads

UDFs — SQL, JavaScript, Python

Stored Procedures — JavaScript, Python

External Functions — call external APIs

Search Optimization Service — index-like performance

Materialized Views

Dynamic Tables — declarative pipelines

Query Acceleration Service

4. Data Storage & Management

Databases / Schemas / Tables / Views

Temporary & Transient Tables

Secure Views

Secure Materialized Views

File Formats — JSON, Parquet, ORC, CSV

Stages — internal & external

Data Compression — automatic

Automatic Clustering

Hybrid Tables — transactional tables (Unistore)

Search Optimization

5. Data Sharing & Collaboration

Secure Data Sharing — cross-account, cross-cloud

Reader Accounts

Snowflake Marketplace

Private Data Exchange

Clean Rooms — privacy-preserving collaboration

Cross-Cloud Replication — data + metadata

Failover/Failback — business continuity

6. Security & Governance

Identity & Access

RBAC — roles, grants, privileges

ABAC — tags + policies

SCIM — automated provisioning

SSO — SAML, OAuth

MFA

Data Protection

Always-on Encryption

Tri-Secret Secure / BYOK

Network Policies — IP allowlists

PrivateLink / Private Connectivity

Masking Policies

Row Access Policies

Column-Level Security

Object Tagging — classification, sensitivity

Monitoring & Audit

ACCOUNT_USAGE Views

ORGANIZATION_USAGE Views

QUERY_HISTORY

ACCESS_HISTORY

LOGIN_HISTORY

DATA_TRANSFER_HISTORY

Resource Monitors

Event Tables — structured audit logs

7. Observability & Operations

Query Profile

Warehouse Monitoring

Cost Management Dashboard

Performance Optimization

Replication Monitoring

Task & Pipeline Monitoring

Alerts — SQL-based alerting

System-defined Functions for Observability

8. AI, ML & Advanced Analytics

Snowpark ML — training, inference

Feature Store

Model Registry

Cortex — LLMs, embeddings, vector search

Cortex Analyst — natural language to SQL

Cortex Search — semantic search

Vector Data Types

Python Worksheets

External Access Integrations — call external models

9. Application Development

Native App Framework — build & distribute apps

Snowpark Container Services — run microservices

API Integration — external functions

Event Tables — event-driven apps

Streamlit in Snowflake — embedded apps

Secrets Management

Logging & Telemetry for Apps

10. Unistore (Transactional + Analytical)

Hybrid Tables — OLTP-style tables

Point-in-time consistency

Transactional semantics

Unified analytical + transactional workloads

11. Data Science & BI Integrations

Power BI, Tableau, Looker, Qlik

Python/R Notebooks

Snowpark ML

ODBC/JDBC Drivers

Partner Integrations

12. Networking & Connectivity

PrivateLink (AWS/Azure/GCP)

External Functions

API Gateway Integrations

Network Policies

Proxy Support

13. Cost Optimization Features

Auto-Suspend / Auto-Resume

Multi-Cluster Scaling Policies

Resource Monitors

Search Optimization (optional)

Serverless Compute Cost Controls

Warehouse Utilization Views

14. Governance & Compliance

Object Tagging

Data Classification

Access History

Masking Policies

Row Access Policies

Compliance Certifications — SOC2, HIPAA, PCI, FedRAMP (depending on region)

15. Cross-Cloud & Multi-Region

Database Replication

Failover/Failback

Cross-Cloud Data Sharing

Org-level Resource Management

Global Account Management

Conclusion

Snowflake stands as a unified data platform that seamlessly integrates storage, compute, and services across clouds — empowering secure collaboration, advanced analytics, and AI-driven innovation. Its modular architecture and rich ecosystem of features make it a cornerstone for modern data engineering, governance, and intelligent application development.

This cheat sheet encapsulates Snowflake’s evolution from a cloud data warehouse to a full-fledged data cloud — bridging analytics, AI, and transactional workloads under one cohesive framework.