Azure SQL Data Warehouse is a cloud based data warehouse that enables in creating and delivering a data warehouse. Azure Data Warehouse is capable of processing large volumes of relational and non-relational data. It provides SQL data warehouse capabilities on top of a cloud computing platform. It has native support for SQL server and can easily migrate on premises SQL servers to SQL Data Warehouse as well use similar queries and constructs. Subscribers can instantly scale, pause and shrink their data warehouse resources.
It is used to deliver a complete enterprise class SQL based data warehouse solution. Some ways to use it includes;