Object Structure Conventions

urn:js:virtue:aspire:standard:5.1

TL;DR

This entry covers any patterns we should follow relevant to particular object types in the ASPIRe Data Warehouse. Where relevant it will reference URNs for patterns which can be found under the _patterns folder structure.

Definition

The following sections define the patterns that need to be adhered to.

Staging Schema (ADW_STAGE)

Staging tables should follow a set pattern based on whether they are populated with data that is semi-structured, or structured. Please refer to the URN urn:js:virtue:aspire:pattern/staging_table_structure.

Raw Data Vault (ADW_RDV)

TBC…