app.undtec.com / integrations / data-warehouse
Underwriters Technologies
Dashboard
Policies
Claims
Integrations
Reports
Live Stream
SR
S. Reeves — Data Admin
Integrations
Overview
Webhook Events
Snowflake Sync
HubSpot CRM
CareMC Connect
Configuration
Event Filters
Schema Map
Retry Queue
API Credentials
Data Warehouse & Event Streaming
Snowflake
HubSpot
CareMC
Webhook Event Stream
Live
14
events/min
Timestamp
Event Type
Reference
Size
Destination
Status
09:47:32.118
policy.bound
WC-2025-04733
4.2 KB
Snowflake
Delivered
09:47:28.441
policy.bound
WC-2025-04733
1.8 KB
HubSpot
Delivered
09:44:11.790
claim.updated
CLM-2025-08831
2.9 KB
Snowflake
Delivered
09:44:10.002
claim.updated
CLM-2025-08831
1.1 KB
CareMC
Delivered
09:41:55.300
reserve.changed
CLM-2025-08814
0.9 KB
Snowflake
Delivered
09:38:04.667
endorsement.issued
END-2025-00412
3.4 KB
Snowflake
Delivered
09:38:01.219
endorsement.issued
END-2025-00412
2.1 KB
HubSpot
Pending
09:33:47.882
audit.triggered
WC-2024-03641
1.7 KB
Snowflake
Delivered
09:29:12.044
claim.updated
CLM-2025-08792
2.2 KB
CareMC
Error
09:25:38.511
policy.renewed
WC-2024-03887
5.1 KB
Snowflake
Delivered
09:25:35.208
policy.renewed
WC-2024-03887
1.9 KB
HubSpot
Delivered
09:18:20.776
reserve.changed
CLM-2025-08763
0.8 KB
Snowflake
Delivered
Snowflake Connection
Connected
❄
Snowflake Data Cloud
Active
Account
cw7291.••••••.aws
Warehouse
CAREWEST_WH_XL
Database
CAREWEST_PROD
Schema
WC_OPERATIONS
Role
UT_LOADER_ROLE
Last Sync: Success
Today 09:47:34
Data Tables in Warehouse
TB
policies
Core policy records
3,193
09:47 today
TB
claims
All claim transactions
14,882
09:44 today
TB
payroll
Exposure payroll by class
28,441
09:30 today
TB
audit_records
Premium audit history
4,117
09:33 today
TB
class_codes
NCCI / WCIRB reference
2,048
Apr 1, 2025
TB
agencies
Broker / agency records
312
08:15 today
TB
loss_runs
5-year loss run exports
9,654
Apr 9, 2025