Release Notes

August 2022

Fivetran history mode is now in beta for the following connectors:

Learn more in our .

March 2022

Fivetran Teleport Sync is now available in beta. Fivetran Teleport Sync is a proprietary database replication method that offers the completeness of snapshots while approaching the speed of log-based systems. Learn more in our .

June 2019

Fivetran no longer supports invalid Date, Datetime and Timestamp values. For example, 2019-00-01 00:00:00 is invalid. This change immediately affects all new MySQL connectors, and we will roll it out gradually to existing connectors.

The supported ranges of Date, Datetime and Timestamp in MySQL are:

Type	Supported Range
Date	'1000-01-01' to '9999-12-31'
Datetime	'1000-01-01 00:00:00' to '9999-12-31 23:59:59'
Timestamp	'1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC

We will load these invalid values as NULL into the destination and display a warning on your Fivetran dashboard. The warning will indicate the schemas, tables, and columns which contain NULL values.

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

Fivetran has added core support for a TIMESTAMP WITHOUT TIMEZONE type. Up until now, Fivetran assumed that timestamps without timezone were in UTC. This addition means databases with a TIMESTAMP WITHOUT TIMEZONE type - MySQL, Oracle, Postgres, SQL Server - will replicate to a more correct destination type. TIMESTAMP WITHOUT TIMEZONE support is immediately available for Oracle, Postgres, and SQL Server. MySQL / MariaDB support will be released soon.

Source	Applicable Type
Oracle	TIMESTAMP
Postgres	TIMESTAMP
SQL Server	DATETIME, DATETIME2, SMALLDATETIME
MySQL / MariaDB	DATETIME

This change is backwards compatible. Fivetran's core will continue assuming UTC time zone if the destination type is TIMESTAMP WITH TIMEZONE. In order to get the more specific type, drop the table in the destination and re-sync the table in your Fivetran dashboard.