Postgresql, Redshift, Etl, Transformation, Data Warehouse.
the last resort will be using ACCEPTINVCHARS option while writing the data frame from the Glue Job to Redshift. Using that, the invalid character will be replace by the invalid character with a replacement character — this replacement character can also be specified by us. In case of a multi-byte