We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

ODBC Connection to RedShift Only Pulling First Letter from RedShift

JordyMicheal
11 - Bolide

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

 

12 REPLIES 12
goutdelete
8 - Asteroid

@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
20 - Arcturus

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

goutdelete
8 - Asteroid

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?

 

Snipaste_2024-02-12_14-33-25.png

Snipaste_2024-02-12_14-33-47.png

 

Thanks,

 

Labels
Top Solution Authors