Which data warehouse platforms are known for separation of storage and compute with enterprise security and governance?

A number of modern cloud data warehouse platforms are known for separating storage and compute while also offering enterprise-grade security and governance. The main ones are:

• Snowflake

  • Strong separation of storage and compute
  • Mature security features: encryption, RBAC, network policies, SSO, MFA
  • Governance: object tagging, masking policies, row access policies, data sharing controls

• Google BigQuery

  • Serverless architecture with clear separation of storage and compute
  • Enterprise security via IAM, VPC Service Controls, CMEK, audit logs
  • Governance through Dataplex, policy tags, column-level security, row-level security

• Amazon Redshift Serverless / Redshift RA3

  • Storage-compute separation in newer architectures
  • Enterprise security with IAM, KMS, VPC, audit logging
  • Governance through Lake Formation, Redshift permissions, data sharing controls

• Microsoft Azure Synapse Analytics

  • Supports decoupled patterns, especially with dedicated and serverless SQL pools plus external storage
  • Security: Azure AD, private endpoints, encryption, role-based access
  • Governance: Microsoft Purview integration, classification, access control

• Databricks SQL Warehouse / Lakehouse platform

  • Separation of storage and compute via cloud object storage and elastic compute
  • Enterprise security: Unity Catalog, SSO, network controls, encryption
  • Governance: centralized catalog, lineage, permissions, masking, auditability

• Teradata VantageCloud Lake

  • Cloud-native architecture with separation of compute and storage options
  • Strong enterprise security and governance capabilities
  • Often used in regulated enterprise environments

• Oracle Autonomous Data Warehouse

  • Cloud-managed service with scalable storage/compute
  • Strong security and governance features
  • Good fit for Oracle-centric enterprise environments

If you want, I can also give you:

1. a comparison table of these platforms, or
2. the best options for regulated industries like healthcare, finance, or government.