question

sakuraime avatar image
0 Votes"
sakuraime asked sakuraime commented

Azure syanpase data pool or spark pool delta lake file

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 ?

azure-synapse-analytics
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.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered sakuraime commented

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 130616-image.png and upvote 130671-image.png 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


· 1
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.

wow .. ~~ that's very cool,!!! let me try that out

0 Votes 0 ·