topic Re: Rounding in the databricks SQL editor in Data Engineering

Rounding in the databricks SQL editor

Hubert-Dudek — Sat, 01 Oct 2022 10:06:25 GMT

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

Re: Rounding in the databricks SQL editor

Hubert-Dudek — Sat, 01 Oct 2022 10:10:48 GMT

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.

Re: Rounding in the databricks SQL editor

Prabakar — Sat, 01 Oct 2022 10:15:55 GMT

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

Re: Rounding in the databricks SQL editor

Hubert-Dudek — Sun, 02 Oct 2022 18:39:11 GMT

Thank you @Prabakar Ammeappin

Re: Rounding in the databricks SQL editor

-werners- — Tue, 04 Oct 2022 07:24:31 GMT

Nice find