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.


No comments: