Skip to content

UpdateTable

Description

      description: |
        Update existing rows in table `id`.

Request Schema

    UpdateTableRequest:
      type: object
      description: |
        Each update consists of a column name and an SQL expression that will be
        evaluated against the current row's value. Optionally, a predicate can be
        provided to filter which rows to update.
      required:
        - updates
      properties:
        id:
          type: array
          items:
            type: string
        predicate:
          type: string
          nullable: true
          description: Optional SQL predicate to filter rows for update
        updates:
          type: array
          items:
            type: array
            minItems: 2
            maxItems: 2
            items:
              type: string
          description: List of column updates as [column_name, expression] pairs

Response Schema

    UpdateTableResponse:
      type: object
      required:
        - updated_rows
        - version
      properties:
        updated_rows:
          type: integer
          format: int64
          description: Number of rows updated
          minimum: 0
        version:
          type: integer
          format: int64
          description: The commit version associated with the operation
          minimum: 0