Loading

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

Дата публикации: Oct 6, 2026
Описание

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.

Решение

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

Дополнительные ресурсы

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.

Номер статьи базы знаний

005461201

 
Загрузка
Salesforce Help | Article