Metric

Table schema for metrics and evaluation results.

Schema reference for metric definitions and the evaluation results they produce.

Metrics Table

Table Name: metrics Description: Metric definitions for evaluation and monitoring

Schema

Column	Type	Description
_id	string	Metric identifier
additional_notes	string	Additional notes
applied_to_services	array<string>	Associated service IDs
created_at	timestamp	Creation timestamp
creator	json	Creator information
description	string	Metric description
is_deleted	boolean	Deletion status
metric_value	json	Value definition (type, bounds)
metric_value_type	string	Type of metric value
name	string	Metric name
org_id	string	Organization identifier
region_name	string	Deployment region
tags	json	Associated tags
updated_at	timestamp	Last update timestamp
updated_by	json	Last updater info { org_id, user_id }

Query Example

SELECT
  name,
  description,
  applied_to_services,
  metric_value
FROM metrics
WHERE is_deleted = false;

Metric Evaluation Results Table

Table Name: metric_evaluation_results Description: Results from metric evaluations

Schema

Column	Type	Description
_id	string	Evaluation result ID
created_at	timestamp	Creation timestamp
justification	string	Result justification
metric_id	string	Associated metric ID
metric_version_id	string	Associated metric version ID
org_id	string	Organization identifier
references	json	Referenced message IDs used to compute the result
region_name	string	Deployment region
result	string	Evaluation result (NULL if the metric was not applicable)
run_index	integer	Run index within the unit test (simulation sources)
simulation_unit_test_set_run_id	string	Associated unit test set run ID (simulation sources)
source	json	Source information
source_type	string	Type of source
unit_test_id	string	Associated unit test ID (simulation sources)
updated_at	timestamp	Last update timestamp

Query Example

SELECT
  metric_id,
  result,
  justification,
  source,
  created_at
FROM metric_evaluation_results
ORDER BY created_at DESC;