Hey folks, just onboarding to the tool. Love how simple it is to get started. Can you confirm if this is best practice? 1. I have an orders table that gets updated if it changes, no updated_at field unfortunately. Should I use

full refresh - overwrite

, since I need the latest and greatest, and the primary key will not be enough as a cursor field? 2. I have an order_carts table that gets updated if there's a new event, with a created_at field. Existing rows will never be changed. In this case, I think I can use

incremental - append

, since it would just add the new fields since the last sync.

That seems right!

Thanks Davin! If choose CDC, will it be more efficient, since it can just look at what's been changed since the last sync? That's my main use case - dump replica to warehouse run my transformations. I skimmed the docs a few times but this is new to me.

Yes. Incremental does that via a primary key. CDC goes on step further and is also able to detect deletes.

I see. I was worried because I ran the full refresh yesterday and it was in the magnitude of hours, but incremental updates should be a lot speedier (mins/secs) now. Thanks again.

What do you mean by table constraints?

I had some primary and foreign key constraints on my table (source), but I don't see any once it was migrated over

Ah yes we only replicate data - constraints aren't moved over. Is this a blocker?