Link Search Menu Expand Document

Data Storage

Data Architecture Management

Principle TL;DR
ASPIRE Data Model Principles (...) The data modelling principles for ASPIRE
Legal and Binding Compliance (...) Data stores must comply with all relevant laws, policies, regulations and standards of good practice regarding the storing, processing, sharing and viewing of data.
Create Consistent Keys (...) Surrogate keys (system generated unique identifiers) must be assigned when the data is cleansed, conformed and integrated.
Share Data (...) Data from the various source systems must be conformed and consolidated (where appropriate) into integrated views which will be shared with all authorised users.

Data Warehousing

Principle TL;DR
Data Immutability (...) Data should be immutable once written to storage.
Data Persistence (...) Data held in the ASPIRe data platform should be persisted.
Maintain Change History (...) Change history must be maintained for the data elements using the appropriate industry standard techniques.
Snowflake Private link (...) Use of AWS Private link for all connections to Snowflake