Home     Documentation     Sliding window scenario

How to Partition Tables with Data

4. Define the partitioning key

Forward » « Back

The column that is used to define which range of row data goes into which partition is the partition key.

In this example, since it is necessary to partition data by date of transaction, the TransactionDate column is used as the partition key.

Define the partitioning key