Loading

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

Publiceringsdatum: Oct 6, 2026
Beskrivning

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

Ytterligare resurser

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

005461201

 
Laddar
Salesforce Help | Article