Hi @iain,
At least with non-derived data I’d go with re-processing enriched events archive.
Enriched archive is our ultimate source of truth and different storage targets apply own appropriate transformations before loading, which means in Snowflake enriched data structured in a very different way. Thus it would take a lot of efforts (or probably even impossible) to transform data unloaded from Redshift into Snowflake.