Share via

Azure synapse storage

sakuraime 2,351 Reputation points
2021-05-25T04:06:43.963+00:00

Suppose I am having a table which is hash distributed , without partition , and it's clustered column stored index . So the underneath storage is

1 file per segment / per column ? in the blob storage ?

or 1 file per segment only ?

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.

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Samara Soucy - MSFT 5,141 Reputation points
    2021-05-28T04:05:15.693+00:00

    Hi sakuraime,

    While Synapse dedicated pools do utilize Storage to hold the data, the storage account behind them is not accessible like it is for Spark pools. As Himanshu mentioned there's a discussion started with the product team to see if there is anything else we can share about the internal architecture.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.