Sable Overview
Sable is the P&L analytics platform that processes and visualizes investment performance data for AIC Holdings.
Components
| Component | URL | Description |
|---|---|---|
| Sable App | sable.jettaintelligence.com | Main analytics dashboard |
| Sable Data | sable-data.jettaintelligence.com | dbt transformation pipeline & API |
| Chat Sable | chat.sable.jettaintelligence.com | AI-powered data queries |
Architecture
┌─────────────────────────────────────────────────────────────────┐
│ DATA SOURCES │
│ BTIG Files (CSV) → Supabase Storage → file_upload table │
└─────────────────────────────────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ MEDALLION LAYERS │
│ Bronze (raw TEXT) → Silver (typed) → Gold (enriched views) │
│ via dbt models │
└─────────────────────────────────────────────────────────────────┘
│
▼
┌─────────────────────────────────────────────────────────────────┐
│ PRESENTATION │
│ Sable Dashboard │ Chat Sable (AI) │ API Endpoints │
└─────────────────────────────────────────────────────────────────┘
Key Features
- Modified Dietz Returns - Time-weighted return calculations matching BTIG
- Position Tracking - Daily NAV, P&L, and position changes
- Cash Flow Analysis - Fund flows, contributions, and redemptions
- Risk Metrics - Beta, Sharpe ratio, drawdowns
- BTIG Reconciliation - Automated comparison with prime broker data
Tech Stack
| Layer | Technology |
|---|---|
| Database | PostgreSQL (Supabase) |
| Transformations | dbt (Data Build Tool) |
| Orchestration | Dagster |
| Backend API | FastAPI (Python) |
| Frontend | Next.js |
| AI Queries | Claude via Artemis |
Quick Links
- Getting Started - Developer onboarding
- Data Pipeline - How data flows through Sable
- Returns - Return calculation methodology
- Performance - Query optimization patterns