Release Noteslink
August 2023link
We now support Redshift Serverless as a destination.
March 2023link
During UPDATE operations, we now insert null values for the VARBYTE columns that exceed 65535
bytes.
September 2022link
We have added support for the VARBYTE data type. For connectors created on or after September 01, 2022, we convert BINARY data type to VARBYTE data type in your Redshift destination. For connectors created before September 01, 2022, we will continue to convert BINARY to VARCHAR type.
AWS PrivateLink is now generally available for Redshift.
For more information, see our Redshift setup guide.
September 2021link
You can now use PrivateLink as a connection method for the following destinations:
This feature is in BETA and available only for Business Critical accounts.
We have added automatic cluster region detection to the Redshift setup form. We now use your Host details to detect the cluster region automatically. For example, during the destination setup, if you enter the Host as datalake-test-cluster.czqj8z4xxnzl.us-west-1.redshift.amazonaws.com
, we detect that the cluster region is us-west-1
. If we can auto-detect the cluster region successfully, the Cluster region field will not be visible in the setup form.
August 2021link
We have added support for the TIMESTAMP_TZ data type. For connectors created after August 30, 2021, we convert INSTANT data type to TIMESTAMP_TZ data type in your Redshift destination.
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.
We have added a new destination setup test. Now, we validate the cluster region you specify in the setup form. We skip the test if you don't select the cluster region.
June 2021link
We have added a new optional field, Cluster region, to the destination setup form. You can now choose the AWS Region of your S3 bucket. Fivetran will use the data staging bucket in the cluster region you select. If you use VPC security policies, you must select the same region as the Redshift cluster. If you do not specify the cluster region, we will use your data processing location as the cluster region.
We have added a new optional field, Cluster ID, to the destination setup form. If you authenticate using IAM and use an SSH tunnel to connect, you must enter the Cluster ID and the Cluster region.
We have added a new setup test to validate if you have provided the Cluster ID and Cluster region details in the setup form. We perform this test only if you use IAM authentication and an SSH tunnel to connect.
April 2021link
We now truncate LOCALDATETIME values to microsecond precision before we load them as TIMESTAMP values to your Redshift destination. For example, if we receive a LOCALDATETIME value 2021-02-01T15:24:47.1234567
, we truncate the value and write it to your destination as 2021-02-01T15:24:47.123456
.
January 2021link
You can now opt to use AWS IAM to authenticate Fivetran requests to your Redshift cluster. See our setup instructions for more information.
September 2020link
We have added a new test in the Redshift destination setup form to verify CREATE TEMPORARY TABLES permissions. When you set up your Redshift destination, you must grant the fivetran
user permission to create temporary tables in your Redshift warehouse. To learn how, see our Redshift setup guide.
June 2020link
We now replicate empty tables in a PostgreSQL source database as empty tables in the destination.
July 2019link
- Fivetran no longer performs
VACUUM DELETE
for your Redshift warehouses on the weekends, because Redshift now does it automatically. For more information on how Amazon Redshift schedules theVACUUM DELETE
operation, check out Amazon's changelog.
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.
October 2018link
For the following warehouses, Fivetran now drops the primary_key
field from existing tables in your warehouse if there is a primary_key
coming in from your data source:
- MySQL
- PostgreSQL
- SQL Server
- Redshift
July 2018link
We no longer sync system columns, such as oid
, to your Redshift warehouse.
April 2018link
We have changed the way we reclaim disk space from deleted rows. You can find additional details in our Redshift documentation.