Skip to content

Plan schema migration

POST
/dataset-tables/{tableId}/migrations/plan

Validate a set of migration operations without executing them. Returns what would happen.

tableId
required

Unique identifier of the table to retrieve

string

Unique identifier of the table to retrieve

object
operations
required

Array of migration operations to plan

Array
>= 1 items
One of:
object
type
required
string
Allowed values: add_column
params
required
object
name
required
string
dataType
required
string
nullable
required
boolean
position
integer
nullable
defaultValue
nullable

Migration plan generated

object
isValid
required

Whether the migration plan is valid

boolean
validationErrors
required

List of validation errors if plan is invalid

Array<string>
estimatedDurationMs

Estimated migration duration in milliseconds

number
indexImpacts
required

How the migration affects existing indexes

Array<object>
object
indexName
required

Name of the affected index

string
impact
required

How the migration affects this index

string
Allowed values: none rebuild drop
reason

Explanation of why this impact is expected

string
requiresRewrite

Whether the migration requires rewriting table data

boolean

Bad Request - Validation error or invalid input

object
error
required
string
code
string
details
nullable
retryable
boolean

Unauthorized - Authentication required or invalid token

object
error
required
string
code
string
details
nullable
retryable
boolean

Forbidden - Insufficient permissions

object
error
required
string
code
string
details
nullable
retryable
boolean

Not Found - Resource does not exist

object
error
required
string
code
string
details
nullable
retryable
boolean