MyAlteryx
Community
Academy
Help Docs

Welcome to the Alteryx Knowledge Base

Knowledge Base / Designer / When querying Redshift data with ODBC Connection using Redshift driver from Amazon, Designer is...
When querying Redshift data with ODBC Connection using Redshift driver from Amazon, Designer is only showing the first letter for the string fields.
user

Created/Edited - 12/6/2024 by Nora Tobon | Alteryx

Summary
Article-5382
Description
When connecting to RedShift to pull data into the Input Data tool, Designer only bring back the first character of fields stored as strings.

Example:

Table - Data:

Designer shows:
 
Issue
When I query RedShift table the data is getting truncated to show only one character values.
Environment
  • Alteryx Designer
    • Version(s): All
  • Driver
    • Amazon Redshift ODBC Driver

 

Cause

Redshift ODBC Driver compatibility.

Resolution

Issue is not observed with certified Simba driver. Download it from the Amazon Redshift and try again.

Was this article helpful?