Redshift temp tables only exists for one session. Once the session times-out there is no other option other than re-creating it.