Release Noteslink
April 2024link
We have fixed the behavior of our Google Drive connectors which prevented syncing files with the same names across different folders. Therefore, we upsert the entire file path in the _file
column. We now sync these files using the regular expression under the prefix (folder path) excluding the root folder name, in the File Pattern field. For more information, see our setup instructions.
November 2023link
We have improved the method to detect data ranges to sync in spreadsheets for our Google Drive connectors in the Magic Folder mode. We now sync the entire spreadsheet irrespective of data in the first column. Previously, we skipped the spreadsheet if we found an empty first column and synced rows only till the last non-null value of first column, and skipped the succeeding rows in the other columns.
October 2023link
Our Google Drive connector can now sync spreadsheets in Merge Mode. For more information, see our setup instructions. This feature is in beta and available to all customers. We will gradually roll out this feature to all existing connectors.
August 2023link
We have updated our sync strategy regarding the Excel files containing formula cells. We now sync the date values of the formula cell results as TIMESTAMP. Previously, we synced them as DOUBLE in our destination.
July 2023link
We have changed the default value of the JSON Delivery Mode feature to Packed in the connector setup form. Previously, we used Unpacked as the default value for this feature.
We now support syncing XML files to your destination in Merge Mode. 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 setup instructions.
We now support custom line separators for CSV files in Merge Mode. You can specify a custom line separator in the Line Separator field of the connector setup form. For more information, see our setup instructions.
We now support multi-character delimiters for CSV files in Merge Mode. You can specify a multi-character delimiter in the Delimiter field of the connector setup form. For more information, see our setup instructions.
We have renamed the Folder Path field in the connector setup form to Folder URL. For more information, see our setup instructions.
June 2023link
Our Google Drive connector can now sync packed JSON files in Merge Mode. 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 setup instructions.
August 2022link
We have added the Merge Mode functionality to our Google Drive connector. For connectors created after August 24, 2022, you can now opt to sync multiple files into a single table in your destination. In the connector setup form, select your sync strategy as Merge Mode or Magic Folder. For more information, see our setup instructions.
February 2022link
The Google Drive connector now supports syncing Google Sheets and Microsoft Excel spreadsheets to your destination. We sync each worksheet in the spreadsheet as a unique table in your destination. We are gradually rolling out this improvement to all our existing customers.
November 2021link
Our Google Drive connector is now generally available.
Read our Google Drive connector documentation.
October 2021link
You can now configure your Google Drive connector using the Fivetran REST API. This feature is available only for Standard, Enterprise, and Business Critical accounts.
March 2021link
Google Drive is a cloud-based file storage and synchronization service.