Spensara Spensara Knowledge Base & Documentation Repository

Repository Docs & Knowledge Base

Consolidated Spensara documentation repository (722 Markdown & architecture documents in ../repository)
Built Word Documents (.docx): Spensara Overview (.docx) Capability Assessment (.docx) Brink POS Ingestion Analysis (.docx) The Borg Ingestion Architecture (.docx)

Branches (328)

Branch-specific documentation across extract-raw-xml, feature-fleet-import, kds_cdc_improvments, life-cycle, and tenat-admin.
branches/extract-raw-xml/implementation-specs/specs/BrinkPosOrdersFirstEtlJob/TASK6.md 499 bytes · Updated Oct 23, 2026 10:44 AM EDT
Raw File

TASK 6: Staging To Curated

Summary

This task will implement the business-facing SQL mapping from Redshift staging into curated.pos_orders and curated.pos_order_items. It will freeze the exact dependency matrix and field behavior for the first useful order-centric warehouse outputs.

Placeholder

This task will be elaborated in the next step. It will include mandatory unit tests for mapping rules and live E2E that verifies curated rows created in Redshift from real staging data.