Objective

Add test lifecycle information from openshift-tests-extension (OTE) to the BigQuery JUnit table.  Additionally we want to consider the request in TRT-2326. We discussed the value of having this data in the main Junit table to avoid joins so tracking OTE metadata including repo and the test path is being added to this card for inclusion in the main table.

Current State

The BigQuery JUnit table currently stores test results but does not include OTE metadata like lifecycle (blocking/informing/etc.), test repo or test path from OTE.

Proposed Solution

Add a lifecycle, test_repo, test_path column to the BigQuery JUnit table and populate it with the test lifecycle state from OTE test metadata.

Acceptance Criteria

• lifecycle column added to BigQuery JUnit table schema
• test_repo column added to BigQuery JUnit table schema
• test_path column added to BigQuery JUnit table schema
• OTE test lifecycle data is populated for all test results
• Column supports potential future lifecycle values (e.g., experimental, excluded)

Use Cases

• Component readiness filtering (e.g., excluding new informing tests during stabilization)
• General test analysis and reporting by lifecycle stage