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:
Properties (see below)
See the below videos for quick tutorials on how to create entities.https://youtu.be/bV7n2nMntCchttps://youtu.be/EJUz_xuhpNw
In the Entities tab you can:
Create a new entity.
Edit entities by selecting an entity in the Package entities view.
Soft delete entities.
View soft deleded entities by toggling the slider.
5. Restore soft deleted entities when Show deleted is toggled.
Entity unique identifier
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.
Default supported values: SOURCE, STAGE, HUB, SAT, SAT_C*, S_SAT, S_SAT_C*, LINK, PIT, BRIDGE, REF, DIM, FACT, FLAT, LOGICAL, GENERIC.
Timestamp and user name of last modification to the entity
Data warehouse zone/layer. Default supported values: NONE, SOURCE, INGESTION, RAW, BUSINESS_RULES, INFORMATION_DELIVERY, LOGICAL_MODEL.
See Physical types
Database schema name
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.
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).