Gartner Research

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

Summary

Data warehouses evolved from specialized on-premises systems into simpler, but highly scalable, data appliances, then into the cloud. Data and analytics technical professionals will find the cloud variants suitable for most organizations. We evaluate cloud-based warehouses from Amazon and Microsoft.

Published: 11 June 2019

ID: G00377529

Analyst(s): Henry Cook Darryl Jamieson

Table Of Contents

Comparison

Analysis

  • Management of Large Volumes of Data
    • Amazon Redshift Support for Large Volumes
    • Microsoft Azure SQL Data Warehouse
  • Continuous Data Loading
    • Amazon Redshift and Continuous Loading
    • Microsoft Azure SQL Data Warehouse and Continuous Loading
  • Support for Queries on Multiple Data Types and Sources
    • Amazon Redshift and Data Type Support
    • Microsoft Azure SQL Data Warehouse and Data Type Support
  • Support for Advanced Analytics Queries
    • Amazon Redshift Support for Advanced Analytics
    • Microsoft Azure SQL Data Warehouse Support for Advanced Analytics
  • Support for Unstructured Data
    • Amazon Redshift and Unstructured Data
    • Microsoft Azure SQL Data Warehouse and Unstructured Data
  • Support for Operational and Real-Time BI Queries
    • Amazon Redshift and Operational and Real-Time BI Queries
    • Microsoft Azure SQL Data Warehouse and Operational and Real-Time BI Queries
  • System Availability
    • Amazon Redshift System Availability
    • Microsoft Azure SQL Data Warehouse System Availability
  • Support for Users of Differing Types and Skills
    • Amazon Redshift Support for Users of Differing Types and Skills
    • Microsoft Azure SQL Data Warehouse Support for Users of Differing Types and Skills
  • Administration and Management
    • Amazon Redshift Administration and Management
    • Microsoft Azure SQL Data Warehouse Administration and Management
  • Use-Case Suitability
    • Traditional Data Warehouse
    • Operational and Real-Time Data Warehouse
    • Context-Independent Data Warehouse
    • Logical Data Warehouse
  • Features and Capabilities
    • General Remarks
    • Support for SQL and Development
    • Amazon Redshift Features and Capabilities
    • Microsoft Azure SQL Data Warehouse Features and Capabilities

Guidance

Gartner Recommended Reading

Already a Gartner client?

Become a Client

This research is reserved for paying clients. Speak with a Gartner specialist to learn how you can access this research as a client, plus insights, advice and tools to help you achieve your goals.

Contact Information

All fields are required.

By clicking the "Submit" button, you are agreeing to the Gartner Terms of Use and Privacy Policy.

Experience Information Technology conferences

Join your peers for the unveiling of the latest insights at Gartner conferences.

©2021 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.