Synapse Serverless SQL Pool Distribution

Question

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.

Answer 1

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.