question

NavinDondapati avatar image
0 Votes"
NavinDondapati asked ShaikMaheer-MSFT commented

Synapse Sparkpool delta table -External table on dedicated pool

Hi Guys,

We have delta table in Synpase Spark pool; and we want to access the delta table as external table from dedicated pool; appreciate ifyou can provide syntax for the same;

And is it possible to access by version of or timestamp of table data based on version of delta table?

Regards,
Navin

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

Hi @NavinDondapati ,

Following up to see if below answer helps you? If yes, Please consider click on Accept answer. Accepted answers helps community as well.

0 Votes 0 ·

Hi @NavinDondapati ,

Just checking to see if below answer helps you? If yes, Please consider click on Accept answer. Accepted answers helps community as well.

0 Votes 0 ·

1 Answer

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered

Hi @NavinDondapati ,

Thank you for posting query in Microsoft Q&A Platform.

Unfortunately, External tables in Dedicated SQL pool will not support Delta format at this moment. Kindly check below screenshot for same.

133492-image.png

Documentation reference for same: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables?tabs=hadoop

Hope this will help. Please let us know if any further queries.


  • Please don't forget to click on 130616-image.png or 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


image.png (96.6 KiB)
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.