JDBC Sink Connector fails

I am trying to write a free from text from Kafka to Teradata database using JDBC connector. It fails with error java.sql.SQLException: [Teradata Database] [TeraJDBC 17.00.00.02] [Error 3798] [SQLState 42000] A column or character expression is larger than the max size.

I tried to change the teradata column to varchar max, long varchar, clob max but the input stream has length more that what teradata allows. Is it possible to chop this field or any workarounds?

Hi @Praveena

maybe an SMT might be helpful.

best,
michael