Different Loading Methods in Azure

 

Control node is basically a special category of node that receives all the connections and orchestrates the queries. It sends the different queries to the different nodes and take the results back. So it's always in constant communication to the different compute nodes that are part of the system. The control node will always be the same regardless of how many data warehousing units you add. However, you will get more compute nodes as your DWUs increases.