Link Search Menu Expand Document

Data Storage

Data Architecture Management

Standard TL;DR
ADW Integration Layer Model Standards (...) The data modelling standards for the ADW Integration Layer Model
ADW Naming Conventions (...) The naming conventions for objects in ADW
ADW Presentation Layer Model Standards (...) The data modelling standards for the ADW Presentation Layer Model
ADW Staging Layer Conventions (...) The naming conventions for objects in ADW Staging Layer
Logical Data Model Standards (...) The data modelling standards for the Logical Data Model
Split PL Schemas by IRM (...) Split PL Schemas by IRM
ADW Technical Column Standards (...) The data modelling standards for the ADW Technical Column Standards
Temporary Schema (...) The data modelling standards for the usage of the Temporary Schema in Aspire
Transform Schema (...) The data modelling standards for the usage of the Transform Schemas in Aspire

Data Warehousing

Standard TL;DR
Aspire Data Warehouse Design Artefacts Deprecation Standards (...) Design Artefacts Deprecation Standards
Aspire Data Warehouse IRM tagging standards (...) IRM tagging procedure to be followed when a new /old object has to be associated with an IRM tag
Aspire Data Warehouse RDV Immutability Standards (...) The following immutability chart has to be followed when handling data in RDV.
Data Experimentation (...) All experimental work will only take place in the `SCRATCH.WORKSPACE` Database & Schema.
Hashed and Encrypted Column Naming Conventions (...) Hashed and Encrypted Column Naming Conventions
ASPIRe Data Warehouse Naming Conventions (...) The following naming conventions should be applied to objects in the ASPIRE Data Warehouse.
Object Structure Conventions (...) 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.
Snowflake Time Travel (...) This standard defines the default time travel period for Snowflake tables.
Snowflake warehouse default auto-suspend time (...) The default auto-suspend time on the warehouses is 59 seconds.