Loading
Ongoing maintenance for Salesforce HelpRead More

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

Publish Date: 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.

Resolution

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

Additional Resources

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.

Knowledge Article Number

005461201

 
Loading
Salesforce Help | Article