• Read
  • Discuss

Enterprises are using leading cloud providers including GCP, Microsoft Azure and AWS, with Snowflake integration, to build modern data warehouse solutions in the cloud.

All offer highly scalable and reliable data warehouse solutions but some differences in technical details and price models are listed in the table below.

SnowflakeAmazon RedShiftGoogle BigQueryAzureSynapse
ArchitectureHybrid (Shared Disk & Shared Nothing Architecture)Shared-nothing MPPMPPMPP
Database ModelRelationalRelational
Hybrid (Store Data in Columns, Support NoSQL as well)Relational
Data TypesStructured andSemi-StructuredStructured andSemi-StructuredStructured andSemi-StructuredStructured andSemi-Structured
In-memory CapabilityNoYesYesYes
MaintenanceFully-ManagedFully-ManagedFully-ManagedRequired somemanual maintenance
DeploymentCloud basedCloud basedCloud basedCloud-based
ScalabilityUsers can scalestorage andcomputeindependently,It automaticallyadds/removesnodes.Decoupled storage and compute withRA3 nodes.Storage and compute scale independently. Scaling is handled automatically by BigQuery.Serverless optionscales automatically. For the dedicatedoption, additionalstorage must beadded manually.
Analytics EcosystemSupport major Bland Data AnalyticToolsBusiness Intelligence with AWSQuicksight and Integration with other Bl toolsGoogle Workplace,Business intelligence  with LockerAzure ecosystems for analytics and PowerBI for business
Data Backup andRecoveryYesTesYesYes
CostPay for Storage and Compute TimeOn-demand or Reserved InstancesOn-demand andFlat-ratePay for Storage andCompute

Leave a Reply

Leave a Reply

Scroll to Top