Hi @raghu maremanda​ ,

can you please share error details?

are you using PYTHON CELL to execute the code?

I am not sure right now if it's optional or mandatory, but you could add .mode() i.e:

df.write.format("delta").mode("append").saveAsTable("tablename")
 
append or overwrite

please refer to: https://docs.delta.io/latest/delta-batch.html#write-to-a-table

Thank you for your response.

This is what I have so far -

d = spark.read.option("inferSchema" ,"true").option("delimeter" ,",").option("header","true").csv('dbfs:/FileStore/tables/Devices.csv')

d.write.format("delta").mode("append").saveAsTable("devices_new")

@raghu maremanda​ ,

you didn't add the .mode() in your code shown.

it's still:

d.write.format("delta").saveAsTable("delta.devices_new")

I am not sure if this will help, but try:

d.write.format("delta").mode("append").saveAsTable("devices_new")

also, the error doesn't tell much. can you share the error thrown?

thanks,

Pat.

thank you for the response. db runtime was older. issue resolved.

check your read cell, "Delimeter"