Loading

FLOAT Data Type Values Not Displaying as Expected When Connected to Snowflake

Дата публикации: Apr 13, 2024
Описание

Issue

When connecting to Snowflake from Tableau, values for fields designated as FLOAT data types in the underlying Snowflake database do not match what is being displayed in data source.

Cause

In Snowflake, FLOAT data types use double precision floating point numbers. This generally means that FLOAT data type fields do not have a precision/scale that cooperates with Tableau. Tableau may unexpectedly throw errors or improperly render any values whose scale is greater than 16 (For example, 7.9251349817081219.) as Tableau internally represents decimals with a scale limited to 16.

 

Решение

Change the data type in the Snowflake database to specify a precision and scale (i.e. NUMERIC(38,4)) - as long as the second number in the parentheses (representing 'scale') is less than 16 and greater than 0, the expected values should be returned in Tableau.  

Information on changing Data-types in Snowflake can be found here.

 

Дополнительные ресурсы
What's the difference between a single precision and double precision floating point operation? at Stackoverflow.
Numeric Data Types at Snowflake.

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

001471571

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