databricks update, insert to non delta table

Question

databricks update, insert to non delta table

braxx 461

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

PRADEEPCHEEKATLA 91,866 Reputation points

2021-06-10T08:45:19.46+00:00

Hello @braxx ,

Thanks for the question and using MS Q&A platform.

When you say "Both sql INSERT and UPDATE did not work for non delta tables.", could you please provide more details on what you have tried and are you experiencing any error message?
PRADEEPCHEEKATLA 91,866 Reputation points

2021-06-11T11:31:14.403+00:00

Hello @braxx ,

Just checking in if you have had a chance to see the previous response. We need the following information to understand/investigate this issue further.