How rohanap/snowflake-h2s-chauras-final works
Insurance 360 is a Streamlit insurance-intelligence application: users explore policyholders and operational analytics, retrieve or ask questions about transcripts and data, inspect document/audio extraction, and dispatch outreach. The tree and excerpts show a newer command-center app alongside an earlier page set, with shared query and AI helpers. Snowflake is the evidenced runtime data/AI backend; the repository also contains bronze, silver, and gold data exports. Source excerpts are partial, so unsampled feature internals and uncertain wiring are represented conservatively.
Main entry points: streamlit_app.py Command Center · data_loader.py Snowflake Queries · 1_Customer_360.py Customer 360 · 2_NBA_Dashboard.py NBA Dashboard
Components 22
User Experience
- Command Center
Insurance_360_v2/streamlit_app.py - Shared Theme
CSV files/utils/theme.py
Customer Analytics
- Customer 360
Insurance_360_v2/pages/1_Customer_360.py - NBA Dashboard
Insurance_360_v2/pages/2_NBA_Dashboard.py - Segment Analytics
Insurance_360_v2/pages/3_Segment_Analytics.py - Ops Monitor
Insurance_360_v2/pages/7_Ops_Monitor.py - Legacy Customer 360
CSV files/pages/1_Customer_360.py - Legacy Segment Analytics
CSV files/pages/3_Segment_Analytics.py
AI Intelligence
- Transcript Explorer
Insurance_360_v2/pages/4_Transcript_Explorer.py - Ask Your Data
Insurance_360_v2/pages/5_Ask_Your_Data.py - Document AI
Insurance_360_v2/pages/6_Document_AI.py - Cortex RAG Router
Insurance_360_v2/utils/rag_agent.py - Legacy Ask Your Data
CSV files/pages/5_Ask_Your_Data.py - Legacy Transcript Explorer
CSV files/pages/4_Transcript_Explorer.py - Legacy Document AI
CSV files/pages/6_Document_AI.py - Legacy RAG Router
CSV files/utils/rag_agent.py
Data Platform
- Snowflake Queries
Insurance_360_v2/utils/data_loader.py - Email Dispatch
Insurance_360_v2/pages/_email_helpers.py - Legacy Data Queries
CSV files/utils/data_loader.py - Snowflake
Other components
- Insurance operator
- Email recipients
Connections 30
- Insurance operator → Command Center: opens
Insurance_360_v2/streamlit_app.py - Command Center → Customer 360: links to
Insurance_360_v2/streamlit_app.py - Command Center → NBA Dashboard: links to
Insurance_360_v2/streamlit_app.py - Command Center → Segment Analytics: links to
Insurance_360_v2/streamlit_app.py - Command Center → Transcript Explorer: links to
Insurance_360_v2/streamlit_app.py - Command Center → Ask Your Data: links to
Insurance_360_v2/streamlit_app.py - Command Center → Document AI: links to
Insurance_360_v2/streamlit_app.py - Command Center → Ops Monitor: links to
Insurance_360_v2/streamlit_app.py - Command Center → Snowflake Queries: queries
Insurance_360_v2/streamlit_app.py - Customer 360 → Snowflake Queries: loads records
Insurance_360_v2/pages/1_Customer_360.py - NBA Dashboard → Snowflake Queries: loads scores
Insurance_360_v2/pages/2_NBA_Dashboard.py - Segment Analytics → Snowflake Queries: loads cohorts
Insurance_360_v2/pages/3_Segment_Analytics.py - Transcript Explorer → Snowflake Queries: loads calls
Insurance_360_v2/pages/4_Transcript_Explorer.py - Ask Your Data → Snowflake Queries: loads data
Insurance_360_v2/pages/5_Ask_Your_Data.py - Document AI → Snowflake Queries: queries documents
Insurance_360_v2/pages/6_Document_AI.py - Ops Monitor → Snowflake Queries: loads status
Insurance_360_v2/pages/7_Ops_Monitor.py - Transcript Explorer → Cortex RAG Router: searches transcripts
Insurance_360_v2/pages/4_Transcript_Explorer.py - Ask Your Data → Cortex RAG Router: routes questions
Insurance_360_v2/pages/5_Ask_Your_Data.py - Customer 360 → Email Dispatch: dispatches email
Insurance_360_v2/pages/1_Customer_360.py - NBA Dashboard → Email Dispatch: dispatches email
Insurance_360_v2/pages/2_NBA_Dashboard.py - Email Dispatch → Email recipients: sends messages
Insurance_360_v2/pages/_email_helpers.py - Snowflake Queries → Snowflake: queries
- Cortex RAG Router → Snowflake: calls Cortex
Insurance_360_v2/utils/rag_agent.py - Legacy Customer 360 → Legacy Data Queries: loads records
CSV files/pages/1_Customer_360.py - Legacy Segment Analytics → Legacy Data Queries: loads cohorts
CSV files/pages/3_Segment_Analytics.py - Legacy Transcript Explorer → Legacy RAG Router: searches transcripts
CSV files/pages/4_Transcript_Explorer.py - Legacy Ask Your Data → Legacy RAG Router: routes questions
CSV files/pages/5_Ask_Your_Data.py - Legacy Customer 360 → Shared Theme: applies styling
CSV files/pages/1_Customer_360.py - Legacy Data Queries → Snowflake: queries
CSV files/utils/data_loader.py - Legacy RAG Router → Snowflake: calls Cortex
CSV files/utils/rag_agent.py