ores.sql.asset_class
Table of Contents
This page is the node for the ores.sql.asset_class facet of the codegen
template library, part of the ores.sql technical space.
1. Summary
One template projecting the asset-class catalogue onto the seed SQL that used to be hand-written: the refdata product taxonomy, one row per class, with the prose the seed carried on each row. The catalogue model declares the taxonomy, the oresmd namespace and the mapping between them; this facet renders the taxonomy. The DQ badge rows and the briefs are separate archetypes of the same model.
2. The ores.sql.asset_class facet
Driven by the asset-class catalogue model — a taxonomy list carrying
code, name, display_order and the class's prose, plus a namespace
list of the oresmd authorities and the class each maps onto — rather than
by an entity. The generated script replaces the hand-written
refdata_asset_class_codes_populate.sql, so the taxonomy has one author.
3. Archetypes
| Archetype | Description |
|---|---|
| ores.sql.asset_class.codes_populate | The refdata product taxonomy seed, generated from the asset-class catalogue. |
| ores.sql.asset_class.dq_artefact_populate | The asset-class DQ rows in the staging tables a tenant is published from, generated from the catalogue. |
| ores.sql.asset_class.dq_system_populate | The asset-class badge definitions, code domain and mappings for the system tenant, generated from the catalogue. |
4. See also
- ores.sql — the parent technical space's generated facet/archetype catalogue and shared Mustache conventions.
- SQL Technical Space — the domain-concept overview of this technical space.