Azure SQL Data Warehouseis Microsoft’s SQL analytics platform, the backbone of your Enterprise Data Warehouse. The service is designed to allow customers to elastically (and independently) scale compute and storage with massively parallel processing. SQL DW integrates seamlessly with big data stores and acts as a hub to your data marts and cubes for an optimized and tailored performance of your EDW. Azure SQL DW offers guaranteed99.9% high availability, compliance,advanced security, andtight integrationwith upstream and downstream services so you can build a data warehouse that fits your needs. Azure SQL DW is the first and only service enabling enterprises to replicate their data everywhere with global availability in more than 30 regions. Today, we will show you how to push data quickly into Azure Analysis Services for optimized performance.
Benefits of using Azure Analysis Service with SQL DW
Several great benefits exist when leveraging Azure Analysis Services (AAS) with SQL DW:
Fewer to no queued queries while increasing the overall solution concurrency
Improved short query read performance with AAS as a caching layer
Reduce overall solution cost by lowering DWU levels for SQL DW with query offloading