Prabakar
Databricks Employee
Databricks Employee

Float is Approximate-number data type, which means that not all values in the data type range can be represented exactly.

Decimal/Numeric is Fixed-Precision data type, which means that all the values in the data type range can be represented exactly with precision and scale.

So its always better you use Decimal instead of float.