Adobe OEM — Development Log

2026-07-07 — Hex child-app detail: two auto-updating tables on Month-over-Month tab

Session: adobe-oem-dashboard (Hex report edits via browser).

What happened: - Adobe asked for a detailed CSV of which child apps drive search. Built it in the Hex report ("Adobe OEM Usage", owned by Michael Pankonien). - First tried an interactive Production/Staging dropdown feeding one SQL cell ({{ parent }}). It works on-demand in the editor but fails on every publish ("This SQL cell has no results"). Proven across 4 variants: raw-Databricks CASE, in-memory dataframe, is defined guard, and a renamed child_env variable. Root cause: a late-added dropdown driving a single cell does not bind on Hex's published app-run. - Pivoted (user's call) to two separate no-input tables: Production (SQL 146, EX9JOVML7S, 1,727 rows, top GTH4AUT0Y6 6,447,429) and Staging (SQL 148, J50O6J0MJP, 144 rows, top HZ9GMWFEDD 40,257,032). Each has app_id + downloadable CSV. Both read the materialised dataframe stage_prod_adobe_child_apps (billing basis: search = SUM(monthly_search_requests_excluding_query_suggestions) this term; records = MAX(child_monthly_records)), so they refresh weekly like the other tables. - Tab assignment mechanic learned: move a cell onto an app tab with the per-cell "ADD TO TABS" panel icon (top-right of the cell), NOT the "…" → "Add to section" (that's notebook grouping and shows "No existing sections"). Assigned both tables + both headings to Month-over-Month Usage, then deleted the standalone "App Detail (CSV)" tab (deleting a tab does not delete its cells). - Published and verified live at /app/Adobe-OEM-Usage-7DRNx1Y3TVEa4DKwNpXZaf/latest?tab=month-over-month-usage — both tables render, App Detail tab gone.

Decisions locked: - Child-app detail = two tables (not a dropdown, not one combined table). Weekly-published Hex cells must be no-input. - Email/report numbers use combined (prod+staging) term-relative basis (search = combined lifetime − Feb-2026 baseline 68,412,433, / 75M).

Files: repo scripts/hex-child-app-detail.sql (synced to live). Memory: hex-published-input-binding.md.

Not done / next: Adobe follow-up meeting on staging over-consumption still to be scheduled (email drafted, not sent). Git: repo has untracked new scripts (hex-child-app-detail.sql, draft-staging-note.js, hex-staging-apps.sql, update-adobe.sh) — not committed (awaiting Arijit's go).