# 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.