cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | Looking to expand your Alteryx skillset?! Check out the latest set of interactive lessons in Alteryx Academy: Creating Analytic Apps

Redshift Data Type - Columns defined as String

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. Please visit: http://roadtoinspire.alteryx.com and give stars!

Highlighted
Magnetar
Magnetar

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

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