Hi @Manasi_Sarang ,

I believe the Delta is unable to infer the schema as you are using select statement to read entire content from csv file and I think the inferschema won't work here.  Instead you can try to create a temp live table or live view with the below options and read from that table or view. 

USING csv OPTIONS (path "./file.csv", header "true", inferSchema "true")