PowerExchange for Amazon Redshift User Guide

10.5
- 10.5.6
- 10.5.4
- 10.5.3
- 10.5.2
- 10.4.1
- 10.4.0

Back Next

Rules and Guidelines for Specifying Key Ranges

Use the following rules and guidelines when you create key ranges:

You can leave the start and end range blank for a partition. When you leave the start range blank, the Integration Service uses the minimum data value as the start range. When you leave the end range blank, the Integration Service uses the maximum data value as the end range.

Specify the key range for the partitions in a continuous sequence.

For example, if you configure three partitions, where 1-3 is the range for the first partition, partition 2 must start with the end range of the first partition and partition 3 must start with the end range of the second partition:

partition 1: 1-3

partition 2: 3-5

partition 3: 5-7

Key Range Partitioning

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal