Hi Community,
To improve sheet and Data Shuttle performance, we are changing how Data Shuttle “replace mode” upload workflows function.
Instead of completely deleting and replacing all rows on a sheet, replace mode workflows will now:
- Scan the source data until it detects a change in the data set.
- From that row onwards, Data Shuttle will perform a replacement of all data.
- If no change is detected between the source and target dataset, no rows will be processed.
- If a change is detected on row 1, the dataset will be replaced from row 1.
- If a change is detected in row 99 of 100, only rows 99 and 100 will be processed.
This change will reduce the number of rows impacted when a Data Shuttle workflow runs, while still giving you the same accuracy of results.
As a note, if the source sheet has been reordered since the last workflow run, all rows will be replaced. Replace mode workflows don’t consider row IDs; instead, they compare the source data and ensure a complete match with the target.
Additionally, this will impact the behavior of cell history as only the rows replaced will show as changed in the cell history, instead of all rows on the sheet, which could impact any sheet automations that run based on cell updates.
You can learn more about Data Shuttle upload workflows here.
Data Shuttle is available for users on the Business plan, Enterprise plan, and/or Advance Silver/Gold/Platinum users. Learn more about Data Shuttle here.
You can also stay informed by subscribing to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a daily email with news of what's released. (Emails will only send daily, Monday-Friday, as new releases are available).
Best,
Danielle Wilson
Product Marketing Manager