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. Access is determined by the active role, and system-defined roles form a hierarchy such as SYSADMIN, SECURITYADMIN, and ACCOUNTADMIN.

Related Terms

Masking policyRow access policySecure data sharing

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.