Best Practices for Row-Level Deletion in SQLMesh Projects

[SilasFriby]

Hi SQLMesh team,

I'm working on a project using SQLMesh and was wondering what the preferred method is for deleting specific rows (e.g., for a specific customer ID).

We’re building a GDPR-compliant deletion pipeline, and I'm currently considering writing a script that scans all physical tables across environments and deletes rows that match certain criteria.

Is that the right approach? Or is there a recommended “SQLMesh way” to handle row-level deletions?

Thank you in advance!

Best regards,
Silas