Databricks notebook how to stop truncating numbers when export the query result to csv
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-26-2024 05:27 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-30-2024 07:29 AM
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2024 10:07 AM
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?

