Metric
Table schema for metrics and evaluation results.
Last updated
Was this helpful?
Table schema for metrics and evaluation results.
Schema reference for metric definitions and the evaluation results they produce.
Table Name: metrics
Description: Metric definitions for evaluation and monitoring
_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 }
SELECT
name,
description,
applied_to_services,
metric_value
FROM metrics
WHERE is_deleted = false;Table Name: metric_evaluation_results
Description: Results from metric evaluations
_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
Last updated
Was this helpful?
Was this helpful?
SELECT
metric_id,
result,
justification,
source,
created_at
FROM metric_evaluation_results
ORDER BY created_at DESC;
