Result cache
The result cache is a Snowflake caching layer that returns the stored result of an identical query for 24 hours without using a virtual warehouse. It applies when the query and underlying data are unchanged, saving compute cost.
All COF-C03 Terms
Virtual warehouse
A virtual warehouse is a cluster of compute resources in Snowflake that executes queries, loads data, and performs DML.
Micro-partition
A micro-partition is the small, contiguous unit of storage (roughly 50-500 MB uncompressed) into which Snowflake automatically divides table data.
Time Travel
Time Travel is a Snowflake feature that lets you query, clone, or restore data as it existed at a point in the past within a defined retention period.
Fail-safe
Fail-safe is a non-configurable 7-day period after Time Travel during which Snowflake can recover historical data only through Snowflake support.
Zero-copy cloning
Zero-copy cloning is a Snowflake operation that creates a copy of a database, schema, or table without duplicating the underlying storage.
Stage
A stage is a Snowflake object that references a location where data files are stored for loading or unloading.
Snowpipe
Snowpipe is Snowflake's continuous, serverless data-ingestion service that loads files as soon as they arrive in a stage.
RBAC
RBAC (role-based access control) is Snowflake's security model in which privileges are granted to roles, and roles are granted to users or other roles.
Result cache
The result cache is a Snowflake caching layer that returns the stored result of an identical query for 24 hours without using a virtual warehouse.
Clustering key
A clustering key is a subset of columns that Snowflake uses to co-locate related rows in the same micro-partitions.
Secure data sharing
Secure data sharing is a Snowflake capability that provides live, read-only access to data across accounts without copying it.
Snowflake Marketplace
The Snowflake Marketplace is a platform where data providers publish listings that consumers can access through secure data sharing.
Snowsight
Snowsight is Snowflake's web interface for running queries, exploring data, and administering the account.
Cortex
Snowflake Cortex is the suite of AI and machine-learning features in the Snowflake AI Data Cloud.
Query Profile
The Query Profile is a Snowflake diagnostic view that shows the execution plan and per-operator statistics for a query.