Study guide

3.3 Encryption, Key Management & Tri-Secret Secure

SnowPro Advanced: Architect ARA-C01

Track your progress as you read

Finished sections get a check mark.

1 Introduction: The ARA-C01 Exam

About the SnowPro Advanced: Architect (ARA-C01) Exam

2 Chapter 1: Account Strategy & Organization Architecture

1.1 Multi-Account Strategy & Snowflake Organizations 1.2 Snowflake Parameter Hierarchy & Configuration 1.3 Database and Schema Design Architecture

3 Chapter 2: Identity, Access Control & Storage Integrations

2.1 Role-Based Access Control Architecture & Hierarchy 2.2 Secondary Roles, Object Ownership & Delegated Administration 2.3 Cloud Storage Integrations & IAM Trust Policies 2.4 Identity Federation, SSO, SCIM & Authentication Policies

4 Chapter 3: Governance, Data Privacy, Network Security & Compliance

3.1 Column-Level Masking & Row Access Policies 3.2 Object Tagging, Tag-Based Masking & Audit Governance 3.3 Encryption, Key Management & Tri-Secret Secure 3.4 Aggregation Policies, Projection Policies & External Tokenization 3.5 Network Policies, Network Rules, External Access & Private Connectivity 3.6 Snowflake Editions & Compliance Architecture (PCI DSS, PII & PHI)

5 Chapter 4: Data Modeling in Snowflake

4.1 Dimensional Modeling: Star vs. Snowflake Schemas 4.2 Data Vault 2.0 Architecture in Snowflake 4.3 Relational Constraints & Query Optimizer Integration

6 Chapter 5: Data Sharing & Collaboration Solutions

5.1 Direct Data Sharing Architecture & Security 5.2 Managed Reader Accounts for External Consumers 5.3 Snowflake Marketplace, Data Exchange & Clean Rooms

7 Chapter 6: Multi-Cloud, Multi-Region & Business Continuity

6.1 Database & Account Replication Mechanics 6.2 Disaster Recovery Architecture & Client Redirect 6.3 Cross-Cloud Auto-Fulfillment & Listing Replication 6.4 Data Protection: Time Travel, Fail-safe & Storage Costs

8 Chapter 7: Environments, Lakehouse, DevOps & AI/ML Applications

7.1 Multi-Tier Environment Strategy & Zero-Copy Cloning 7.2 Data Lakehouse Architecture & Apache Iceberg 7.3 DataOps, CI/CD & Snowflake Git Integration 7.4 AI/ML Pipelines & Applications: Cortex AI, ML Functions, Snowpark Container Services, Streamlit & Native Apps

9 Chapter 8: Data Ingestion Architecture

8.1 Bulk Ingestion Architecture: COPY INTO Optimization 8.2 Snowpipe Continuous Automated Ingestion 8.3 Snowpipe Streaming & Real-Time Ingestion 8.4 Data Unloading Architecture & Cloud Export Patterns 8.5 Schema Detection, Schema Evolution & Source-Change Architecture

10 Chapter 9: Continuous Pipelines & Stream Transformation

9.1 Change Data Capture (CDC) with Snowflake Streams 9.2 Task Orchestration, DAGs & Serverless Scheduling 9.3 Declarative Data Pipelines with Dynamic Tables 9.4 Views, Materialized Views & Transformation Table Design

11 Chapter 10: Semi-Structured Data & Ecosystem Tooling

10.1 Semi-Structured Data: VARIANT, OBJECT & ARRAY Processing 10.2 Snowflake Ecosystem Connectors, Drivers & SQL API 10.3 Snowpark, User-Defined Functions & Stored Procedures

12 Chapter 11: Virtual Warehouse Architecture & Concurrency

11.1 Virtual Warehouse Architecture, Sizing & Credit Economics 11.2 Multi-Cluster Warehouses & Concurrency Scaling Policies 11.3 Warehouse Types & Query Acceleration Service

