cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

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

Bilal1
New Contributor III

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 ?

1 ACCEPTED SOLUTION

Accepted Solutions

miranda_luna_db
Databricks Employee
Databricks Employee

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

View solution in original post

6 REPLIES 6

Anonymous
Not applicable

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
Contributor

+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
Databricks Employee
Databricks Employee

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

miranda_luna_db
Databricks Employee
Databricks Employee

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

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
Not applicable

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

Connect with Databricks Users in Your Area

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