# Data Exports: do delta exports overlap, and what is the recommended loading strategy?

**URL:** <https://community.shiphero.com/t/data-exports-do-delta-exports-overlap-and-what-is-the-recommended-loading-strategy/3799>\
**Category:** GraphQL API\
**Created:** [November 3, 2026, 12:58pm UTC](https://community.shiphero.com/t/data-exports-do-delta-exports-overlap-and-what-is-the-recommended-loading-strategy/3799 "2026-11-03T12:58:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![wewej99005](https://avatars.discourse-cdn.com/v4/letter/w/f19dbf/32.png) [@wewej99005](https://community.shiphero.com/u/wewej99005)\
**Post date:** [November 3, 2026, 12:58pm UTC](https://community.shiphero.com/t/data-exports-do-delta-exports-overlap-and-what-is-the-recommended-loading-strategy/3799/1 "2026-11-03T12:58:49Z")

</div>

Hello,

We are designing an ingestion pipeline that loads Data Exports into our data warehouse, and we would like to confirm how delta exports should be handled before we finalize it.

Specifically:

1. What time window does each delta export cover? Does it include only the changes since the previous delta, or a longer period?
2. We are evaluating the paid tier, where deltas run every 30 minutes. If each delta covers a longer window than that, consecutive deltas would contain overlapping records. Is that the expected behavior?
3. Given the above, what loading strategy do you recommend: appending each delta, or merging it into the existing tables?

Thank you in advance.

---

<div class="post-metadata">

**Author:** ![lpezza](https://avatars.discourse-cdn.com/v4/letter/l/439d5e/32.png) [@lpezza](https://community.shiphero.com/u/lpezza)\
**Post date:** [November 3, 2026, 1:19pm UTC](https://community.shiphero.com/t/data-exports-do-delta-exports-overlap-and-what-is-the-recommended-loading-strategy/3799/2 "2026-11-03T13:19:39Z")

</div>

Hi! I hope you are doing well!

Good catch, they do overlap. Each delta includes changes from up to 8 hours before the run, on both tiers. On the paid tier only the frequency changes, so consecutive 30-minute deltas cover a lot of the same window.

Our recommendation is to load them with an upsert by primary key rather than an append. That way a record that shows up in several deltas keeps its latest version instead of being duplicated.

More info here: [Data Exports | ShipHero GraphQL API](https://developer.shiphero.com/data-exports/#export-schedule-and-file-format)

Let us know how it goes!

Best regards,  
Luciano
