We can now sync packed JSON files. We have added a new drop-down menu, JSON Delivery Mode, to the connector setup form. The drop-down menu provides you the option to choose how Fivetran should handle your JSON data. For more information, see our documentation.
We now support custom line separators for CSV files. You can specify a custom line separator in the Line Separator field of the connector setup form. For more information, see our documentation.
We now support multi-character delimiters for CSV files. You can specify a multi-character delimiter in the Delimiter field of the connector setup form. For more information, see our documentation.
We now support syncing PGP (Pretty Good Privacy) encrypted files. We have added a new advanced configuration, PGP Encryption Options, to the connector setup form. For more information, see our documentation.
We now support syncing XML files to your destination. We have added a new option, xml, to the File Type drop-down menu of the connector setup form. We load your XML data into the
_data column without flattening it. For more information, see our documentation.
We now sync the values of the error cells from the Microsoft Excel file instead of syncing the errors. This change applies to the Magic Folder connectors.
We sunset our Browser Upload feature. This feature was only available for Fivetran accounts created before April 9, 2021. You can use our File connectors to sync CSV files to your destination. For more information, see our What Are My Alternatives to the Browser Upload Feature FAQ page.
We have added support for the deprecated Parquet INT96 data type to support legacy parquet files that use INT96 data type for timestamps.
We now support syncing Microsoft Excel spreadsheets for the following Magic Folder connectors:
We are gradually rolling out this feature to all our existing customers.
We have added support for space (
\s) in the Delimiter field of your connector setup form. You can now use a single space as a delimiter.
We have released the beta version of Fivetran Magic Folder connectors. With Magic Folder connectors, you can sync multiple files from your cloud folder as unique tables to your destination. Magic Folder connectors are available for the following sources:
We have a fixed a bug that caused Int32 and Int64 values to sync incorrectly from Parquet files. Previously, our syncs did not include the scale of these values (for example, a value of
85.00 was loaded into the destination as
8500000). We now scale these values correctly. If any of your Int32 or Int64 values were incorrectly synced prior to this fix, you will need to initiate a re-sync to correct them.
We now support syncing headerless delimited format files (CSV, TSV, log) for the following file connectors:
We create generic column names for CSV files without a header line. Learn more in our Files connector documentation. This feature is in beta and available to all customers.
We now support
jsonl file extensions in all file connectors.
The following file connectors can now sync Parquet files:
We support Parquet format 2.4.0. This feature is in BETA.
Fivetran's incremental file update mechanism now re-syncs files that were created at the same time as the last observed cursor position.
We now support Avro files in all file replication connectors.
We now parse ISO DATE format (yyyy-mm-dd-hh:mm:ss) correctly.
If your file store contains an invalid .zip file, we will skip syncing it and issue a warning.