DB Writer 'SQL Type' configuration of column character limitation

[dh]

In the legacy ‘Database Writer’ node, there was a SQL types tab which allowed for the designation of column character length - for instance varchar(1000)

With the new ‘DB Writer’ node, i’m not seeing a place where i can define the metadata of the table that i’m writing… this is creating an error when i run the node of ‘Data too long for column…’

I tried augmenting the Output Type Mapping tab to map a String value to the various options of varchar,longvarchar, etc… but i’m still seeing the same issue.

I could create the table on the DB side and preset the metadata, but i’d rather control this entirely from Knime and utilize the ‘remove existing table’ option.

Also, i’m writing to MySQL 8.0.

Are there any suggestions in this regard?

Thanks!
Dave

[MichaelRespondek]

You can use the DB Table Remover (option ‘Fail if table does not exists’ switched off) and DB Table Creator, where you can specify the column type as varchar(x), in a row with the DB Writer afterwards.

Best,
Michael