Postgresql, Redshift, Etl, Transformation, Data Warehouse.
write functions to remove these characters (or replace them with acceptable characters) before the data is loaded into Redshift, otherwise it will cause the loading job to fail. Removing Invalid Characters One of the range of characters not supported by Redshift is → 0xD800–0xDB7F : High Surrogates