Data Model Overview

The BYOC Cluster Health system uses three StarRocks databases, each serving a distinct purpose.

Database	Tables	Purpose
metrics	7 tables/views	Raw and aggregated cluster metrics, customer profiles
byoc	16 tables	Core entities: orgs, accounts, clusters, resources, billing
alerts	3 tables	Parsed Lark alert messages and daily recommendations

Cross-Database Relationships

Key ID Patterns

Understanding the two ID formats is critical for writing correct JOINs:

Format	Example	Used by
Short alphanumeric biz_id	aorpc2fr3	accounts, organizations
UUID biz_id	f2f593e4-3880-...	clusters, resource, resource_node, billing_order

• account_id in child tables (clusters, bill_detail, metrics_table) references accounts.biz_id (short form).
• region_id is a UUID that maps to region_details.region_id for display names.
• cluster_id in metrics and alerts is a UUID matching clusters.biz_id.