question

sakuraime avatar image
0 Votes"
sakuraime asked sakuraime commented

Azure synapse storage

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

Hello @sakuraime ,
Thanks for the ask and using the Microsoft Q&A platform .
At this time, we are reaching out to the internal team to get some help on this . We will update you once we hear back from them.
Thanks
Himanshu

0 Votes 0 ·

ok and thanks

0 Votes 0 ·

1 Answer

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

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.

· 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. see if the column stored index is

column01 / per distribution/ per blob

column02 / per distribution/ per blob
??

thanks

0 Votes 0 ·