test_run
| Column | Type |
|---|---|
| uniform_resource_id | VARCHAR |
| test_case_id | |
| run_date | |
| environment | |
| body |
SQL DDL
CREATE VIEW test_run AS
SELECT
uniform_resource_id,
json_extract(frontmatter, '$.test_case_fii') AS test_case_id,
json_extract(frontmatter, '$.run_date') AS run_date,
json_extract(frontmatter, '$.environment') AS environment,
json_extract(content_fm_body_attrs, '$.body') AS body
FROM uniform_resource
WHERE uri LIKE '%.run.md'