Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

Redshift Data Type - Columns defined as String

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

I'm puzzled.  My ODBC connector for Redshift allows for Unicode characters.  When I copy data to my newly defined tables, they appear as STRING and fail on invalid ASCII character.

 

The tables appear with string, but the fields (prior to output) are V_WString.

 

What do you suggest?

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
15 - Aurora

Hi @MarqueeCrew,

 

If it has you stumped then I'm clearly out of my league in attempting a comment.  🙂

 

But with that said, check here: https://docs.aws.amazon.com/redshift/latest/mgmt/configure-odbc-options.html ... in particular the "UseUnicode" setting at the bottom of the page. Is that a setting you can find and tweak?

 

There may be additional ideas here: https://docs.aws.amazon.com/redshift/latest/dg/copy-parameters-data-conversion.html#acceptinvchars, which generally discusses data errors; in particular see the ENCODING setting... I'm not sure if we have access to that level of detail (e.g. starting here and reading forward: do we do that or is that already there behind the scenes? If we do it, then perhaps this is an avenue to pursue.)

 

Best of luck!

 - John

Highlighted
Alteryx
Alteryx

Hi @MarqueeCrew,


As @JohnJPS mentioned, ensure that your DSN is configured to use Unicode. Are you able to narrow it down to specific records, by chance? Does the same error occur if you only write the first record? Would it be possible to post sample data (without "PII") and a workflow that reproduces the issue? I'm unable to reproduce with some Unicode data and a V_WString column type using 2018.2.5 / Redshift ODBC driver v1.04.02.1010.

 

temp.png

 

Jerad Rades

Sr. Customer Support Engineer

Labels