metric_info_view
| Column | Type |
|---|---|
| metric_id | TEXT |
| metric_name | TEXT |
| Metrics Description | |
| formula | |
| Metrics Details | |
| Axes Details |
SQL DDL
CREATE VIEW metric_info_view AS
SELECT
metric_id,
metric_name,
json_extract(metric_info, '$.description') AS "Metrics Description",
json_extract(metric_info, '$.formula') AS formula,
json_extract(metric_info, '$.metrics') AS "Metrics Details",
json_extract(metric_info, '$.axes') AS "Axes Details"
FROM
metric_definitions