โ01-19-2022 01:56 AM
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 ?
โ01-21-2022 06:25 AM
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
โ01-19-2022 08:51 AM
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. ๐
โ01-20-2022 02:34 AM
+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.
โ01-21-2022 02:17 AM
Good feedback, @Bilal Haniffโ . I'll pass this along to the product team.
โ01-21-2022 06:25 AM
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
โ01-21-2022 06:59 AM
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.
โ01-27-2022 03:14 PM
@Bilal Haniffโ - Would you be happy to mark whichever answer helped you the most as best? That helps others find solutions more quickly.
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโt want to miss the chance to attend and share knowledge.
If there isnโt a group near you, start one and help create a community that brings people together.
Request a New Group