95 of 312 nodes

Typed view over raw_gcs.mdt_approval_rules — routing/approval config.

Typed view over raw_gcs.mdt_contacts — client contacts on an opportunity. Carries identity/contact PII (name/email/phone) keyed to contact_id.

Typed view over raw_gcs.mdt_devices — one row per device under test.

Typed view over raw_gcs.mdt_historical_matches — similarity edges.

Typed view over raw_gcs.mdt_opportunities. One row per Smithers job reference. Carries staff-lead PII (bdm/te/pm) keyed to opportunity_id; client_name + budget are confidential-commercial (not PII).

Typed view over raw_gcs.mdt_pricing_line_items — one cost line per device per proposal. rate + amount are confidential-commercial.

Typed view over raw_gcs.mdt_proposals — one issued/historical proposal per row. Carries staff-lead PII; total_rom + contingency are confidential-commercial.

Typed view over raw_gcs.mdt_rate_card — the synthetic per-test rate card (docs/smithers/rate-card-spec.md). One row per (test name, category). unit_rate_minor is GBP integer pence. Confidential-commercial (no PII).

Typed view over raw_gcs.mdt_rfps — the incoming RFP/RFQ intake pipeline (MVD Category 02). Carries intake-owner PII (bdm_owner); client_name + budget_indication are confidential-commercial.

Typed view over raw_gcs.mdt_sme_directory — named Smithers SMEs (PII).

Typed view over raw_gcs.mdt_standards — ISO/ASTM/USP standards catalog.

Typed view over raw_gcs.mdt_test_methods — one row per test per device.

Typed view over raw_gcs.product_reviews. Coerces the CSV's Nullable(String) columns into proper types and exposes a join-ready grain of review_id. customer_id / product_id are validated against the e-commerce dimensions so a stray CSV row that names an unknown customer or product fails dbt test rather than landing silently.

Typed view over raw_gcs.rfx_accounts. Coerces the CSV's Nullable(String) columns into proper types and exposes a join-ready grain of account_id — the account dimension every procurement opportunity and proposal keys off.

Typed view over raw_gcs.rfx_approval_rules. Coerces the CSV's Nullable(String) columns into proper types and exposes a grain of rule_id — the approval-workflow rule catalog.

Typed view over raw_gcs.rfx_contacts. Coerces the CSV's Nullable(String) columns into proper types, FK-validates account_id against stg_gcs__rfx_accounts, and exposes a grain of contact_id. Carries identity PII (name/email/phone) keyed to contact_id.

Typed view over raw_gcs.rfx_opportunities. Coerces the CSV's Nullable(String) columns into proper types, FK-validates account_id and owner_sme_id, derives issued_month, and exposes a grain of rfx_id — the spine of the procurement domain.

Typed view over raw_gcs.rfx_permissions. Coerces the CSV's Nullable(String) columns into proper types and exposes a grain of permission_id — the procurement RBAC matrix.

Typed view over raw_gcs.rfx_price_book. Coerces the CSV's Nullable(String) columns into proper types, FK-validates sku against stg_gcs__rfx_products_services, and exposes a grain of price_book_id.

Typed view over raw_gcs.rfx_products_services. Coerces the CSV's Nullable(String) columns into proper types and exposes a grain of sku — the quotable product/service catalog.

Typed view over raw_gcs.rfx_proposals. Coerces the CSV's Nullable(String) columns into proper types, FK-validates rfx_id and lead_author_sme_id, and exposes a grain of proposal_id. Won/lost proposals carry a source_uri into the historical-proposals corpus.

Typed view over raw_gcs.rfx_sme_directory. Coerces the CSV's Nullable(String) columns into proper types and exposes a grain of sme_id. Carries identity PII (name/email) for internal employees.

Typed view over raw_gcs.whse_approval_rules. Coerces the CSV's Nullable(String) columns into proper types and exposes a grain of rule_id — the approval-workflow rule catalog. Demonstration content only. No PII.

Typed view over raw_gcs.whse_clients. Coerces the CSV's Nullable(String) columns into proper types and exposes a join-ready grain of client_id — the multi-tenant isolation key every client-keyed table (orders, inventory, returns) carries. Holds client-contact PII (name/email).

