Learn what Missions and Tasks are, how they relate, and how to create a Mission end-to-end.
Role | Who executes | Responsibilities | Examples |
---|---|---|---|
Mission Owner | Human | Defines scope/success, prioritizes, approves, receives reports | Data Platform Lead, Analytics Manager |
Task Owner | Human or Bot | Executes the step, updates status, attaches artifacts | Engineer, FieldMappingAgent, DbtBuildingAgent |
Stakeholder | Human | Consumes updates, reviews outputs, gives sign-off | Product Owner, Data Steward |
Define the Mission
Genesis creates tasks
Genesis sets dependencies
Configure escalation
Execute & attach
Validate outcomes
Close the Mission
Creating the Healthcare Data Pipeline Mission
Mission definition
project.yml
HCLS_DEMO_1_SOURCES
(bronze)informatica_legacy
Genesis Uses These Allowed Source Tables
HCLS_DEMO_1_SOURCES.HCLS_DEMO_1_SOURCES.MAIN.CLAIMS
HCLS_DEMO_1_SOURCES.HCLS_DEMO_1_SOURCES.MAIN.CLAIM_DETAILS
HCLS_DEMO_1_SOURCES.HCLS_DEMO_1_SOURCES.MAIN.PATIENTS
HCLS_DEMO_1_SOURCES.HCLS_DEMO_1_SOURCES.MAIN.PROVIDERS
Genesis Targets These Tables
CLAIM_SUMMARY
PROVIDER_SUMMARY
PATIENT_SUMMARY
Genesis Follows The Suggested The Success Criteria
materialized=“table”
)Task blueprint (with dependencies)
FieldMappingAgent (init)
and DbtBuildingAgent (init)
CLAIMS
, CLAIM_DETAILS
, PATIENTS
, PROVIDERS
(types, samples)CLAIM_SUMMARY
mapping spec — columns: CLAIM_ID, CLAIM_DATE, PATIENT_ID, PROVIDER_ID, CLAIM_TYPE, CLAIM_STATUS, PRIMARY_DIAGNOSIS, TOTAL_CHARGE, INSURANCE_PAID, PATIENT_RESPONSIBILITY; include joins + brief SQL snippet. Depends on: 1, 2PROVIDER_SUMMARY
mapping spec — aggregations: TOTAL_CLAIMS, UNIQUE_PATIENTS, TOTAL_CHARGES, TOTAL_PAID, DENIAL_RATE, REPORT_YEAR, REPORT_MONTH; include joins + brief SQL. Depends on: 2PATIENT_SUMMARY
mapping spec — join CLAIMS and PATIENTS on PATIENT_ID
; derivations: PATIENT_FULL_NAME, PATIENT_AGE, AGE_GROUP, REPORT_YEAR/MONTH, totals; include brief SQL. Depends on: 2materialized=“table”
via tooling; avoid inline config blocks; use substr()
instead of substring()
. Depends on: 6PROVIDER_ID
exists in PROVIDERS
). Depends on: 7sqlite_master
, PRAGMA table_info
, sample queries; attach results/logs. Depends on: 8