events_detailed stream missing lookback_window causes 0-record syncs #70341
Description
Connector Name
source-klaviyo
Connector Version
2.16.8
What step the error happened?
During the sync
Relevant information
The events_detailed stream intermittently syncs 0 records because it lacks the lookback_window state management that other Klaviyo streams have. When the cursor advances to a future timestamp, subsequent syncs request data that doesn't exist yet.
Evidence
Working streams have lookback protection:
{
"name": "campaigns_detailed",
"streamState": {
"lookback_window": 7,
"updated_at": "2025-12-03T22:35:08+0000"
}
}
events_detailed lacks this feature:
{
"name": "events_detailed",
"streamState": {
"datetime": "2025-12-04T20:42:53+0000"
}
}
The Problem
- Successful sync at
2025-12-04 01:58:40 UTCpulls 89,316 records - Cursor advances to
2025-12-04T20:42:53+0000(18 hours in the future) - Next sync at
2025-12-04 07:57:51 UTCasks for events >20:42:53 - Klaviyo returns 0 records (cursor is still 12+ hours in the future)
- Sync completes with 0 bytes transferred
Root Cause
Klaviyo events can have datetime values ahead of real-time (scheduled campaigns, timezone handling). Other streams handle this with lookback_window, but events_detailed doesn't.
Reproduction
Configure events_detailed for incremental sync (4x daily schedule)
Observe ~25% of syncs return 0 records
Check connection state - cursor will be in the future
Expected Behavior
events_detailed should have lookback_window like other streams to handle future-dated events.
Workaround
Manually reset cursor backwards 2-3 days in connection state.
Environment
Airbyte Cloud
Sync mode: Incremental | Dedupe
Frequency: 4x daily
Relevant log output
**0-record sync completes instantly:**
2025-12-02 19:58:53 info Read 0 records from events_detailed stream
2025-12-02 19:58:53 info Marking stream events_detailed as STOPPED
**Working sync processes normally:**
2025-12-04 01:58:56 info Records read: 5000 (9 MB)
2025-12-04 02:05:08 info Read 89316 records from events_detailed streamContribute
- Yes, I want to contribute