stg_gcs__whse_order_lines

staging view

Order lines and pick accuracy, typed and FK-validated.

Definition

Cleaned mirror of `raw_gcs.whse_order_lines`. Coerces the CSV's `Nullable(String)` columns into typed equivalents and enforces FKs to `stg_gcs__whse_orders` and `stg_gcs__whse_products`. Aggregated into mart_fulfillment_daily → metric_pick_accuracy. An INC-22 integrity test hardens tenant isolation: a line's SKU must belong to the parent order's client.

13 of 13

Column

Description

Tests · PII

order_line_id

UUID5 from the source CSV. Primary key.

2 tests

order_id

Foreign key to stg_gcs__whse_orders — the parent order.

customer +3 PII2 tests

sku

Foreign key to stg_gcs__whse_products — the SKU picked. INC-22 model-level integrity test asserts it belongs to the parent order's client_id.

2 tests

line_no

1-based line index within the order. Coerced from String → UInt16.

units_ordered

Units ordered on this line. Coerced from String → Int32.

1 test

units_picked

Units picked (≤ units_ordered; short-picks drive is_in_full). Coerced from String → Int32.

pick_time_sec

Time to pick the line in seconds. Coerced from String → Int32.

unit_price_eur

Unit price in EUR. Coerced from String → Decimal(14,2).

is_accurate

1 if the line was picked correctly, else 0. Coerced from the CSV's "true"/"false" strings.

1 test

is_short_pick

1 if units_picked < units_ordered, else 0. Coerced from the CSV's "true"/"false" strings.

1 test

source_file_url

Airbyte-supplied `_ab_source_file_url` — the gs:// URI the row came from.

source_file_modified_at

Airbyte-supplied `_ab_source_file_last_modified` — object mtime of the source file.

airbyte_extracted_at

When Airbyte extracted this row from GCS.