Release Notes
July 2024
We now support version 10.11 of MariaDB. Learn more in MariaDB's Changes and Improvements in MariaDB 10.11 documentation.
All new MariaDB connectors now support Fivetran Teleport Sync for tables without primary keys. Learn more in our MariaDB Fivetran Teleport Sync documentation.
March 2024
Our MariaDB and MySQL connectors now support the TRUNCATE command.
August 2022
Fivetran history mode is now in beta for the following connectors:
Learn more in our history mode documentation.
March 2022
Fivetran Teleport Sync is now available in beta. Learn more in our Fivetran Teleport Sync for MariaDB documentation.
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 and MariaDB 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
Fivetran has added core support for the TIMESTAMP WITHOUT TIMEZONE data type. Up until now, Fivetran assumed that timestamps without timezone were in UTC. This addition means that for the following databases with a TIMESTAMP WITHOUT TIMEZONE type will replicate to a more correct destination type:
- MySQL
- Oracle
- PostgreSQL
- SQL Server
TIMESTAMP WITHOUT TIMEZONE support is immediately available for Oracle, PostgreSQL, and SQL Server. MySQL and MariaDB support will be released soon.
| Source | Applicable Type |
|---|---|
| Oracle | TIMESTAMP |
| PostgreSQL | TIMESTAMP |
| SQL Server | DATETIME, DATETIME2, SMALLDATETIME |
| MySQL and MariaDB | DATETIME |
This change is backwards compatible. Fivetran 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.
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.
February 2019
Azure Database for MariaDB is a MariaDB database service built on Microsoft's scalable cloud infrastructure for application developers.