{
  "skill": {
    "id": "skl_session_telemetry_erd",
    "name": "session-telemetry-erd",
    "plugin": "cwc-data-engineering",
    "description": "The session-telemetry ERD and durable data spine under the Coworkers sprint board — TWO layers, fivetran-style. (1) The CONNECTOR layer (`connector_schema.sql` + connector.py): source-shaped tables named after the REAL fivetran claude-compliance/claude-platform connector entities (organization, chat, chat_message, chat_message_usage w/ exact message_usage_report_result token columns, project, model, skill, claude_code_usage_report) plus the Cowork SDK's own on-disk shapes (cowork_vm_session from bridge-state.json's environmentId/remoteSessionId/processedMessageUuids), scoped to what a claude.ai 20x subscription can ACTUALLY capture — everything else lives in the UNAVAILABLE ledger (rendered as the ERD's dark legend callout) with the API each table would need. `uv run telemetry-erd connector-sync --db <file> [--plugins …] [--email …]` syncs the real Mac sources; `connector-erd --out <svg>` renders the fivetran-grammar ERD; `connector-schema` prints the DDL. (2) The MART layer (`schema.sql`): Kimball fact_/dim_ star schema (fact_task/fact_session_event/dim_coworker/dim_sprint/dim_status) derived downstream for the sprint board, with the cross-language PARITY guard (Swift CoworkersModel ↔ task-session JSON schema ↔ SQL). `load --board <board-state.json>` / `schema` as before. NEVER invent fact_/dim_ names at the capture layer — capture is source-shaped; marts are derived. Use for session/board/telemetry modeling, the claude.ai connector equivalent, ERDs, cross-language parity. Trigger on \"connector\", \"fivetran\", \"ERD\", \"star schema\", \"fact table\", \"Kimball\", \"session telemetry\", \"cowork vm data\", \"usage report\". Do NOT use for WBR analysis (cwc-data), Cloudflare snapshots (cwc-analytics-engineering), or the Swift UI (cwc-swift-engineering).",
    "summary": "The session-telemetry ERD and durable data spine under the Coworkers sprint board — TWO layers, fivetran-style.",
    "gated": 0,
    "source_path": "plugins/cwc-data-engineering/skills/session-telemetry-erd/SKILL.md",
    "created_at": "2026-07-10 18:13:13",
    "cite_as": "https://subagentskills.com/api/skills/skl_session_telemetry_erd"
  }
}