Table Fields Have a Different Value and Data Type in SQL Editor vs a SQL Notebook Cell

help_needed_445
Contributor

When I query a numeric field in the SQL Editor it returns a value of 0.02875 and the data type is decimal but when I run the same query in a SQL notebook cell it returns 0.0287500 and decimal(7,7). I'm assuming this is expected behavior but is there any documentation on this? I found after looking at the table schema that 0.0287500 and decimal(7,7) are correct but it would be nice to have confirmation because I can't find info on this difference anywhere on the web. Is the notebook returning the raw table value and data type?

SQL Editor

help_needed_445_0-1756930330991.png

SQL notebook cell

help_needed_445_1-1756930339286.png