Summary The [cdm].[patch_upsert] procedure acts as a controller for metadata inserts and updates. It dynamically evaluates JSON payloads, identifies whether an existing active row already exists, and determines whether to call an insert (post_insert) or update (put_update) operation. This ensures consistent versioned metadata with minimal redundancy. It supports JSON-driven payloads with field mapping based on … Read more
Summary The [cdm].[create_table] stored procedure dynamically builds SQL tables using metadata templates from cont.table_templates. It is used to create consistent core, meta or item tables within a specified schema, complete with partitioning, indexes, and insertion triggers for data integrity and metadata logging. This approach ensures repeatability, consistency, and automated setup of foundational table structures across … Read more
SFIA Reference: RLMT Level 4 Data Architect (Grade 3) Competency Description Participates in Agile planning and stakeholder forums to align architecture with business and platform roadmaps. Learning Outcomes Evidence Requirements Level 4: Suggested Learning Activities Recommended Resources
SFIA Reference: TECH Level 4 Data Architect (Grade 3) Competency Description Contributes to solution review processes and maintains architecture documentation in line with standards. Learning Outcomes Evidence Requirements Level 4: Suggested Learning Activities Recommended Resources
SFIA Reference: METL Level 4/5 Data Architect (Grade 3) Competency Description Collaborates with engineers to embed automation and version control within architectural assets and processes. Learning Outcomes Evidence Requirements Level 4: Suggested Learning Activities Recommended Resources
SFIA Reference: INAN Level 4 Competency Description Designs semantic models and curated datasets to support analytics, dashboards, and self-service BI. Learning Outcomes Evidence Requirements Level 4: Suggested Learning Activities Recommended Resources
SFIA Reference: GOVN Level 4/5 Data Architect (Grade 3) Competency Description Ensures that data architecture aligns with data governance policies, regulatory standards, and organisational controls. Learning Outcomes Evidence Requirements Level 4: Suggested Learning Activities Recommended Resources
SFIA Reference: IRMG Level 4/5 Data Architect (Grade 3) Competency Description Develops and applies metadata standards to improve discoverability, auditability, and consistency across data assets. Learning Outcomes Evidence Requirements Level 4: Suggested Learning Activities Recommended Resources
SFIA Reference: ARCH Level 4/5 Data Architect (Grade 3) Competency Description Designs data platform architectures that support scalable storage, processing, and integration using cloud-native tools. Learning Outcomes Evidence Requirements Level 4: Suggested Learning Activities Recommended Resources
SFIA Reference: DATM Level 4/5 Data Architect (Grade 3) Competency Description Designs enterprise data architecture and modelling patterns that support business agility, reporting, and data governance. Learning Outcomes Evidence Requirements Level 4: Suggested Learning Activities Recommended Resources