stg_gcs__mdt_test_methods

staging view

Tests per device, typed.

Definition

One row per (device, test) — the technical scope behind a proposal.

14 of 14

Column

Description

Tests · PII

test_method_id

UUID5 primary key.

2 tests

opportunity_id

FK to stg_gcs__mdt_opportunities.

device_id

FK to stg_gcs__mdt_devices.

2 tests

device_nickname

Denormalized device nickname join key.

test_name

Test name (e.g. Cap removal force, Delivered volume).

1 test

method_reference

Smithers internal method id, if given.

standards

Flattened list of cited standard references.

replicates_per_variant

Replicate count per variant.

acceptance_criteria

Pass/fail criteria; null for characterisation-only tests.

sequence_position

Position in the test sequence (e.g. "A, 1").

method_confidence

Provenance of the method selection.

1 test

source_file_url

Airbyte _ab_source_file_url.

source_file_modified_at

Airbyte source object mtime.

airbyte_extracted_at

When Airbyte extracted this row.