Table of Contents

Search

  1. Preface
  2. Introduction to Microsoft Azure Synapse SQL Connector
  3. Connections for Microsoft Azure Synapse SQL
  4. Mappings for Microsoft Azure Synapse SQL
  5. Upgrading to Microsoft Azure Synapse SQL Connector
  6. Migrating a mapping
  7. SQL ELT optimization
  8. Data type reference
  9. Troubleshooting

Microsoft Azure Synapse SQL Connector

Microsoft Azure Synapse SQL Connector

Aggregator transformation

Aggregator transformation

You can configure full
SQL ELT optimization
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
SQL ELT optimization
.

0 COMMENTS

We’d like to hear from you!