AS time goes by and the backup table become larger how will this scale ? Should there be a date cutoff on the Exists clause in the inserts ?
How would this affect sort and dist keys in the create table statements (which I notice do not exist here)?
I also notice you specify compression encodings to each column, where AWS recommends leaving that to the engine unless you have a good reason to override this.
----------------------------------------------------