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
(Revised for SFIA-8 Alignment) Overview As a Data Architect (Grade 3), you design and evolve data architectures that underpin reliable, scalable, and secure data systems. Working across data domains, you shape how data is structured, integrated, and governed across platforms and applications. You collaborate with engineers, analysts, scientists, and governance teams to ensure that enterprise … Read more