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 ?
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
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
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
6 people are following this question.