Release Notes

October 2024

Azure Synapse destinations now support the Hybrid Deployment model. We are gradually rolling out this feature to all existing destinations. For more information, see our setup guide.

December 2020

We now support the PRIMARY KEY table constraint.

June 2020

We now replicate empty tables in a PostgreSQL source database as empty tables in the destination.

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 connectors.

March 2020

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 2019

We have renamed Azure SQL Data Warehouse to Azure Synapse. This name change applies to the Fivetran dashboard and our documentation.

November 2019

Our Azure Synapse destination is now generally available.

Read our Azure Synapse destination documentation.

May 2019

Fivetran now truncates out of bounds DOUBLE values to fit within the minimum and maximum allowed values for Azure Synapse.

• DOUBLE with values greater than 1.79E+308 are truncated to 1.79E+308.

• DOUBLE with values less than -1.79E+308 are truncated to -1.79E+308.

March 2019

We are changing our architecture to allow for much higher data throughput. Starting on April 30, 2019, all Fivetran connectors will originate from a new set of fixed IP addresses. For the US region, these IPs are:

• 35.227.135.0/29
• 35.234.176.144/29
• 52.0.2.4/32.

Update your IP safelists for the following databases and destinations before April 30. Not doing so will result in a connection failure.

Databases:

• MariaDB
• MongoDB
• MySQL
• Oracle
• PostgreSQL
• SQL Server

Destinations:

• Redshift
• Azure Synapse
• Snowflake

If you don't use any of the above databases or destinations with Fivetran, you don't need to take any action.

July 2018

We now support Azure Synapse.