Does Estuary have strict order guarantees to destinations?

[nthouliss]

Hi,

Apologies if this is the wrong place to ask this question. I've been experimenting with Estuary and I haven't found anything documented to say if events appear in the same order at the destination sink. For instance, if I am using a real-time stream from Postgres to DynamoDB will changes to the Postgres database appear in the same order on DynamoDB (so an update and delete to a row will appear in that order)?

If there isn't strict ordering guarantees is there some way of doing this with Estuary?

[dyaffe]

@nthouliss Estuary does have strict ordering guarantees. Once a backfill is completed, all data flows will be ordered and during a backfill, ordering will be guaranteed if you select "precise" backfill mode.

[nthouliss]

Thanks! If I connect a capture, have it backfill and then connect a destination will this still maintain order? I'm not sure if the precise backfill mode was selected when I created my capture but my destination has not been created yet. Is there anyway to check the backfill setting while it's backfilling? I don't want to change the backfill setting and then trigger another backfill by accident

[dyaffe]

Yes @nthouliss our backfills are ordered and materialization are too! There's only backfill settings on the source and you can select it when setting them up. The destination effectively always uses precise backfills.