There are two other ways to fix the issue. The first is to change the CSV delimiter. DMS lets you configure the delimiter on the S3 target endpoint via extra connection attributes. Swap the comma for a pipe or a tab (something that will never appear in your data) and embedded commas stop being a problem entirely. At the same time, it's hard to know which special characters may appear in the data.
Из Дубая в Москву вылетел первый с начала конфликта рейс Emirates02:15，推荐阅读体育直播获取更多信息
，推荐阅读17c 一起草官网获取更多信息
Фото: Majid Asgaripour / Reuters
Популярный рэпер не смог выступить в России из-за конфликта на Ближнем Востоке15:00，更多细节参见电影