Does Updating Deleted Data Impact Future Syncs?
Question
To anonymize deleted data, I want to run UPDATE statements on previously deleted records, marked as _fivetran_deleted = TRUE. Will this impact future syncs?
Environment
- Destination: Snowflake
- All database connectors
Answer
No, running UPDATE statements on records marked as _fivetran_deleted=TRUE in Snowflake won't impact future syncs. However, we recommend performing anonymization tasks when no syncs are actively running.