Issue
When connecting to Databricks in Tableau Desktop, if the string fields has more than 255 characters, they will be truncated to 255 characters.
Last Modified Date: 30 Aug 2023
Environment
- Tableau Desktop
- Databricks Connector
- SparkSQL ODBC driver
Resolution
Option 1 (recommended)
Use TDC file to increase the String Column Length:<?xml version='1.0' encoding='utf-8' ?>
<connection-customization class='databricks' enabled='true' version='10.4'>
<vendor name='databricks'/>
<driver name='databricks'/>
<customizations>
<customization name='odbc-connect-string-extras' value='DefaultStringColumnLength=500' />
</customizations>
</connection-customization>
Option 2
Change the default value from DSN and then use ODBC connector:Cause
The truncation of the 'string' field to 255 characters is caused by a default String Column Length within SparkSQL ODBC driver.Additional Information
Default StringColumnLength - Default Value is 255Simba Spark ODBC Driver with SQL Connector (scroll to "Default String Column Length" section)
Connecting to Databricks
Use TDC file on Tableau Desktop
Use TDC file on Tableau Server
Databricks - Tableau
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials