Edit

Entity type creation in ontology (preview)

Entity types represent real-world concepts such as Truck, Sensor, or Customer. They define standard names, descriptions, identifiers, and properties to ensure consistency across data sources and tools. By modeling your domain with entity types, you eliminate inconsistent column-level definitions and create a shared semantic layer that powers downstream experiences like analytics and AI agents. You can create entity types manually or import them from existing business logic in semantic models.

Important

This feature is in preview.

Prerequisites

Before creating entity types, make sure you have the following prerequisites:

Key concepts

Entity types use the following ontology (preview) concepts. For definitions of these terms, see the Ontology (preview) glossary.

  • Entity type
  • Entity type key
  • Entity instance
  • Property
  • Data binding

Create an entity type

Follow these steps to create entity types in your ontology (preview) item.

  1. From the Home configuration canvas, select Add entity type from the top ribbon or the center of the canvas.

    Screenshot of adding entity type.

  2. Enter a name for your entity type, and select Add Entity Type.

    Note

    Entity type names must be 1–26 characters, contain only alphanumeric characters, hyphens, and underscores, and start and end with an alphanumeric character.

  3. The configuration canvas displays your new entity type.

    Screenshot of the new entity type on the canvas.

Add properties

This section shows how to create properties on entity types without binding data to them (the properties remain unbound until you add data bindings for them later). It's also possible to add properties while binding data in a single operation, which is described in Data binding.

  1. Select the entity type name in the Explorer and select View entity type details from the top ribbon.

    Screenshot of the View Entity Type details button.

  2. The Configure page opens. This page surfaces important information about the entity type, including its properties and data bindings. Expand Manage property bindings and select Add properties.

    Screenshot of adding properties to the entity type.

  3. Add a name and property type for each property. Select Save to view the saved properties in the Properties pane.

    Screenshot of configuring the listed property details.

    Note

    Property names can only be duplicated across entities for properties of the same type. For example, you can't have one entity type with a string ID property and another entity type with an integer ID property, but you can have two entity types that both have a string ID property.

  4. The properties are added to the Configure page, unbound to any data source.

    Screenshot of the new unbound properties on the entity type.

  5. Optionally, select a property to use as the display name property for instances of this entity type in downstream experiences.

    Screenshot of the option to choose a property as a display name.

  6. To make the entity type operational, bind data to it.

Edit or delete an entity type

To delete an entity type from in your ontology (preview) item, go to the Home configuration canvas. Next to the entity type name in the Explorer, select ... > Delete entity type.

Screenshot of deleting an entity type.

To edit details of the entity type, select View Entity type details from the top ribbon to open the Configure page.

From this page, you can add, rename, and delete properties, and rename or delete the entity type itself.

Screenshot of editing entity type details.

Deleting a property removes it from the entity everywhere it's configured, including entity type key and relationship type configurations.

Note

Any updates in upstream data sources (like new rows) need to be manually refreshed before they're visible in the ontology item. For more information, see refresh the graph model.

Supported property types

The following table lists the supported property types for data that can be bound to properties in ontology (preview).

Ontology property value type Supported Lakehouse types Supported Eventhouse types
integer tinyint, smallint, bigint, integer, long, short int, long
boolean boolean bool
datetime datetime, date, timestamp datetime
double double, decimal, float decimal, real
string char, decimal(p, s), string, array, binary, binary16, byte, map, object, struct, timestampint64, timestamp_ntz dynamic, string, guid, timespan

The following table shows supported source column value types that can be used for the timestamp selection in a time series binding.

Ontology configuration Lakehouse and Eventhouse source column value type
Timestamp datetime, date, timestamp

The following table shows supported property types that can be used as the entity type key.

Ontology configuration Ontology property value type
Entity type key string, integer

If your data contains other data types, perform ETL to convert the data to one of the supported types before bringing the data to ontology.