13 Chapter 12: Query Profiling & Performance Diagnostics

12.1 Query Profile Deep-Dive & Bottleneck Analysis 12.2 Memory Spilling, Warehouse Queuing & Timeout Governance 12.3 Three-Tier Caching Architecture & Result Reuse

14 Chapter 13: Storage Optimization, Cost Governance & Observability

13.1 Micro-Partitioning & Automatic Clustering 13.2 Search Optimization Service (SOS) & Point Lookup Acceleration 13.3 Resource Monitors, Financial Governance & Usage Observability 13.4 Warehouse Monitoring, Alerts, Event Tables & Performance Explorer

3.3 Encryption, Key Management & Tri-Secret Secure

Key Takeaways Explain This Topic AI

Snowflake encrypts all data at rest with AES-256 using a hierarchical key model rooted in a cloud-provider HSM: root key, account master keys, table master keys, and file keys.

Tri-Secret Secure (Business Critical Edition or higher) combines a Snowflake-maintained key with a customer-managed key in the cloud provider's key management service to create a composite master key.

If Snowflake loses access to the customer-managed key, it can no longer decrypt the account's data, which gives the customer a cryptographic way to cut off access.

Snowflake-managed keys are rotated automatically when they are more than 30 days old (retired keys only decrypt); periodic rekeying (Enterprise Edition, PERIODIC_DATA_REKEYING = TRUE) re-encrypts data whose retired keys are older than one year.

Periodic rekeying is opt-in and not free: after rekeying, data encrypted with the old key is kept in Fail-safe for the standard period, which adds storage charges.

Last updated: September 2026

3.3 Encryption, Key Management & Tri-Secret Secure

Security in the Snowflake architecture operates as a defense-in-depth model spanning cryptographic storage protection, customer-controlled key governance, and network controls. For the SnowPro Advanced: Architect, mastering how Snowflake's hierarchical encryption model works and how it integrates with external cloud Key Management Services (KMS) is critical for designing compliant architectures. Network policies, network rules, and private connectivity are covered in Section 3.5.

Hierarchical Key Management in Snowflake

All customer data stored in Snowflake is encrypted by default at rest using AES-256 GCM (Galois/Counter Mode). Snowflake implements a hierarchical key model built upon the concept of envelope encryption , where higher-level keys encrypt lower-level keys. ┌──────────────────────────────────────────────┐

  • │ Tier 1: Snowflake Root Key │
  • │ (Hardware Security Module / Cloud Cloud-HSM) │
  • └──────────────────────┬───────────────────────┘
  • │ Encrypts
  • ▼
  • ┌──────────────────────────────────────────────┐
  • │ Tier 2: Account Master Key (AMK) │
  • │ (Unique per Snowflake Customer Account) │
  • └──────────────────────┬───────────────────────┘
  • │ Encrypts
  • ▼
  • ┌──────────────────────────────────────────────┐
  • │ Tier 3: Table Master Key (TMK) │
  • │ (Unique per Table / Data Object) │
  • └──────────────────────┬───────────────────────┘
  • │ Encrypts
  • ▼
  • ┌──────────────────────────────────────────────┐
  • │ Tier 4: File Keys │
  • │ (Unique per Micro-Partition File) │
  • └──────────────────────────────────────────────┘
  • The Four-Tier Encryption Hierarchy

Root Key (Tier 1) : Stored in a cloud-managed Hardware Security Module (HSM). It wraps and protects the Account Master Keys.

Account Master Key / AMK (Tier 2) : Unique to each Snowflake account. Protects all Table Master Keys within that specific customer account.

Table Master Key / TMK (Tier 3) : Unique to each table or database object. Protects the File Keys for all micro-partitions belonging to that table.

File Key (Tier 4) : Unique to each individual micro-partition file written to cloud storage (Amazon S3, Azure Blob, or Google Cloud Storage). Every single micro-partition file receives its own distinct cryptographic key.

