This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've searched for the embedded newlines errors and all the solutions are for an error once data has been pulled into a workflow. My issue is that I'm trying to pull a field from a table in Redshift that has about 1800 characters.
When I use the input data tool the data is truncated when it's pulled in. I've gone into the ODBC admin configuration and in data type optios changed the max varchar from 255 to 2000 and the max bytea to 2000. The max LongVarChar default was already at 8190.
When I run it, that field is being truncated to 237 characters still.
I'm sure this is a simple fix, but I can't seem to find it. Any help would be appreciated.