Hi all, I am using lever-tap and target-redshift a...
# troubleshooting
s
Hi all, I am using lever-tap and target-redshift and noticing a weird behaviour while this stream is running. This is my state.json:
{_"completed"_: {_"singer_state"_: {_"bookmarks"_: {_"candidates"_: {_"field"_: "updated_at", _"last_record"_: "2023-02-16T00:00:00Z"}, _"opportunities"_: {_"field"_: "updated_at", _"last_record"_: "2022-12-07T00:00:00+00:00", _"offset"_: "%5B1670399664493%2C%2205401428-695d-4da8-a807-2cde66d68b5f%22%5D", _"next_page"_: 1449}}}}, _"partial"_: {}}
My max(updated_at) record is stuck on a specific timestamp since last few weeks, but the overall count(*) is increasing. Earlier both were increasing together, but now I am not sure why there is this divergence ? is there anyway to debug this?