Storage Architecture of Azure Synapse dedicated pool

Sonali Singh8 6 Reputation points
2021-10-11T17:39:29.02+00:00

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
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,358 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 76,746 Reputation points Microsoft Employee
    2021-10-12T09:55:34.797+00:00

    Hello @Sonali Singh8 ,

    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
    1 person found this answer helpful.