Repository Docs & Knowledge Base

Consolidated Spensara documentation repository (722 Markdown & architecture documents in ../repository)

Detailed engineering and feature implementation specifications.

implementation-specs/specs/RedshiftFoundation/TASK3.3.md 1,589 bytes · Updated Oct 23, 2026 10:44 AM EDT

Raw File

TASK 3.3: Physically Create Source-Mirror Labpos Curated Tables

Physically create the Labpos source-mirror curated tables in every tenant database.

This task follows the same source-mirror branch direction as the KDS and Aloha bootstrap artifacts.

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

Create the physical Labpos source-mirror curated tables.

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

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

Physically create Labpos source-mirror curated.<table> objects
Preserve Labpos source table names with the labpos_ prefix in Redshift
Keep the definitions aligned with the generated source model rather than inventing canonical projections