Release Notes
September 2024
We now restrict API users from triggering File connectors to sync if:
- the
append_file_optionfield has its value set toupsert_file_with_primary_keys - and the primary keys are not defined in the schema configuration
We also restrict the following actions for such connectors:
- Creating a new connector in an un-paused state via API;
- Updating the connector's
pausedfield tofalsevia API request; - Forcing the connector sync or re-sync via API request.
August 2024
We now support a new authentication method, OAuth2.0, for our Google Drive connector. Previously, we supported only service account authentication. To support this enhancement, we have added a new field, Authentication Method, to the connector setup form that allows you to choose the authentication method. This field has the following options:
- Authorize with User account: Select this option to authenticate your Google Drive connectors using OAuth 2.0.
- Authorize Service Account: Select this option if you want to authenticate using service account. This option is selected by default in the connector setup form.
You can opt to migrate your existing connector to Authorize with User account authentication method. For more information, see our setup instructions. We are gradually rolling out this feature to all existing connectors.
July 2024
We have added a new configuration option, Primary Key used for file process and load, in the connector setup form to support syncing files with custom primary keys. You can now select the custom primary keys during the connector configuration and use them to update or insert new rows in your destination. We process the most recently modified files to your destination. For more information, see our setup instructions.
April 2024
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 2023
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 2023
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 connectors. We will gradually roll out this feature to all existing connectors.
August 2023
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 2023
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 2023
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 2022
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 2022
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 connectors.
November 2021
Our Google Drive connector is now generally available.
Read our Google Drive connector documentation.
October 2021
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 2021
Google Drive is a cloud-based file storage and synchronization service.