Release Noteslink
July 2021link
We have implemented a new format (V2) for consistency in the destination configuration information. This format is valid for the following destinations:
For more information, see our V2 config format documentation.
December 2020link
We now support the PRIMARY KEY table constraint.
June 2020link
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 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.
March 2019link
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 warehouses before April 30. Not doing so will result in a connection failure.
Databases:
- MariaDB
- MongoDB
- MySQL
- Oracle
- PostgreSQL
- SQL Server
Warehouses:
- Redshift
- Azure Synapse
- Snowflake
If you don't use any of the above databases or warehouses with Fivetran, you don't need to take any action.