Finding it's a data issue and that while Glue is defining the column as a timestamp and Athena can query it the structure of the data won't allow Redshift to read it. If the data is converted as a 'date' in Glue it comes through to Redshift without issue.