db.copy_files_to_redshift not convert Athena TINYINT 

Using copy_files_to_redshift does not convert Athena TINYINT to appropriate data type

CREATE TABLE IF NOT EXISTS clean_data.fact_Data
  WITH (format='PARQUET',
        parquet_compression='SNAPPY',
        partitioned_by = ARRAY['environmentid']
        ) 
  AS
  select 
        cast (environmentid as TINYINT  ) as environmentid 

