ores.dq.artefact_type
Table of Contents
Artefact types define the mapping between dataset artefact codes and the database infrastructure needed to publish them: the artefact table where staging data is stored, the target production table where data is published, and the NATS subject dispatched by the workflow engine to perform the publication. Rows are authored directly (not mirrored from an external source).
Flags
Columns
code
Unique code identifying this artefact type.
Examples: "countries", "currencies", "images".
std::string(faker::word::noun())
name
Human-readable name for display purposes.
std::string(faker::word::adjective()) + " Artefact Type"
description
Detailed description of this artefact type.
std::string(faker::lorem::sentence())
artefact_table
Name of the artefact (staging) table for this type. This is where data is staged before publication. Example: "dq_countries_artefact_tbl".
std::string(faker::lorem::word()) + "_artefact_tbl"
target_table
Name of the target (production) table for this type. This is where data is published to. Example: "refdata_countries_tbl".
std::string(faker::lorem::word()) + "_tbl"
target_subject
NATS subject dispatched by the workflow engine to publish data from the DQ artefact table to the target service table. Example: "refdata.v1.countries.publish-from-dq".
std::string(faker::lorem::word()) + ".v1.publish-from-dq"
display_order
Order for UI display purposes.
faker::number::integer(1, 100)
SQL
Flags
Validation function
Insert trigger
Validations
| column | validation_function |
C++
Flags
Repository
Domain includes
#include <chrono> #include <string>
Entity includes
#include <string>
Conventions
Table display
| column | header |
|---|---|
| code | Code |
| name | Name |
| description | Description |
| artefact_table | Artefact Table |
| target_table | Target Table |
| target_subject | Target Subject |
| display_order | Order |
| modified_by | Modified By |
Custom repository methods
Qt
Detail fields
| field | label | widget | type | is_key | is_required | placeholder |
|---|---|---|---|---|---|---|
| code | Code | codeEdit | line_edit | true | true | Enter artefact type code |
| name | Name | nameEdit | line_edit | true | Enter a display name | |
| description | Description | descriptionEdit | text_edit | Enter a description | ||
| artefact_table | Artefact Table | artefactTableEdit | line_edit | Enter the staging table name | ||
| target_table | Target Table | targetTableEdit | line_edit | Enter the target production table | ||
| target_subject | Target Subject | targetSubjectEdit | line_edit | Enter the publish-from-dq subject | ||
| display_order | Display Order | displayOrderEdit | spin_box |
Columns (Qt model)
| enum_name | field | header | type | width |
|---|---|---|---|---|
| Code | code | Code | string | 150 |
| Name | name | Name | string | 200 |
| ArtefactTable | artefact_table | Artefact Table | string | 200 |
| TargetTable | target_table | Target Table | string | 200 |
| TargetSubject | target_subject | Target Subject | string | 220 |
| DisplayOrder | display_order | Order | int | 80 |
| Version | version | Version | int | 80 |
| ModifiedBy | modified_by | Modified By | string | 120 |
| RecordedAt | recorded_at | Recorded At | timestamp | 150 |
See also
- ores.dq — component group overview.