Manage schema changes

Changing object type schema

Workflows and applications built on the Foundry Ontology should evolve as an organization's needs change; in some cases, this evolution may involve updating the schema of object types in a way that requires additional changes elsewhere ("breaking changes"). Examples of breaking changes to the schema include changing the data type of an existing property, changing an object type’s backing datasource, or changing the primary key of an object type. See below for a full list of breaking schema changes.

In Object Storage V1 (Phonograph), the user interface discourages such schema changes, particularly when an object type has received user edits. This is because such user edits cannot be migrated in OSv1; instead, breaking changes will result in the loss of existing user edits unless time-consuming and complex manual intervention can be performed.

Object Storage V2 removes this restriction on schema changes to facilitate flexible and iterative workflow building. To that end, OSv2 provides a schema migration framework with a list of predefined migrations that can be applied to existing user edits after a breaking schema change. The Ontology Manager automatically detects breaking schema changes and guides users to select a migration option from the predefined list. See below for a full list of supported migrations.

Example workflow

In this example workflow, a user deletes the Year property from an object type that has existing user edits. The Ontology Manager automatically identifies this as a breaking schema change and displays a warning that a migration is required, as seen below.

In addition to displaying a warning, the Ontology Manager will present a Migrations tab in the Review edits interface when the user wants to save their changes to the Ontology. The Ontology Manager will block the user from saving changes until they define a migration for the breaking change. This prevents the change from breaking other workflows.

When the user navigates to the Migrations tab, the Ontology Manager displays the available migration options based on the type of breaking change, as shown below.

Once a schema change is specified and saved by a user in the Ontology Manager, a new schema version is created for the object type in the backend, and a corresponding replacement Funnel batch pipeline is orchestrated to update the index of the object type. The new object type version will be queryable by the Object Set Service (OSS) and other consumers of the Ontology APIs as soon as the replacement pipeline is completed and the new version is declared to be fully hydrated by object databases.

List of breaking schema changes

The following changes in the Ontology are considered to be breaking schema changes:

• Changing the input datasources of an object type
• Changing the primary key of an object type
• Changing the data type of a property
• Changing the ID of a property that has received user edits
• Deleting a property that has received user edits

List of non-breaking schema changes

The following changes in the Ontology are not considered to be breaking schema changes:

• Changing the display name, title key, render hints, type classes, or visibility of a property that has received user edits
• Deleting properties or making schema changes to properties that have never received user edits
• Deleting struct fields or making schema changes to struct fields that have never received user edits

List of supported schema migrations in OSv2

Below is the full list of schema migrations that are currently supported in Object Storage V2.

• Drop all property edits: This migration instruction drops all existing user edits on a specific property of an object type. User edits on other properties of the object type are not impacted. This instruction is generally used when deleting a property from an object type and there is no new property as a replacement.

• Drop all edits: This migration instruction drops all existing user edits on all properties of an object type. When this migration runs, the state of all object instances of an object type is reset to data in the input datasources. To execute this migration, navigate to the Datasources tab of the object type and select Delete edits, located in the Edits section.

• 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.

• Cast to new type: This migration instruction casts the data type of existing user edits on a specific property to the new data type of the property. The list of supported data type casts are:

  • Attachment → String
  • Boolean → String
  • Date → String
  • Double → Integer
  • Double → Long
  • Double → String
  • Geopoint → String
  • Geoshape → String
  • Integer → Long
  • Integer → Double
  • Integer → String
  • Long → Integer
  • Long → Double
  • Long → String
  • Mandatory marking → String
  • String → Integer
  • String → Long
  • String → Double
  • String → Boolean
  • String → Date
  • String → Timestamp
  • String → Geopoint
  • String → Geoshape
  • Timestamp → String

• Revert migration: This migration instruction reverts a previously-applied schema migration. This instruction is generally used when a saved Ontology change is being reverted through the History section in the Ontology Manager.

  • To revert a migration, navigate to the History section in the Ontology Manager for the desired ontology, expand the Migrations section within the history event, open the ... menu on the migration event, and select Revert. Once the migrations have been reverted, save the modifications within the Ontology Manager.