We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Defect GCSE-687: Data Returned by Databricks Query on Long Text Fields Truncates to 254 Characters

londonhanson
Alteryx
Alteryx
Created

Databricks: Long Text Fields are Truncated to 254 Characters

 

Environment Details

 

When connecting to Databricks and querying long text fields, the data being returned is truncated to 256 characters.
 

  • Alteryx Designer
    • Versions: 2021.4, 2022.1
  • Databricks
    • Version: 2.18
  • Simba Apache Spark on Databricks driver
    •  Version: 2.06.16
  • Fields with long text (254 characters+)


image.pngimage.png

Cause

 

The root cause is being investigated.



Resolution


Defect GCSE-687 has been created for this issue and will be addressed in a future release of Designer.
 

Workaround


Use  driver version 2.6.23. With that driver the data is read in correctly. 

Additional Resources