Cascade FOREIGN KEYS in Redshift

Gotcha. I process records daily so thats why I wanted to delete records processed on certain day.

But you are right, we dont have etl_tstamp on context table. I ended up filtering using collector tstamp and root tstamp for events and context table.