17 February 2021

Enterprise Data Warehouses (EDWs): Economics, Deployment, and Maintenance

  • AWS Redshift: the size and quantity of the instances required to handle ingest and workload must be predicted. 
  • Microsoft Azure SQL DW: users must choose the cDWU rating that best meets their needs. 
  • Snowflake users must determine the mix of storage and the size of the virtual data warehouse that best suits the needs of each business unit as well as for a dedicated warehouse used for loading data.
  • BigQuery: customers do not have to plan and size the configuration to meet their needs. BigQuery is completely serverless and customers do not have to plan or adjust the supporting infrastructure.