Azure SQL Data Warehouse: October 2015 update
Published date: 02 December, 2015
This post summarizes the new features released in Azure SQL Data Warehouse in October 2015. To read more, see the October update for Azure SQL Data Warehouse blog post.
- Parallelized data export - The addition of the CREATE EXTERNAL TABLE AS SELECT (CETAS) statement to bulk export data for cold data storage to Azure Blob Storage via PolyBase.
- Data load performance improvements - Additional CREATE STATISTICS options on external tables to improve performance for all external table operations. Also resource class management improves load times when connecting via BCP.
- Expanded function support - Support for functions in schemas other than the default (dbo).
- Additional improvements - Simplified syntax for creating a temporary table, added support for the sys.dm_exec_dms_services, sys.dm_exec_dms_workers, sys.dm_exec_external_work, and sys.dm_exec_external_operations DMVs, and improved error messages for data loading and other error conditions.