Spensara Spensara Knowledge Base & Documentation Repository
System Overview Brink & Borg Master Index (722 Docs) Spensara Platform Project Tracker

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)

Categories

Implementation Specs (157)

Detailed engineering and feature implementation specifications.
implementation-specs/specs/RedshiftFoundation/TASK3.2.md 1,488 bytes · Updated Oct 23, 2026 10:44 AM EDT
Raw File

TASK 3.2: Physically Create Source-Mirror Aloha Curated Tables

Summary

Physically create the Aloha source-mirror curated tables as part of the phase-1 runtime surface.

Status: implemented as part of TASK 2.2 so the tenant bootstrap creates the full phase-1 curated surface in one pass.

Dependencies

  • TASK 2.2 (internal warehouse structures)

Files to Create

1. Curated DDL/bootstrap artifacts for Aloha objects

Create the physical Aloha source-mirror curated tables.

The table definitions should live as explicit SQL artifacts in Kds.Ai.Warehouse.

Files to Modify

2. Bootstrap workflow artifacts as needed

Extend bootstrap creation so Aloha source-mirror curated objects are created for every tenant database.

Required Contract

The Aloha curated tables must mirror the source Aloha tables generated into the tenant bootstrap.

Examples include:

  • curated.aloha_<table> objects generated from the Aloha source model

These tables should preserve source table names and source-aligned column naming in Redshift.

Acceptance Criteria

  • [x] Aloha source-mirror curated tables are physically created
  • [x] Redshift object names use the aloha_ prefix
  • [x] Source table names are preserved in the generated curated surface
  • [x] The table definitions exist as SQL artifacts in Kds.Ai.Warehouse
  • [x] Solution builds without errors

Notes

  • This task is source-mirror bootstrap work, not a monitor-facing canonical projection.