sterling_paramore
09/02/2022, 4:07 PMis_sorted=True
in my Stream class. I would get a few dupes in stream, but that would just cause a do-nothing update in Snowflake and everything was fine.
However, without is_sorted=True
, my tap couldn’t recover from errors, which is a problem for larger tables. So I set that flag in the Stream class and now I have what seems like a new problem where Meltano sees records that come before the last replication key value (which is the full date-time) and interprets it as out-of-sort-order and raises an error.
Anyone have an elegant solution to work around this? I was thinking about trying to create a new column that was just the updated at date, without the time, but it’s not clear to me if that will work or just cause other issues.