ODBC Connection to RedShift Only Pulling First Letter from RedShift

JordyMicheal

Hey all!

Have an issue on 2022.1 that when I query RedShift that fields stored as strings only bring back the first character.

IE: The field might be A4234523482379429 and it would only return A.

Things stored as Ints work just fine though.

Any ideas?

Thanks,

Jordan

Database Connection

Accepted answers

apathetichell

Are you running the driver from Amazon or the Redshift driver from Alteryx? I had this with one of the drivers I downloaded from Amazon and swapped over to the Alteryx certified driver and that fixed it. I'm on the Simba Amazon Redshift 1.4.56.1000. Check to see if your .msi file is AmazonRedshiftODBC...or Simba Amazon Redshift...

Note - I'm also running 21.4 on this system...

All comments

kathleenmonks

Hi @JordyMicheal,

Any chance your driver is configured to truncate strings? If you go into the advanced options for your ODBC data sources, you can find the setting. See the below screenshot as an example:

jonriddle

I'm seeing similar results. For the Redshift ODBC Driver, I am not seeing a default string column length option in ODBC data sources. @JordyMicheal , were you able to resolve this problem?

deangewa

Running into a similar issue. Was anyone able to resolve this issue? Connection/workflow was working fine. I upgraded designer to 2022.3.1 Patch 2 and workflow stopped working. I just installed version Version: 2022.1.1.42619 and still returning just the first character of strings.

Very frustrating.

apathetichell

Note - I'm also running 21.4 on this system...

deangewa

Thank You! Downloaded the Simba driver and problem is now reoslved.

August

I had a similar issue and solved it by using the Amazon Redshift 64 bit driver version 1.04.10.1000

apathetichell

@August - can you confirm its the SIMBA driver? can you share a screenshot of your odbc 64?

August

We resolved the Alteryx string field truncation issue by using the Amazon Redshift 64 Bit ODBC driver version 1.04.10.1000 to 1.04.62.1000. The Simba driver worked as well but our DBA'S didn't want to use it on the Gallery.

apathetichell

Curiously it appears that Amazon has two different Redshift ODBC drivers with two different numbering systems?

https://docs.aws.amazon.com/redshift/latest/mgmt/configure-odbc-connection.html

https://docs.aws.amazon.com/redshift/latest/mgmt/odbc20-install-config-win.html

One is published by Amazon Web Services, Inc. and the other by Amazon Inc. Now I'm curious.

goutdelete

@apathetichell and @deangewa,

Just want to confirm if this is the one you mentioned? Redshift ODBC & JDBC Drivers - Simba - insightsoftware

(also so it's not a free driver?)

Thanks!

apathetichell

Use the one available here - https://us1.alteryxcloud.com/license-portal/ in drivers.

goutdelete

Thanks @apathetichell

Just want to confirm if this is right.. It didn't say "Simba" and why the "previous version" is actually later than the current version?

Thanks,

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335