Scenario :
- The source is snowflake and it is in readonly mode.
- Implementing full load, saving maximum timestamp in databricks for incremental load.
- But in source side apart from record updates, records also being deleted and those records also need to be deleted from target(Databricks).
- Note: dont want to do full load on regular basis as it is not effective.
Any helpful tips with example ?