Witold
Databricks Partner

Depends on your logic. The source sends you a full load, this might mean that you need to reprocess everything, also in all downstream layers.

If the source only sends you a full load, because it's not capable of identifying changes then you should do CDC as early as possible. And usually a MERGE INTO with merge-conditions and update-conditions will help you.