Loading

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

Publiseringsdato: Oct 6, 2026
Beskrivelse

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.

Løsning

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

Flere ressurser

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-artikkelnummer

005461201

 
Laster
Salesforce Help | Article