Issue
A Segment Reverse ETL (rETL) sync completed successfully but returned fewer rows than expected. The SQL model in the data warehouse returns the correct number of rows, but the Segment sync does not extract all records.
Product
Twilio Segment
Environment
Segment Console
Cause
This issue can occur when the SQL model uses a rolling time window (such as filtering for records updated in the last 24 hours). If there is a delay or gap between sync schedules, records may age out of the view before Segment queries them, resulting in missing data during the sync.
Resolution
To recover missing records:
- Run a Reset Sync for the affected model in the Segment Console.
- Change the sync behavior to "Added and Updated" records to ensure all records are considered for syncing.
- If targeting a specific day, adjust the SQL model to include only the problematic date to avoid syncing duplicates.
- After the reset, monitor the next sync to confirm all expected records are exported.
Additional Information
Running a Reset Sync will treat all records as new or updated, which may result in duplicate records in the destination if not handled carefully. Review your model and destination settings before proceeding.