Typed view over raw_gcs.whse_consignees. Coerces the CSV's Nullable(String) columns into proper types and exposes a grain of consignee_id — the B2C delivery recipients. Carries consumer identity/contact/location PII keyed to consignee_id — the primary Art. 15/17 DSR subject.

Typed view over raw_gcs.whse_contracts. Coerces the CSV's Nullable(String) columns into proper types, FK-validates client_id and site_id, and exposes a grain of contract_id. Every row carries a source_uri into the client-sla-contracts corpus. No PII on the structured row.

Typed view over raw_gcs.whse_inventory. Coerces the CSV's Nullable(String) columns into proper types, FK-validates sku and site_id, and exposes a grain of lot_id — live stock positions. Carries a denormalized client_id for the row policy, asserted equal to the product owner (INC-22). No PII.

Typed view over raw_gcs.whse_order_lines. Coerces the CSV's Nullable(String) columns into proper types, FK-validates order_id and sku, and exposes a grain of order_line_id — the line grain behind pick accuracy. An INC-22 integrity test asserts each line's SKU belongs to the parent order's client. No PII.

Typed view over raw_gcs.whse_orders. Coerces the CSV's Nullable(String) columns into proper types, FK-validates client_id/site_id/consignee_id, derives ship_month, and exposes a grain of order_id — the outbound fulfillment spine and the table the tenant-isolation gate reads. PII indirect (consignee_id points at PII; the order row holds no direct PII).

Typed view over raw_gcs.whse_permissions. Coerces the CSV's Nullable(String) columns into proper types and exposes a grain of permission_id — the warehousing RBAC matrix. Demonstration content only. No PII.

Typed view over raw_gcs.whse_products. Coerces the CSV's Nullable(String) columns into proper types, FK-validates client_id, and exposes a grain of sku — the client-owned catalog. Hazardous SKUs carry a source_uri into the safety-data-sheets corpus. No PII.

Typed view over raw_gcs.whse_returns. Coerces the CSV's Nullable(String) columns into proper types, FK-validates order_id, and exposes a grain of return_id — returns disposition and cycle time. Carries a denormalized client_id asserted equal to the parent order (INC-22). No PII.

Typed view over raw_gcs.whse_sites. Coerces the CSV's Nullable(String) columns into proper types and exposes a grain of site_id — the physical warehouse network. No PII.

Typed view over raw_gcs.whse_staff. Coerces the CSV's Nullable(String) columns into proper types, FK-validates site_id, and exposes a grain of staff_id — the warehouse workforce. Carries employee identity/contact PII keyed to staff_id.

Typed view over raw_gcs.whse_temperature_events. Coerces the CSV's Nullable(String) columns into proper types, FK-validates lot_id, and exposes a grain of event_id — cold-chain excursions. Staging-only (no mart/metric/row-detail in P0/P1). No PII, but a retention anchor (legal_obligation, 1825 days).

Customer shipping/billing addresses with a validity window. Strips Nullable() on PK + FK so MergeTree marts can use them as sort keys; normalises `country` to ISO-2 uppercase (matches `stg_postgres__customers`).

Support agents (humans). Joins to support_tickets on agent_id. Dedupes by agent_id keeping the most-recently-extracted row.

AP payment→bill allocation bridge typed from raw_postgres.

AP payments typed from raw_postgres. Statutory record keyed to a vendor; adds `payment_day`.

Polymorphic approval steps typed from raw_postgres. `object_id` is a soft FK keyed by object_type (no relationship test).

AR receipt→invoice allocation bridge typed from raw_postgres.

AR receipts typed from raw_postgres. Reuses the ecommerce `customer`; carries source_payment_id (H4); adds `receipt_day`.

Append-only audit log typed from raw_postgres. old_value/new_value are free-text PII (retain_aggregate).

Bank accounts typed from raw_postgres. Each maps to a GL cash account.

Bank-statement transactions typed from raw_postgres. `counterparty_name` incidental financial PII; adds `transaction_day`.

Vendor-bill lines (AP) typed from raw_postgres. `description` is incidental free-text PII (nullify).

Budget amounts per (budget, gl_account, cost_center, period) typed from raw_postgres.

Budget headers (FP&A) typed from raw_postgres.

Chat-channel metadata typed from raw_postgres. `topic` is free-text PII. Comms — legitimate_interest + 365d.

Chat-message metadata + body typed from raw_postgres. `body_text` is free-text PII; adds `posted_day`.