Declare source systems, author source.md files, and define field-level transformations.
npx skills add https://github.com/Semprini/md-ddl --skill source-mapping
Please help me install this Agent Skill. Skill: source-mapping Source: https://github.com/Semprini/md-ddl/tree/main/agents/agent-ontology/skills/source-mapping Command: npx skills add https://github.com/Semprini/md-ddl --skill source-mapping
This Skill streamlines the process of connecting disparate source systems to a unified canonical data model, ensuring data consistency and enabling reliable data product generation.
cust_id, first_nm) to your canonical Customer.customerId and Customer.firstName attributes, defining any necessary transformations.Use the source-mapping skill to declare the 'Salesforce CRM' system and map its 'Account' table to the 'Organization' entity.
High-intent search queries and answers about installing and using this skill.
To map source data to a canonical model, you author source.md files to declare source systems and define field-level transformations that connect operational system feeds to unified domain entities. This ensures data consistency across disparate sources.
Field-level transformation in ETL data mapping is the process of defining detailed rules to convert source fields, like cust_id, into canonical attributes, like Customer.customerId. It connects operational systems to domain models for reliable data product generation.
You document source systems and data lineage by declaring source systems, their capabilities, and change signals. This creates domain feed tables and source.md files that answer data lineage questions and map feeds to canonical entities.
Yes, you can map complex CRM data structures to a unified domain model. The process supports defining detailed field-level transformations, allowing you to map source tables like an Account table directly to a canonical Organization entity.
The best way to integrate a new operational system is to declare the system, author source.md files to document its capabilities, create domain feed tables, and define field-level transformations to map its fields to canonical entities.
You need to create domain feed tables when connecting disparate operational source systems to a unified canonical data model. They serve as the structured intermediary for defining field-level transformations and generating reliable data products.
SempriniConvert database schemas and ETL logic into draft MD-DDL domain models.
pointwareBuild idempotent ETL pipelines with incremental extraction and schema validation.
timequityEnforce data governance across data pipelines with lineage tracking and access controls.
PranavNagrechaCompare Salesforce org metadata to identify drifts, changes, and field mappings.