Skip to content

[FEATURE] Create a ucx.history table #2572

@JCZuurmond

Description

@JCZuurmond

The history table should have the following schema:

Column name Data type Comment
workspace_id int The identifier of the workspace where this record was generated.
run_id int An identifier of the workflow run that generated this record.
run_as str The identity of the account that ran the workflow that generated this record.
run_start_time dt.datetime When this record was generated.
snapshot_id int An identifier that is unique to the records produced for a given snapshot.
ucx_version str The UCX semantic version
failures list[str] The list of problems associated with the object that this inventory record covers.
object_type str The inventory table for which this record was generated.
object_id list[str] The type-specific identifier for this inventory record.
object_data str Type-specific JSON-encoded data of the inventory record.
object_owner str The identity that has ownership of the object.
object_type_version int Versioning of inventory table, for forward compatibility. (Zero 0 if not specified.)

Metadata

Metadata

Assignees

Labels

feat/migration-progressIssues related to the migration progress workflow

Type

No type

Projects

Status

No status

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions