Azure syanpase data pool or spark pool delta lake file

Question

I know Azure synapse is able to read delta lake table. but may I know if the synapse spark spool can read and also WRITE TO delta table ?

Answer 1

Hi @sakuraime ,

Thanks for using Microsoft Q&A forum and posting your query here.

Yes Synapse spark pool can read and write to delta tables. For more info please refer to this doc: Apache Spark - Work with Delta Lake

This article provides code snippets that show how to read from and write to Delta Lake tables from interactive, batch, and streaming queries.

Below are the topics covered in the above doc:

• Create a table
• Read data
• Update table data
• Overwrite table data
• Conditional update without overwrite
• Read older versions of data using Time Travel
• Write a stream of data to a table
• Read a stream of changes from a table
• SQL Support

Hope this info helps.

----------

• Please don't forget to click on and upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators