Alteryx automatically truncating text fields

[rdeshpande_123]

I am using Alteryx 2022.3 and using Connect -In DB tool to connect to Amazon Redshift using 64 Bit ODBC connection.

Alteryx is automatically truncating all text fields and returning only first character. If the text value is 'ABCDEFG' for example, I see on 'A' in the output.

Can somebody tell me why this is happening. Is there any setting I can configure to get rid of this issue?

[mceleavey]

Hi @rdeshpande_123 ,

can you please provide more information? Can you please show the input tool so we can see how it's configured?

M.

[rdeshpande_123]

Here are the connection details.

I used Connect in DB tool and connected to redshift, wrote a simple query and the output shows only first charactor

[rdeshpande_123 · Accepted solution]

This issue is resolved. The problem occurred because of old Redshift driver. I updated the driver and this issue is resolved now.

[jonriddle]

I'm using the Amazon Redshift ODBC Driver v2.0.0.1 (64-bit) and am seeing a similar problem, where all string fields are only returning the first character.  What version of the driver are you using that resolved this issue?

[whittenbergd]

For me the issue was that my target table in SQL Server had the columns defined as VARCHAR(MAX) and not NVARCHAR(MAX). 

Alteryx was using reading the Redshift data into fields defined as V_WString(65535).  I believe V_WString handles unicode characters but VARCHAR does not.  Simply redefining them as NVARCHAR resolved the problem for me.