Postgresql, Redshift, Etl, Transformation, Data Warehouse.
Redshift. Use unnest only when you are sure you want to duplicate the whole row — or create a separate table with unnested values with a reference to the original table. enum types should be stored as varchar in Redshift. References Multi-byte Character Load Errors in Redshift ACCEPTINVCHARS in