question

SonaliSingh8-1999 avatar image
0 Votes"
SonaliSingh8-1999 asked PRADEEPCHEEKATLA-MSFT commented

Storage Architecture of Azure Synapse dedicated pool

Is the data stored in Azure Data lake gen2(Azure Storage) after distributions in dedicated sql pool of Azure Synapse?
If yes, then how is it stored i.e. in which format?

139553-dedicated-sql-pool.png


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

Hello @SonaliSingh8-1999,

Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.


  • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.

0 Votes 0 ·

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @SonaliSingh8-1999,

Thanks for the question and using the MS Q&A platform.

Is the data stored in Azure Data lake gen2(Azure Storage) after distributions in dedicated sql pool of Azure Synapse?

No, data stored is not stored in Azure Data Lake Gen2 for dedicated sql pool of Azure Synapse.

Azure Synapse Dedicated SQL pool (formerly SQL DW) stores data in relational tables with columnar storage. This format significantly reduces the data storage costs, and improves query performance. Once data is stored, you can run analytics at massive scale. Compared to traditional database systems, analysis queries finish in seconds instead of minutes, or hours instead of days.

Dedicated SQL pool SQL (formerly SQL DW) leverages Azure Storage to keep your user data safe. Since your data is stored and managed by Azure Storage, there is a separate charge for your storage consumption. Azure Synapse dedicated SQL pools to reserve processing power for data stored in SQL tables.

139783-image.png

Azure Synapse Analytics allows the different workspace computational engines to share databases and tables between its serverless Apache Spark pools and serverless SQL pool and stored in Azure Data Lake Gen2

139834-image.png

For more details, refer to What is Azure Synapse Analytics? and Azure Synapse Analytics shared metadata.

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 (50.0 KiB)
image.png (84.8 KiB)
· 3
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 @PRADEEPCHEEKATLA-MSFT,

Thanks for replying.

As per the below diagram, I can see that dedicated pool(circled in red) also has ADLS gen 2 as a storage. If it is so, then the understanding is that the data is stored in ADLS gen2. Is the understanding right or not?

139854-capture.png


0 Votes 0 ·
capture.png (55.9 KiB)

Hello @SonaliSingh8-1999,

Dedicated SQL pool SQL (formerly SQL DW) leverages Azure Storage to keep your user data safe. Since your data is stored and managed by Azure Storage,

The diagram indicates only for serverless Apache Spark pools and serverless SQL pools and not dedicated pools.

Azure Synapse Analytics allows the different workspace computational engines to share databases and tables between its serverless Apache Spark pools and serverless SQL pools and stored in Azure Data Lake Gen2.

Hope this helps.

0 Votes 0 ·

Hello @SonaliSingh8-1999,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·