to push an Aggregator transformation to process in Microsoft Azure Synapse SQL .
Aggregate calculations
You can perform the following aggregate calculations:
AVG
COUNT
MAX
MEDIAN
MIN
SUM
STDDEV
VARIANCE
Incoming ports
When you configure an Aggregator transformation and the incoming port is not used in an aggregate function or in a group by field in a mapping in advanced mode, a dummy MAX() function is generated in the query and the mapping runs with full