I have a table in databricks which is NOT a delta table. I would like to update rows or insert new ones.
Both sql INSERT and UPDATE did not work for non delta tables. Is there any workaround?
My table is saved as parquet.
I know there is a way of convertion a table to a delta table but in my case I suppose it may be risky. The impact of such conversion to existing scripts is unknown. Changing a design of exiting solution may also be a big effort for the whole team. I am looking rather somethng I can quickly implement on my own.
TIA