Gartner Research

Comparing Cloud Data Warehouses: Amazon Redshift and Microsoft Azure SQL Data Warehouse

Published: 08 November 2016

ID: G00309107

Analyst(s): Henry Cook

Summary

Data warehouses evolved from specialized on-premises systems into simpler, but highly scalable, data appliances. Now they enter a new frontier — the cloud. This assessment evaluates cloud-based warehouses from Amazon and Microsoft to help technical professionals assess viability and suitability.

Table Of Contents

Comparison

Analysis

  • Manage Large Volumes of Data
    • Shared Nothing/MPP
    • Linear Scaling
    • Data Location and Skewing
    • Amazon Redshift Support for Large Volumes
    • Microsoft Azure SQL Data Warehouse
  • Loading Data Continuously
    • Attaching Partitions
    • Multiversion Concurrency Control
    • Amazon Redshift and Continuous Loading
    • Microsoft Azure SQL Data Warehouse and Continuous Loading
  • Other Data Types Beyond Structured
    • Amazon Redshift and Data Types Beyond Structured
    • Microsoft Azure SQL Data Warehouse and Data Types Beyond Structured
  • Repetitive Queries
    • Workload Management
    • Indexing, Partition Elimination and Zone Maps
    • Caching Optimization and Efficient Query Planning
    • Amazon Redshift Support for Repetitive Queries
    • Microsoft Azure SQL Data Warehouse Support for Repetitive Queries
  • Queries Support Advanced Analytics
    • Amazon Redshift Support for Advanced Analytics
    • Microsoft Azure SQL Data Warehouse Support for Advanced Analytics
  • Queries on Many Data Types/Sources
    • Amazon Redshift Many Data Types/Sources
    • Microsoft Azure SQL Data Warehouse Support for Many Data Types/Sources
  • Operational BI Queries
    • Amazon Redshift and Operational BI Queries
    • Microsoft Azure SQL Data Warehouse and Operational BI Queries
  • System Availability
    • Amazon Redshift System Availability
    • Microsoft Azure SQL Data Warehouse System Availability
  • User-Skill-Level Support
    • Amazon Redshift User-Type Support
    • Microsoft Azure SQL Data Warehouse User-Type Support
  • Administration and Management
    • Amazon Redshift Administration and Management
    • Microsoft Azure SQL Data Warehouse Admin and Management
  • Use Cases
    • Traditional Data Warehouse
    • Operational Data Warehouse
    • Context-Independent Data Warehouse
    • Logical Data Warehouse

Guidance

Gartner Recommended Reading

©2020 Gartner, Inc. and/or its affiliates. All rights reserved. Gartner is a registered trademark of Gartner, Inc. and its affiliates. This publication may not be reproduced or distributed in any form without Gartner’s prior written permission. It consists of the opinions of Gartner’s research organization, which should not be construed as statements of fact. While the information contained in this publication has been obtained from sources believed to be reliable, Gartner disclaims all warranties as to the accuracy, completeness or adequacy of such information. Although Gartner research may address legal and financial issues, Gartner does not provide legal or investment advice and its research should not be construed or used as such. Your access and use of this publication are governed by Gartner’s Usage Policy. Gartner prides itself on its reputation for independence and objectivity. Its research is produced independently by its research organization without input or influence from any third party. For further information, see Guiding Principles on Independence and Objectivity.

Already have a Gartner Account?

Become a client

Learn how to access this content as a Gartner client.