question

KuldeepChitrakar-0966 avatar image
0 Votes"
KuldeepChitrakar-0966 asked PRADEEPCHEEKATLA-MSFT commented

Synapse Serverless SQL Pool Distribution

Hi

In Serverless SQL Pool , if I have only one file and I am querying it using Server less SQL pool How does it processes parallel. As per documentation, control node assigns the files to Compute node.

What is the best practice. Is it mandatory to have separate files in order to achieve best performance in Server less SQL pool.

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 @KuldeepChitrakar-0966,

Just checking in to see if the below answer provided by @pituach 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 ·

Hello @KuldeepChitrakar-0966,

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

pituach avatar image
0 Votes"
pituach answered

Good day,

if I have only one file and I am querying it using Server less SQL pool How does it processes parallel.

Using simple SELECT from a single file, it does not by default. One file = one reader at a time, but...

As per documentation, control node assigns the files to Compute node. What is the best practice.

I don't think that we can discuss best practice without fully understand the scenario

but one of the recommended solution most important features available in serverless SQL pool which you can use is: CREATE EXTERNAL TABLE AS SELECT (CETAS). CETAS is a parallel operation that creates external table metadata and exports the SELECT query results to a set of files in your storage account. Check the documentation for more information.

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.