Skip to main content
Skip table of contents

Entities

Entity is a core metadata object in Agile Data Engine. An entity refers to data warehouse tables, views, materialized views, or informational metadata only objects (sources).

Building a data warehouse in Agile Data Engine is based on entities:

  • A data model is created by creating entities.

  • A data pipeline is created between the source entities and the target entities.

Each entity has metadata that provides information about the entity itself. The metadata of an entity can include:


Tutorials

See the below videos for quick tutorials on how to create entities.

https://youtu.be/bV7n2nMntCchttps://youtu.be/EJUz_xuhpNw

Managing entities

In the Entities tab you can:

  1. Create a new entity.

  2. Edit entities by selecting an entity in the Package entities view.

  3. Soft delete entities.

  4. View soft deleded entities by toggling the slider.

5. Restore soft deleted entities when Show deleted is toggled.


Entity properties

Property

Description

ENTITY ID

Entity unique identifier

ENTITY NAME

Entity full name including prefixes and/or suffixes configured for ENTITY TYPE in CONFIG_ENTITY_DEFAULTS.

ENTITY LOGICAL NAME

Entity logical name. Logical name does not contain prefixes and/or suffixes (e.g. "H_" for HUBS, "F_" for FACTS...) configured in CONFIG_ENTITY_DEFAULTS.

ENTITY TYPE

Default supported values: SOURCE, STAGE, HUB, SAT, SAT_C*, S_SAT, S_SAT_C*, LINK, PIT, BRIDGE, REF, DIM, FACT, FLAT, LOGICAL, GENERIC.

MODIFIED

Timestamp and user name of last modification to the entity

DW ZONE

Data warehouse zone/layer. Default supported values: NONE, SOURCE, INGESTION, RAW, BUSINESS_RULES, INFORMATION_DELIVERY, LOGICAL_MODEL.

PHYSICAL TYPE

See Physical types

DISTRIBUTION STYLE

See Distribution styles

SCHEMA

Database schema name

FORCE RECREATION

With FORCE RECREATION: true, an entity is always recreated when deploying the package into the target database. Recreation of an entity is sometimes necessary to get all changes deployed. For example, changing the attribute order might require FORCE RECREATION: true to actualize in the target database.

DESCRIPTION

Entity description/comment which is also written into the target database.

\* Automated entity types (default configuration), e.g. satellite current view (SAT_C) created automatically for satellite (SAT).

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.