Avoid scientific values

[Tej_04]

I am trying to insert data into catalog tables on data bricks but the values are being displayed in scientific notation which i am trying to avoid how do I view the data in standard format

for example - 0.0000000 is being displayed as 0E-7

[Alberto_Umana]

Hi @Tej_04,

Can you try with format_number Function.

SELECT format_number(column_name, decimal_places) AS column_name FROM table_name;

https://docs.databricks.com/en/sql/language-manual/functions/format_number.html