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

Configuring key range partitioning

Configuring key range partitioning

Perform the following steps to configure key range partitioning for
Microsoft Azure Synapse SQL
sources:
  1. In the Source Properties, click the
    Partitions
    tab.
  2. Select the required partition key from the list.
  3. Click
    Add New Key Range
    to define the number of partitions and the key ranges based on which the Secure Agent must partition data.
    Use a blank value for the start range to indicate the minimum value. Use a blank value for the end range to indicate the maximum value.
    The following image displays the
    Partitions
    tab:
    The image shows the partitions and the corresponding key ranges.

0 COMMENTS

We’d like to hear from you!