SQL Analytics: Is it possible to configure the default number format

[Bilal1]

Hi

When querying an integer value, the default format is '0.0' which results in an integer value 202111, displayed as 202,111. I can resolve the issue by updating the visualisation or using formatnumber in my query, however I would like to set a default number format for all queries.

Is there a configuration parameter that I can set on the SQL endpoint to default the number format ?

[Anonymous]

Hello @Bilal Haniff​ - Welcome to the community! Thank you for bringing your question to us. We'll give the community some time to respond before we circle back around to this. Thanks in advance for your patience. 🙂

[mortenhaga]

+1. In the weekly QA/Test meeting where I work, the Data Analystst have given feedback on this; with having to correct for the comma every time they copy values from the SQL Analytics query result UI. I would also be glad to be guided in the direction of how to correct this.

[BilalAslamDbrx]

Good feedback, @Bilal Haniff​ . I'll pass this along to the product team.

[miranda_luna_db · Accepted solution]

Hi @Bilal Haniff​  - While we don't yet allow defining workspace or user level viz prop settings, we are certainly starting to scope what that would look like.

A bit of good news on the pressing issue though - as of the latest update, integers and floats should no longer have commas by default. 😁 https://docs.databricks.com/sql/release-notes/index.html#january-20-2022

[Bilal1]

Thanks @Miranda Luna​  Guess I should've been more patient 🙂

in the SQL Server and Orace database, we have the NLS settings that can always be changed. I think this would be useful feature to also have in Databricks, as it gives us more control on displaying output in the business users desired format.

[Anonymous]

@Bilal Haniff​ - Would you be happy to mark whichever answer helped you the most as best? That helps others find solutions more quickly.