---
title: "POST /v1/{+database}:addSplitPoints"
method: POST
path: "/v1/{+database}:addSplitPoints"
tags: ["projects"]
---

# POST /v1/{+database}:addSplitPoints

`POST /v1/{+database}:addSplitPoints`

Adds split points to specified tables and indexes of a database.

## Path parameters

- `database` string, required

## Request body

- AddSplitPointsRequest — The request for AddSplitPoints.
  - `splitPoints` SplitPoints[] — Required. The split points to add.
    - `table` string — The table to split.
    - `index` string — The index to split. If specified, the `table` field must refer to the index's base table.
    - `keys` Key[] — Required. The list of split keys. In essence, the split boundaries.
      - `keyParts` unknown[] — Required. The column values making up the split key.
        - unknown
    - `expireTime` string, google-datetime — Optional. The expiration timestamp of the split points. A timestamp in the past means immediate expiration. The maximum value can be 30 days in the future. Defaults to 10 days in the future if not specified.
  - `initiator` string — Optional. A user-supplied tag associated with the split points. For example, "initial_data_load", "special_event_1". Defaults to "CloudAddSplitPointsAPI" if not specified. The length of the tag must not exceed 50 characters, or else it is trimmed. Only valid UTF8 characters are allowed.

## Response `200`

Successful response

---

[API](https://skmtc.net/google/apis/spanner.md) · [All operations](https://skmtc.net/google/apis/spanner/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/google/spanner/versions/4b66067d2622/schema)