Automate schema adjustment should the job fail because of Data Truncation: Data too long error
My & my team work with text data, using MySQL db, and very often we run into the error related to Data Truncation: Data too long for column XYZ
By default, DSS is using varchar(500) as default for writing strings to MySQL:
then I get an error specifying the problem and the column name
I go into settings->advanced and change the schema to text or longtext
I run again and it works fine, Job succeeded
Apparently, DSS is aware of the error type and also the field name, so from my point of view, it should be able to adjust the schema by itself from varchar(500) to text or longtext and load the data again without human intervention. It would save us loads of time to have this automated fix of schema implemented.