December 2020link
We now support the PRIMARY KEY table constraint.
June 2020link
We have changed the way we load data from our Azure Blob Storage staging area into Azure Synapse. We now use COPY instead of PolyBase.
Using COPY instead of PolyBase improves data security. During a sync, the destination is now provided with limited and temporary access to only the files that need to be synced instead of the entire storage account. We are gradually rolling out this change to all existing customers.
March 2020link
We now convert INSTANT data type to DATETIMEOFFSET data type in the destination. Previously, we converted INSTANT data type to DATETIME2 data type.
We are making this change because the DATETIMEOFFSET datatype contains time zone information, which allows you to view the time zone in the destination if the source data type is INSTANT.
This functionality is enabled by default for new connectors created after March 25, 2020. Contact our Support Team to upgrade the INSTANT data type mapping to DATETIMEOFFSET for your existing connector.
December 2019link
Azure SQL Data Warehouse is now Azure Synapse.