Accounts and Security · Topic 9 of 17
Compliance, Editions, PCI and PII/PHI
Pick the right Snowflake edition for compliance: what Business Critical adds for PCI DSS, PHI and HIPAA, and how editions differ in security features.
- 5 min
- Standard has 1 day Time Travel; Enterprise and higher allow up to 90 days.
- Masking, row access policies, multi-cluster warehouses and periodic rekeying start at Enterprise.
- Tri-Secret Secure, private connectivity, failover and failback, and PCI DSS, HIPAA, HITRUST, FedRAMP and ITAR support start at Business Critical.
What it is
Compliance questions on the exam are edition questions in disguise. A scenario names a regulation, such as PCI DSS, HIPAA or FedRAMP, and asks which edition or which feature the Architect must choose.
Snowflake holds many third party certifications (SOC 1 and SOC 2 Type II, ISO 27001, PCI DSS, HITRUST CSF, FedRAMP, ITAR and more). Holding a certification does not make a customer compliant, though. Compliance is a shared responsibility: Snowflake secures the platform, and the customer must configure the account and handle data correctly.
How it works
Features by edition
Only the edition steps that matter for architecture questions are listed here.
| Capability | Standard | Enterprise | Business Critical | Virtual Private Snowflake |
|---|---|---|---|---|
| Time Travel maximum | 1 day | 90 days | 90 days | 90 days |
| Multi-cluster warehouses | No | Yes | Yes | Yes |
| Masking and row access policies | No | Yes | Yes | Yes |
| Periodic rekeying of data | No | Yes | Yes | Yes |
| Customer-managed keys (Tri-Secret Secure) | No | No | Yes | Yes |
| Private connectivity (PrivateLink, Private Link, Private Service Connect) | No | No | Yes | Yes |
| Failover and failback between accounts | No | No | Yes | Yes |
| PCI DSS, HIPAA and HITRUST support | No | No | Yes | Yes |
| FedRAMP and ITAR support | No | No | Yes | Yes |
| Dedicated metadata store and compute pool | No | No | No | Yes |
Business Critical is the compliance edition. Virtual Private Snowflake (VPS) contains everything in Business Critical and adds a separate Snowflake environment with its own metadata store and compute pool, for organizations with the strictest requirements such as some financial and government workloads.
Enterprise adds data governance (masking, row access, 90 day Time Travel). Business Critical adds regulated-data protection (customer-managed keys, private connectivity, failover, PCI and PHI support). Keep that split in mind.
PCI DSS
The Payment Card Industry Data Security Standard governs cardholder data. To store, process or transmit such data in Snowflake, the account must run on Business Critical or higher.
The customer still owns the controls inside its account. That typically means limiting who can see card numbers with masking policies and row access policies, restricting inbound access with network policies, and using private connectivity where the card environment must stay off the public internet. Another common pattern is to avoid storing full card numbers at all by tokenizing them before they reach Snowflake, using external tokenization with an external function.
PII and PHI
Personally identifiable information (PII) is any data that identifies a person. Protected health information (PHI) is health data covered by rules such as HIPAA.
For PHI the account needs Business Critical or higher, because HIPAA and HITRUST CSF support is available from that edition. The customer also needs the appropriate agreement with Snowflake for PHI workloads, and remains responsible for how the data is used.
Snowflake features then protect the data in the account.
| Need | Feature |
|---|---|
| Find sensitive columns | Data classification with tags |
| Hide values from most roles | Masking policies (column level security) |
| Limit rows per role | Row access policies |
| Prevent small groups from being exposed | Aggregation and projection policies |
| Keep keys under customer control | Tri-Secret Secure |
| Keep traffic private | Private connectivity plus a network policy |
Choosing the edition
Start from the strictest requirement in the scenario. If any requirement is on the Business Critical row of the table, the answer is Business Critical, even if every other requirement is met by Enterprise.
Choose VPS only when the scenario asks for a fully separate, dedicated Snowflake environment. Do not choose it just because the data is sensitive.
An edition can be upgraded but a feature that needs the higher edition is not available until the upgrade. A scenario that already runs on Standard and needs a masking policy therefore needs Enterprise first.
Common mistakes
Assuming a certification covers the customer. Certifications describe Snowflake's platform. The customer must still configure roles, policies, network access and key management.
Choosing Enterprise for PHI or PCI. Enterprise has strong governance features, but HIPAA, HITRUST and PCI DSS support start at Business Critical.
Choosing VPS by reflex. VPS is about isolation of the whole environment. If the scenario only needs customer-managed keys or private connectivity, Business Critical is enough.
Forgetting the private connectivity edition. AWS PrivateLink, Azure Private Link and Google Cloud Private Service Connect all need Business Critical or higher.
What to remember for the exam
- Standard has 1 day Time Travel; Enterprise and higher allow up to 90 days.
- Masking, row access policies, multi-cluster warehouses and periodic rekeying start at Enterprise.
- Tri-Secret Secure, private connectivity, failover and failback, and PCI DSS, HIPAA, HITRUST, FedRAMP and ITAR support start at Business Critical.
- VPS adds a dedicated metadata store and compute pool on top of Business Critical.
- Compliance is shared: the edition enables it, and the customer's policies and processes deliver it.
Check yourself
A company stores PHI and needs HIPAA support. What is the minimum edition?
Business Critical. Enterprise does not provide HIPAA and HITRUST support.
A Standard edition account must apply column masking to credit card numbers. What must the Architect do first?
Upgrade to Enterprise or higher, because masking policies are not available on Standard. For PCI DSS support the target is Business Critical.
When is VPS the right choice over Business Critical?
When the organization needs a fully separate Snowflake environment with a dedicated metadata store and compute pool. Needs like customer-managed keys alone are met by Business Critical.
Topic 9 of 17 in Accounts and Security
Test yourself on Accounts and Security
The full Snowflake ARA-C01 question bank has 687 questions, with timed practice exams and an explanation for every answer.
This study guide is independent and is not affiliated with, endorsed by, or sponsored by Snowflake. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.