Databricks notebook how to stop truncating numbers when export the query result to csv

[Jasonh202222]

I use Databricks notebook to query databases and export / download result to csv. I just accidentally close a pop-up window asking if need to truncate the numbers, I accidentally chose yes and don't ask again. Now all my long digit numbers are truncated. I tried to change the settings in Databricks and Chrome browser, still not working. Does anyone know how to enable that pop-up window again so that i can disable truncation when export/download numbers?

[shan_chandra]

@Jasonh202222  - Kindly check the below navigation path

user settings -> Account settings -> Display -> Download and Export. 

Under Download and Export, Enable the checkbox -  "Prompt for formatting large numbers when downloading or exporting" and click on save.  

Please try this and let us know.

[Jasonh202222]

Hi @shan_chandra, when I click user setting, but "Account Settings" is not showing up in the list, please see screenshots. I wonder if it is because of the different version of Databricks?  

 

[Kaniz_Fatma]

Hey there! Thanks a bunch for being part of our awesome community! 🎉 

We love having you around and appreciate all your questions. Take a moment to check out the responses – you'll find some great info. Your input is valuable, so pick the best solution for you. And remember, if you ever need more help , we're here for you! 

Keep being awesome! 😊🚀