My ClickPipe fails with “change history start time is before allowed time travel interval”
APPENDS and CHANGES can only read changes within the source table’s time travel window, seven days by default. If the ClickPipe falls behind by more than that window, BigQuery no longer has the changes it needs. Resync the ClickPipe to unblock it.