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)

Implementation Specs (157)

Detailed engineering and feature implementation specifications.

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

Raw File

TASK 3.1: Physically Create Source-Mirror KDS Curated Tables

Summary

Physically create the KDS 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.

The KDS Redshift object names must use the kds_ prefix and mirror the source tables needed by the branch, including curated.kds_orders, curated.kds_items, and curated.kds_item_bumps.

Dependencies

TASK 2.2 (internal warehouse structures)

Files to Create

1. Curated DDL/bootstrap artifacts for KDS objects

Create the physical KDS 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 KDS source-mirror curated objects are created for every tenant database.

Required Contract

The KDS curated tables must mirror the source KDS tables used by the current branch bootstrap and synthetic feed.

Examples include:

curated.kds_orders
curated.kds_items
curated.kds_item_bumps

Representative columns include:

guid
order_guid
store_guid
create_time
update_time
is_deleted
status
last_status

These tables should preserve source naming and source types closely enough to support the current source-mirror branch direction.

Acceptance Criteria

[x] curated.kds_orders is physically created as a table
[x] curated.kds_items is physically created as a table
[x] curated.kds_item_bumps is physically created as a table
[x] Column names follow the KDS source-mirror contract
[x] Redshift object names use the kds_ prefix rather than kdsdev_
[x] The table definitions exist as SQL artifacts in Kds.Ai.Warehouse
[x] Solution builds without errors

Notes

This task should align with the branch's source-mirror curated model.
The goal in this branch is source-table mirroring, not a canonical order projection.