Link Search Menu Expand Document

Data Warehousing

Standard TL;DR
ASPIRe Data Warehouse Naming Conventions (...) The following naming conventions should be applied to objects in the ASPIRE Data Warehouse.
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
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.