When you read data from or write data to Google Cloud Spanner, you can configure partitioning to optimize the mapping performance at run time. You can configure partitioning for Google Cloud Spanner mappings that you run in the native or Spark engine.
Define the partition type as key range partitioning. To configure key range partitioning, open the Google Cloud Spanner data object read or write operation, and select the
Key Range
partition type option on the
Run-time
tab.
When you configure key range partitioning, the Data Integration Service distributes rows of data based on a port or set of ports that you define as the partition key. You can define a range of values for each port. The Data Integration Service uses the key and ranges to send rows to the appropriate partition.