Release Notes

August 2023

We now support the XML data type in PostgreSQL destinations.

In existing tables, the STRING data types for XML will remain unaffected. We will create new tables and columns using the XML data type when the source supports it.

June 2023

We now support AWS PrivateLink for the following destinations:

• Amazon Aurora PostgreSQL
• Amazon RDS PostgreSQL
• Aurora MySQL
• MariaDB MySQL
• Amazon RDS for MariaDB MySQL
• MySQL
• Amazon RDS for MySQL
• PostgreSQL
• SQL Server
• Amazon RDS for SQL Server

We now support Azure Private Link for the following destinations:

• Azure Database for PostgreSQL
• Azure SQL Database
• Azure SQL Managed Instance

September 2022

In PostgreSQL destinations, we now drop the primary key constraints if the index row size exceeds the maximum index row size.

September 2020

We have added a new test in the PostgreSQL destination setup form to verify CREATE TEMPORARY TABLES permissions. When you set up your PostgreSQL destination, you must grant the fivetran user permission to create temporary tables in your PostgreSQL database. To learn how, see the setup guide for your PostgreSQL implementation:

• Generic PostgreSQL
• Amazon RDS
• Amazon Aurora PostgreSQL
• Google Cloud PostgreSQL

June 2020

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

November 2019

We now officially support Amazon Aurora PostgreSQL as one of our destinations.

Read our Amazon Aurora PostgreSQL documentation.

October 2018

For the following destinations, Fivetran now drops the primary_key field from existing tables in your destination if there is a primary_key coming in from your data source:

• MySQL
• PostgreSQL
• SQL Server
• Redshift