Loading

SUM of a Databricks DECIMAL column returns overflowed decimal values (e.g., -1.945e+40)

Date de publication: Oct 6, 2026
Description

When connecting Tableau Desktop or Tableau Server to a Databricks data source using driver version 2.12.x, aggregating DECIMAL columns may return overflowed decimal values (e.g., -1.945e+40). This issue can occur with both live and extract connections.

Résolution

Option 1:

Use Databricks ODBC driver version 2.11.x or earlier.

 

Option 2:

On Tableau's data source connection page, enter DecimalAsArrow=0 in the Extra ODBC Options field under the Advanced tab.

If other options are already present, add this option after a semicolon. For example: key=value;DecimalAsArrow=0

Ressources supplémentaires

This behavior appears to be related to a design change introduced in Databricks ODBC Driver 2.12.x. Starting with version 2.12.0, the driver handles decimal values through Arrow by default.

Numéro d’article de la base de connaissances

005461201

 
Chargement
Salesforce Help | Article