I want to move a few properties to a new backing dataset, but I don’t want to lose edits on those properties, is this possible?
I.e.
I had backing dataset A, which i’m splitting into backing dataset A and B. I want the properties and edits in OMA from this change to remain identical, is this possible?
If it’s OSv2 (and I assume it is, because you are planning to use two datasources), you can leverage schema migrations to move edits when switching a property from one datasource to another.
- Move edits: This migration instruction moves all existing user edits on a specific property or on the entire object type. This instruction is generally used in two cases:
- When an existing property is renamed or deleted and being replaced by a new property, or
- When the input datasource of an object type is being replaced by another datasource.
https://www.palantir.com/docs/foundry/object-edits/schema-migrations/#list-of-supported-schema-migrations-in-osv2
One thing to note here with respect to Move edits migration, is that it’s not relevant when you’re still keeping Datasource A around here. In that case you can freely change the backing datasource of the properties to a new datasource you’re adding, without loosing edits.
However, if Datasource B doesn’t constain a primary key for the same values as Datasource A had, your property edits will no longer be visible once the indexing has finished. It’s only if Datasource B also has an entry for that primary key that edits will still be visible