insert into delta table for decimal value failing due to scale

[Guru V]

HI,

I have delta table with decimal column with 10,2 scale. Some of the data that i am getting from csv is having more than 2 decimal digits and it fails when i try to write in delta table.

Is there option so that insert is not failed and data will get rounded off and inserted.

Also if i want to update the scale of an existing column, is there an option to do that

Thanks