question

braxx avatar image
0 Votes"
braxx asked PRADEEPCHEEKATLA-MSFT commented

databricks update, insert to non delta table

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

azure-databricks
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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?

0 Votes 0 ·

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.

0 Votes 0 ·

0 Answers