Rounding in the databricks SQL editor

[Hubert-Dudek]

In SQL editor (inside SQL experience), executing expressions 1 – 0.999 gives the result 0.

[Hubert-Dudek · Accepted solution]

The incorrect result is because of default rounding to format 0.00. We can implement the below solution to solve the problem. It must be applied to every individual query.

Option 1: Edit Visualisation

After clicking Edit visualization, we can change the default Number format to 0.000

Option 2: Format number

We can use the format_number function to override the default rounding format.General solution needed

Setting the default format for numbers in SQL Editor should be possible. Currently, when we go to “SQL Admin Console”, there is only the possibility to change the default date & time format.

@Lindsay Olson​ @Prabakar Ammeappin​ @Werner Stinckens​ @Jose Gonzalez​ , please pass it on as feedback if possible.

[Prabakar]

Sure @Hubert Dudek we'll test this internally and will take it to the team.

[Hubert-Dudek]

Thank you @Prabakar Ammeappin​ 

[-werners-]

Nice find