Best practices for working with Azure SQL Data Warehouse

Following the recommended best practices for working with Azure SQL Data Warehouse will ensure that your applications experience excellent performance and that your users will have a positive experience.

Reduce costs by scaling up and down

Because Azure SQL Data Warehouse separates storage from compute resources, scaling compute to meet performance and availability demands independently from data storage allows you to optimize your data warehouse workloads for maximum cost savings. If you don't need to use your data warehouse during a specific time frame, you can save compute costs by pausing compute resources.

Note

To learn more about scale-out steps, view the following documentation on managing compute: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-manage-compute-overview.

Use PolyBase to load data quickly

SQL Data Warehouse supports loading and exporting data using...