I loaded up a Designer workflow that I used without issue last quarter, and found that all six of the Dynamic Input tools I use to bring in data from the Amazon Redshift datalake now output only the first character of every varchar-type field. Numerics and dates come through just fine, but every single string gets cut short.
Switching the Dynamic Input to a regular Input tool with a hardcoded query returns the same one-character-only result. However, accessing Redshift via SQL Workbench and running the same query produces the table I expect, with its string fields intact and labeled varchar(255). The weirdest part is, when I look at the metadata in Alteryx, the type is V_String and size is listed as 255 as expected, even though what it's actually giving me is size 1.
What could possibly be causing this to happen? I've checked every tool setting I know of and can't figure it out. Any help would be greatly appreciated.