Encryption in Transit

All network communication with Snowflake is encrypted in transit using TLS 1.2 or higher with modern, forward-secret cipher suites. This applies to:

Client-to-Snowflake connections (SnowSQL, Snowsight, JDBC/ODBC, Python Connector, REST SQL API).

Internal communication between Virtual Warehouse compute nodes.

Data movement between virtual warehouse compute nodes and underlying cloud object storage.

Tri-Secret Secure (Customer-Managed Keys)

In standard Snowflake accounts, all keys in the hierarchy are fully managed by Snowflake. For highly regulated industries (banking, healthcare, defense), Snowflake offers Tri-Secret Secure , which introduces a composite key model for the Account Master Key (AMK).

Composite Key Architecture

The name reflects three secrets that together protect access to data:

Snowflake-maintained key : managed inside Snowflake's key hierarchy.

Customer-managed key (CMK) : held in the customer's key management service in the same cloud platform that hosts the account:

  • AWS KMS
  • Azure Key Vault
  • Google Cloud KMS

User credentials : Snowflake authentication still controls who can query the data.

Snowflake combines the Snowflake-managed key and the customer-managed key using cryptographic key derivation to produce the composite Account Master Key (AMK) . Customer Cloud KMS Key Snowflake-Managed Key

  • (AWS KMS / Azure KV / GCP KMS) (Snowflake Security Enclave)
  • │ │
  • └────────────────────┬────────────────────┘
  • │
  • ▼
  • Composite Account Master Key (AMK)
  • │
  • ▼
  • Table Master Keys (TMK)
  • │
  • ▼
  • Micro-Partition File Keys
  • The Cryptographic Kill Switch

Because the customer-managed key lives in the customer's own key management service:

Key Revocation : If the customer disables the key or revokes Snowflake's permission to use it, Snowflake can no longer derive the composite master key, so the account's data can no longer be decrypted — including by Snowflake personnel.

Operations that need the data fail while the key is unavailable.

When access to the key is restored, operations can resume; the data itself was never deleted.

Architect caution: losing the customer-managed key permanently means losing access to the data, so key lifecycle and backup procedures in the cloud KMS become part of your recovery design.

Edition Prerequisite

Exam Fact : Tri-Secret Secure is strictly available only on Business Critical Edition or higher (including Virtual Private Snowflake). It is not available on Standard or Enterprise Editions.

Key Rotation vs Automated Annual Data Rekeying

A critical distinction on the ARA-C01 exam is the difference between rotating keys and rekeying data:

Process Frequency Mechanics Performance & Storage Impact

Key Rotation Automatic, when a Snowflake-managed key is more than 30 days old The active key is retired and a new key is created. New data is encrypted with the new key; the retired key is used only to decrypt data it protected. No data rewrite. Applies in every edition.

Periodic Rekeying Opt-in; data whose retired key is older than one year Snowflake creates a new key and re-encrypts the data protected by the old retired key, then destroys the old key. Enterprise Edition or higher. Enabled by ACCOUNTADMIN with ALTER ACCOUNT SET PERIODIC_DATA_REKEYING = TRUE; (default FALSE). Old-key data is kept in Fail-safe, which adds storage charges. -- Enable periodic rekeying for the account (Enterprise Edition or higher)

  • USE ROLE ACCOUNTADMIN;
  • ALTER ACCOUNT SET PERIODIC_DATA_REKEYING = TRUE;
  • Client-Side Encryption for Internal Stages

Files uploaded with PUT to internal stages are encrypted on the client before they leave the machine (Snowflake-managed client-side encryption), and remain encrypted at rest. External stages can use the cloud provider's server-side encryption (for example AWS_SSE_KMS ) or client-side encryption with a master key you supply in the stage definition.

Next: Network policies, network rules, external network access, and private connectivity are covered in Section 3.5 .

Loading diagram... Hierarchical Encryption and Tri-Secret Secure Key Derivation