Document Classification: Internal — CHLOM Confidential
Phase: 0 → 1
Owner: CrownThrive, LLC
Last Updated: 2025-08-08
A — Purpose & Scope
Centralized, governed store for features used by CE models and rules; supports low-latency reads and reproducible historical snapshots.
B — Logical Model
- Feature Group: logical set
- Entity Key:
- Time Column:
- Metadata:
C — Physical Layout
- Write Path (OLTP): PostgreSQL tables per feature group (narrow columns; JSONB for sparse).
- Read Path (Analytics): Delta Lake partitions by
- Change Data Capture: Debezium → Kafka → Delta writers.
D — Security & Governance
- Row-Level Security by tenant and purpose.
- Column encryption for sensitive attributes (FPE for phone, partial for email).
- Access via service accounts only; no analyst direct access to Restricted class.
E — Quality & SLAs
- Freshness monitors; lag > 5 min pages SRE.
- Completeness/dbt tests block promotion to
- Drift monitors publish to
F — Sample Schemas
Table: features_identity_v1
entity_id TEXT,
country_code CHAR(2),
age_bucket TEXT,
phone_fpe TEXT,
email_prefix_hash TEXT,
asof_ts TIMESTAMPTZ,
lineage_id UUID,
policy_bundle_id TEXT
Delta: features_risk_signals_v1
entity_id STRING,
pep_flag BOOLEAN,
watchlist_hits INT,
network_degree INT,
last_seen_ts TIMESTAMP,
asof_ts TIMESTAMP,
lineage_id STRING,
policy_bundle_id STRING
G — Operations
- Compaction weekly; optimize Z-order on
- VACUUM with 7-day retention; align with erasure manifests.
- Backups: PITR on Postgres; versioned buckets on Delta.
H — Interfaces
- gRPC/HTTP read APIs for CE; batched reads with
- Kafka sink for feature change events (
I — Runbooks
- /runbooks/feature-store-oltp-degradation.md
- /runbooks/delta-lake-vacuum-incident.md
- /runbooks/drift-spike.md