❄️Snowflake

NEW

Also known as: Snowflake Data Cloud

A fully managed, cloud-native data platform offering elastic data warehousing and secure data sharing.

DESCRIPTION

Snowflake separates storage from compute, enabling elastic scaling and cost control. It provides ANSI SQL analytics, semi-structured data support, and secure data sharing across accounts. Multi-cluster warehouses handle concurrency without contention. As a managed service on AWS, Azure, and GCP, it simplifies operations and upgrades. Features include time travel, cloning, and marketplace data access. Governance tools integrate with role-based access control and masking policies. Snowflake underpins modern BI, ELT, and data applications in the cloud.

ALTERNATIVE DEFINITIONS

Snowflake Documentation

Snowflake is a fully managed service that provides a data warehouse that is faster, easier to use, and far more flexible than traditional data warehouse offerings.

Emphasizes managed service and advantages over traditional warehouses.

Source

Wikipedia

Snowflake Inc. is an American cloud computing–based data cloud company.

Describes the company behind the platform as a cloud-based data cloud provider.

Source

RELATED TERMS

Data Warehouse ELT Compute Scaling Data Sharing Secure Data Exchange SQL Cloud Storage

COMPETING TERMS

BigQuery Amazon Redshift Databricks

KNOWLEDGE AREAS

Cloud Data Warehousing & BI Data Engineering Data Services

TARGET AUDIENCE

Data Engineer BI Specialist Data Architect Cloud Architect Analytics Engineer AI Product Manager

EXTERNAL SOURCES

• Wikipedia - Snowflake Inc.
• Snowflake - Official product documentation
• Microsoft - Architecture overview on Azure
• Google Cloud - Partnership and deployment guidance

TOP QUESTIONS

What makes Snowflake cloud-native?

It separates storage and compute, runs on multiple clouds, and handles infrastructure, scaling, and upgrades automatically as a managed service.

Category: Concept

How does Snowflake handle semi-structured data?

VARIANT columns store JSON, XML, or Avro, with SQL functions for querying and flattening, enabling schema-on-read within SQL analytics.

Category: DataModeling

What is Snowflake’s data sharing capability?

Secure Data Sharing provides live, read-only access to data without copying, enabling marketplaces and cross-tenant collaboration.

Category: Feature

How does Snowflake compare to BigQuery?

Both are cloud-native. Snowflake offers multi-cloud and virtual warehouses for concurrency; BigQuery is serverless with per-query scaling and tight GCP integration.

Category: Comparison

What are common Snowflake cost controls?

Auto-suspend warehouses, size appropriately, use clustering/partitioning wisely, and monitor credits with resource monitors and usage dashboards.

Category: BestPractice

What is Time Travel in Snowflake?

Time Travel enables querying historical data for a retention window, supporting recovery and auditing use cases.

Category: Feature

How does Snowflake support governance?

Role-based access control, masking policies, row access policies, and object tagging integrate into a unified governance model.

Category: Governance

Is Snowflake suitable for data applications?

Yes; features like Snowpark and external functions enable building data-driven apps and ML workloads within the platform.

Category: Application

How is ELT implemented in Snowflake?

Load raw data into staging, then transform in-warehouse using SQL or Snowpark, leveraging elastic compute and scalable storage.

Category: Technique