Skip to content

DataWithBaraa/claude-code-data-engineering-skills / skills/data-product

data-product

Verified

Use when a table is served to consumers, released or changed, to build everything a consumer needs as a data product, the guide, the data model, the metrics, the starter queries, the quality, the releases and the data contract.

FileKindSize
SKILL.mdskill md1.8 KB
references/data-products.htmlother240.9 KB

references/data-products.html

View on GitHub
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Data Products · newvolt-data-platform</title>
<style>
  *{box-sizing:border-box;margin:0;padding:0}
  :root{
    --sans:-apple-system,BlinkMacSystemFont,"SF Pro Display","Segoe UI",Roboto,"Helvetica Neue",Arial,sans-serif;
    --mono:ui-monospace,"SF Mono",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono",monospace;
    --ink:#e9eefb; --sec:#a7b4d2; --mut:#7e8caf;
    --line:rgba(132,156,218,.17); --hair:rgba(132,156,218,.09);
    --indigo:#8f97ff;
    --winbg:#0c1120; --lpane:#0a0f1b; --rpane:#0e1524;
    --surf:#101728; --surf2:#131b2e; --inset:#0a101d;
    --green:#5fe0a8; --blue:#86b8ff; --amber:#ffca5f; --red:#ff8f8f; --violet:#c9a4f9; --cyan:#7fd8f0;
  }
  html,body{height:100%}
  body{margin:0;overflow:hidden;background:#04060e;font-family:var(--sans);color:var(--ink);-webkit-font-smoothing:antialiased;}
  #stage{
    position:fixed;left:50%;top:50%;width:1920px;height:1080px;
    background:
      radial-gradient(1200px 700px at 70% -10%, rgba(79,84,229,.16), rgba(79,84,229,0) 62%),
      radial-gradient(1000px 600px at 8% 110%, rgba(34,150,120,.07), rgba(34,150,120,0) 60%),
      radial-gradient(900px 560px at 96% 88%, rgba(95,50,170,.10), rgba(95,50,170,0) 65%),
      #04060e;
  }
  #stage::before{
    content:"";position:absolute;inset:0;
    background:
      repeating-linear-gradient(0deg,  rgba(120,150,220,.04) 0 1px, transparent 1px 120px),
      repeating-linear-gradient(90deg, rgba(120,150,220,.04) 0 1px, transparent 1px 120px);
    mask-image:radial-gradient(1250px 850px at 50% 50%, #000 25%, transparent 100%);
  }
  .window{
    position:absolute;left:36px;top:34px;width:1848px;height:1012px;
    background:var(--winbg);border:1px solid rgba(139,158,222,.24);border-radius:16px;overflow:hidden;
    box-shadow:0 32px 72px rgba(0,0,8,.62),0 0 44px rgba(70,90,180,.12),inset 0 1px 0 rgba(255,255,255,.05);
  }
  .bar{height:58px;display:flex;align-items:center;background:#0a0e19;border-bottom:1px solid var(--line);}
  .bar .side{width:230px;display:flex;align-items:center;gap:10px;padding-left:24px}
  .dot{width:12px;height:12px;border-radius:50%;box-shadow:inset 0 0 0 1px rgba(0,0,0,.25)}
  .dot.r{background:#ef6b60}.dot.y{background:#f3bd4a}.dot.g{background:#4fc266}
  .bar .mid{flex:1;display:flex;justify-content:center}
  .addr{
    width:620px;height:34px;border-radius:10px;background:#070b14;border:1px solid var(--line);
    display:flex;align-items:center;justify-content:center;gap:9px;color:#8fa0c4;
  }
  .addr span{font-family:var(--mono);font-size:15.5px;letter-spacing:.005em}
  .bar .side.end{width:230px}
  .body{height:952px;position:relative;}
  .view{position:absolute;inset:0;display:none;overflow:hidden;}
  .view.on{display:block;}

  /* ============ shared bits ============ */
  .crumbs{display:flex;align-items:center;gap:10px;font-size:17.5px;color:var(--mut);}
  .crumbs a{color:var(--indigo);cursor:pointer;}
  .crumbs .sep{color:#4d5b7f}
  .crumbs b{color:var(--sec);font-weight:600}
  .chip{height:32px;padding:0 15px;border-radius:99px;display:inline-flex;align-items:center;
    font-size:15.5px;font-weight:650;letter-spacing:.02em;}
  .chip.sales{color:var(--green);background:rgba(52,211,153,.10);border:1px solid rgba(52,211,153,.3)}
  .chip.fin{color:var(--amber);background:rgba(255,202,95,.10);border:1px solid rgba(255,202,95,.3)}
  .chip.mkt{color:var(--violet);background:rgba(201,164,249,.10);border:1px solid rgba(201,164,249,.3)}
  .chip.mfg{color:var(--blue);background:rgba(134,184,255,.10);border:1px solid rgba(134,184,255,.3)}
  .chip.log{color:var(--cyan);background:rgba(127,216,240,.10);border:1px solid rgba(127,216,240,.3)}
  .chip.ppl{color:var(--red);background:rgba(248,113,113,.10);border:1px solid rgba(248,113,113,.3)}
  .cert{height:30px;padding:0 13px;border-radius:8px;display:inline-flex;align-items:center;gap:6px;
    font-size:15px;font-weight:650;color:var(--green);
    background:rgba(52,211,153,.10);border:1px solid rgba(52,211,153,.30);}
  .exp{height:30px;padding:0 13px;border-radius:8px;display:inline-flex;align-items:center;
    font-size:15px;font-weight:650;color:var(--mut);
    background:rgba(148,163,190,.08);border:1px solid rgba(148,163,190,.22);}
  .av{width:52px;height:52px;border-radius:50%;background:rgba(148,163,190,.10);
    border:1px solid rgba(190,205,235,.32);display:flex;align-items:center;justify-content:center;
    font-size:17px;font-weight:700;color:#dbe4f6;letter-spacing:.02em;flex:none;}
  .lbl{font-size:14.5px;font-weight:600;letter-spacing:.08em;text-transform:uppercase;color:var(--mut)}

  /* ============ VIEW 1 · MARKETPLACE ============ */
  #vMarket{padding:44px 56px 0;}
  .mhead{display:flex;align-items:flex-end;justify-content:space-between;}
  .mhead h1{font-size:42px;font-weight:750;letter-spacing:-.012em;}
  .mhead .sub{margin-top:6px;font-size:19px;color:var(--mut);}
  .search{width:440px;height:50px;border:1px solid var(--line);border-radius:11px;background:#0c1322;
    display:flex;align-items:center;gap:10px;padding:0 18px;color:#7787ab;font-size:17.5px;}
  .filters{margin-top:18px;display:flex;gap:10px;}
  .fchip{height:40px;padding:0 19px;border-radius:99px;border:1px solid var(--line);
    display:flex;align-items:center;font-size:17px;color:var(--sec);background:transparent;}
  .fchip.on{background:linear-gradient(90deg,rgba(99,102,241,.55),rgba(139,147,255,.45));
    color:#fff;border-color:transparent;}
  .cards{margin-top:20px;display:grid;grid-template-columns:repeat(4,1fr);gap:18px;}
  .pcard{height:208px;border-radius:14px;background:var(--surf);border:1px solid var(--line);
    padding:22px 24px;display:flex;flex-direction:column;box-shadow:0 4px 14px rgba(0,0,6,.32);}
  .pcard .top{display:flex;align-items:center;gap:11px;}
  .pcard .glyph{width:44px;height:44px;border-radius:10px;background:rgba(99,102,241,.13);
    border:1px solid rgba(143,151,255,.32);display:flex;align-items:center;justify-content:center;color:#a9b0ff;flex:none;}
  .pcard .nm{font-size:23px;font-weight:700;letter-spacing:-.005em;white-space:nowrap;overflow:hidden;}
  .pcard .desc{margin-top:12px;font-size:17px;line-height:23px;color:var(--mut);
    display:-webkit-box;-webkit-line-clamp:2;-webkit-box-orient:vertical;overflow:hidden;}
  .pcard .own{font-size:16px;color:var(--mut);white-space:nowrap;overflow:hidden;}
  .pcard .foot{margin-top:auto;padding-top:14px;border-top:1px solid var(--hair);
    display:flex;align-items:center;justify-content:space-between;font-variant-numeric:tabular-nums;}
  .pcard .dg{display:flex;align-items:center;gap:12px;min-width:0;}
  .pcard .cons{font-size:15.5px;color:var(--mut);white-space:nowrap;}
  .pcard .cons b{font-size:17.5px;font-weight:650;color:var(--sec);}
  .pcard.live{cursor:pointer;border-color:rgba(143,151,255,.45);
    box-shadow:0 4px 14px rgba(0,0,6,.32),0 0 26px rgba(99,102,241,.14);}
  .pcard.live:hover{border-color:rgba(143,151,255,.7);transform:translateY(-2px);}
  .pcard{transition:transform .15s ease,border-color .15s ease;}
  .pcard:hover{transform:translateY(-2px);}

  /* ============ VIEW 2 · PRODUCT ============ */
  #vProduct{padding:36px 56px 0;}
  .phead{margin-top:26px;display:flex;align-items:center;gap:16px;}
  .phead .glyph{width:52px;height:52px;border-radius:13px;background:rgba(99,102,241,.13);
    border:1px solid rgba(143,151,255,.32);display:flex;align-items:center;justify-content:center;color:#a9b0ff;}
  .phead h1{font-size:40px;font-weight:750;letter-spacing:-.012em;}
  .pdesc{margin-top:14px;font-size:21px;color:var(--sec);max-width:1100px;}
  .psplit{display:flex;height:100%;}
  .pleft{flex:1;padding:36px 48px 0 56px;min-width:0;}
  .pside{width:560px;height:100%;background:var(--rpane);border-left:1px solid var(--line);
    padding:40px 44px 0;}
  .kv{height:64px;display:flex;align-items:center;justify-content:space-between;
    border-bottom:1px solid var(--hair);}
  .kv:last-of-type{border-bottom:none}
  .kv .v{font-size:21px;font-weight:600;font-variant-numeric:tabular-nums;}
  .kv .v.mono{font-family:var(--mono);font-size:18px;}
  .sidesep{margin:22px 0;height:1px;background:var(--line);}
  .oitem{display:flex;align-items:center;gap:14px;}
  .oitem + .oitem{margin-top:20px;}
  .oitem .v{font-size:21px;font-weight:600;line-height:21px;}
  .oitem .k{margin-top:2px;font-size:15.5px;color:var(--mut);}
  .sep2{margin:26px 0 0;height:1px;background:var(--line);}
  .tsec{margin-top:20px;display:flex;align-items:center;justify-content:space-between;}
  .tsec .t{display:flex;align-items:center;gap:11px;}
  .accent{width:4px;height:20px;border-radius:3px;background:var(--indigo);}
  .tsec h3{font-size:22px;font-weight:700;}
  .tsec .c{font-size:16.5px;color:var(--mut);}
  .trow{display:grid;grid-template-columns:370px 165px 145px 215px 145px 1fr;align-items:center;height:64px;
    padding:0 18px;border-bottom:1px solid var(--hair);font-size:18px;}
  .trow.h{height:40px;margin-top:10px;border-bottom:1px solid var(--line);}
  .trow.h>*{font-size:14px;font-weight:600;letter-spacing:.07em;text-transform:uppercase;color:var(--mut);}
  .trow .tn{font-family:var(--mono);font-size:19px;color:#d6e0f5;display:flex;align-items:center;gap:10px;}
  .trow .num{font-family:var(--mono);color:var(--sec);font-variant-numeric:tabular-nums;}
  .trow .zone{font-size:14px;color:var(--mut);}
  .trow.live{cursor:pointer;background:rgba(99,102,241,.05);}
  .trow.live:hover{background:rgba(99,102,241,.10);}
  .trow.live .tn{color:#fff;font-weight:600;}
  .trow .go{justify-self:end;color:var(--indigo);font-size:17px;opacity:0;white-space:nowrap;}
  .trow.live .go{opacity:1;}

  /* ============ VIEW 3 · TABLE ============ */
  .tbody{display:flex;height:952px;}
  .left{width:860px;height:100%;background:var(--lpane);border-right:1px solid var(--line);padding:32px 40px 0 44px;}
  .paneTitle{font-size:32px;font-weight:700;letter-spacing:-.012em;}
  .paneSub{margin-top:4px;font-size:17px;color:var(--mut);}
  .gcard{margin-top:18px;width:776px;background:var(--surf);border:1px solid var(--line);
    border-radius:12px;box-shadow:0 4px 14px rgba(0,0,6,.32);overflow:hidden;}
  .gbar{height:60px;display:flex;align-items:center;justify-content:space-between;
    padding:0 16px 0 22px;border-bottom:1px solid var(--line);background:var(--surf2);}
  .gname{display:flex;align-items:center;gap:11px;font-family:var(--mono);font-size:20px;font-weight:600;}
  .gname svg{color:var(--indigo);}
  .filter{width:200px;height:38px;border:1px solid var(--line);border-radius:8px;background:#0c1322;
    display:flex;align-items:center;gap:8px;padding:0 12px;color:#7787ab;font-size:15.5px;}
  .row{display:grid;grid-template-columns:46px 120px 148px 218px 118px 126px;align-items:center;border-bottom:1px solid var(--hair);}
  .row>*{padding:0 12px;overflow:hidden;white-space:nowrap;}
  .row>*:first-child{padding-left:20px}
  .row.head{height:52px;background:#121a2c;}
  .row.head>*{font-family:var(--mono);font-size:14.5px;font-weight:600;color:#8b9ac1;}
  .row.head>*:first-child{font-family:var(--sans)}
  .row.rec{height:62px;}
  .row.rec:last-of-type{border-bottom:none}
  .num2{font-size:15px;color:#5f6d92;font-variant-numeric:tabular-nums}
  .m{font-family:var(--mono);font-size:17px;color:#d6e0f5;}
  .gfoot{height:54px;display:flex;align-items:center;padding:0 22px;border-top:1px solid var(--line);
    background:#0f1626;font-size:16.5px;color:var(--sec);font-variant-numeric:tabular-nums;}
  .right{flex:1;height:100%;background:var(--rpane);padding:32px 48px 0;overflow:hidden;}
  .rhead{display:flex;align-items:center;justify-content:space-between;}
  .tabs{height:48px;margin-top:14px;display:flex;align-items:flex-end;gap:30px;border-bottom:1px solid var(--line);}
  .tab{font-size:18px;font-weight:600;color:var(--mut);padding-bottom:12px;cursor:pointer;}
  .tab.on{color:var(--indigo);box-shadow:inset 0 -3px 0 0 var(--indigo);}
  .tv{display:none;padding-top:20px;}
  .tv.on{display:block;}

  /* metadata tab (from the catalog page) */
  .nameRow{height:40px;display:flex;align-items:center;gap:13px;}
  .nameRow h2{font-family:var(--mono);font-size:29px;font-weight:600;}
  .mdesc{margin-top:10px;font-size:19.5px;color:var(--sec);}
  .mstats{margin-top:18px;height:96px;border:1px solid var(--line);border-radius:12px;background:var(--surf);
    display:grid;grid-template-columns:130px 130px 150px 300px 1fr;}
  .mstats .st{padding:0 20px;display:flex;flex-direction:column;justify-content:center;border-left:1px solid var(--line);}
  .mstats .st:first-child{border-left:none}
  .mstats .v{margin-top:4px;font-size:22px;font-weight:600;font-variant-numeric:tabular-nums;}
  .mstats .v.mono{font-family:var(--mono);font-size:18px;}
  .mstats .v.path{font-family:var(--mono);font-size:16.5px;color:#cfdaf2;}
  .srow{display:grid;grid-template-columns:200px 185px 135px 1fr;align-items:center;}
  .srow.h{height:38px;margin-top:12px;border-bottom:1px solid var(--line);}
  .srow.h>*{font-size:14px;font-weight:600;letter-spacing:.07em;text-transform:uppercase;color:var(--mut);}
  .srow.d{height:62px;border-bottom:1px solid var(--hair);}
  .srow.d:last-child{border-bottom:none}
  .cname{font-family:var(--mono);font-size:19px;font-weight:600;}
  .pill{height:32px;padding:0 12px;border-radius:8px;display:inline-flex;align-items:center;
    font-family:var(--mono);font-size:16px;font-weight:600;}
  .pill.int{background:rgba(255,202,95,.11);color:#ffca5f;border:1px solid rgba(255,202,95,.28)}
  .pill.var{background:rgba(96,165,250,.11);color:#86b8ff;border:1px solid rgba(134,184,255,.28)}
  .pill.date{background:rgba(52,211,153,.11);color:#5fe0a8;border:1px solid rgba(95,224,168,.28)}
  .nn{font-size:17px;color:#c3cfe8;}
  .cn2{font-size:17px;color:var(--mut);}
  .mean{display:flex;align-items:center;gap:10px;font-size:17.5px;color:var(--sec);}
  .pii{height:28px;padding:0 10px;border-radius:7px;background:rgba(248,113,113,.10);color:#ff8f8f;
    border:1px solid rgba(248,113,113,.32);display:inline-flex;align-items:center;font-size:14.5px;font-weight:700;}

  /* semantic tab */
  .smrow{display:grid;grid-template-columns:215px 400px 1fr;align-items:center;}
  .smrow.h{height:38px;margin-top:6px;border-bottom:1px solid var(--line);}
  .smrow.h>*{font-size:14px;font-weight:600;letter-spacing:.07em;text-transform:uppercase;color:var(--mut);}
  .smrow.d{height:66px;border-bottom:1px solid var(--hair);}
  .smrow.d:last-child{border-bottom:none}
  .mname{font-family:var(--mono);font-size:19.5px;font-weight:650;color:var(--green);}
  .mname.dim{color:var(--blue);}
  .formula{font-family:var(--mono);font-size:16px;color:#a9bce0;padding-right:14px;}
  .smmean{font-size:17.5px;color:var(--sec);}
  .shead2{display:flex;align-items:center;gap:11px;margin-top:20px;}
  .shead2 h3{font-size:21px;font-weight:700;}
  .accent.g{background:var(--green)}
  .accent.b{background:var(--blue)}

  /* lineage tab */
  .lin{position:relative;margin-top:6px;height:660px;}
  .lnode{position:absolute;width:360px;border-radius:12px;background:var(--surf);
    border:1px solid var(--line);padding:14px 18px;}
  .lnode .zone{font-size:14px;font-weight:650;letter-spacing:.1em;text-transform:uppercase;color:var(--mut);}
  .lnode .nm{margin-top:5px;font-family:var(--mono);font-size:19px;color:#d6e0f5;}
  .lnode.src{border-left:3px solid #8b9ac1;}
  .lnode.bronze{border-left:3px solid #cd8f52;}
  .lnode.bronze .zone{color:#cd8f52}
  .lnode.silver{border-left:3px solid #b9c5da;}
  .lnode.silver .zone{color:#b9c5da}
  .lnode.gold{border-left:3px solid #ffd76a;}
  .lnode.gold .zone{color:#ffd76a}
  .lnode.usef{border-left:3px solid var(--indigo);}
  .lnode.usef .zone{color:var(--indigo)}
  .lnode.cur{border-color:rgba(143,151,255,.55);box-shadow:0 0 24px rgba(99,102,241,.16);}
  .lnode.cur .nm{color:#fff;font-weight:600;}
  .lin svg{position:absolute;inset:0;pointer-events:none;}
  .lin svg path{fill:none;stroke:rgba(160,175,255,.4);stroke-width:2;}
  .lin svg circle{fill:#0b1020;stroke:rgba(170,185,255,.75);stroke-width:1.6;}

  /* contact tab */
  .ccard{margin-top:14px;border:1px solid var(--line);border-radius:12px;background:var(--surf);
    padding:22px 24px;display:flex;align-items:center;gap:16px;}
  .ccard .who .v{font-size:21px;font-weight:650;}
  .ccard .who .k{margin-top:3px;font-size:16px;color:var(--mut);}
  .ccard .meta{margin-left:auto;text-align:right;}
  .ccard .meta .em{font-family:var(--mono);font-size:16.5px;color:var(--sec);}
  .ccard .meta .sl{margin-top:5px;font-family:var(--mono);font-size:16px;color:var(--cyan);}
  .btn{margin-top:22px;height:52px;padding:0 30px;border-radius:11px;border:none;cursor:pointer;
    background:linear-gradient(90deg,#5b5fd6,#7a7ff2);color:#fff;font-size:18px;font-weight:650;
    box-shadow:0 6px 20px rgba(99,102,241,.3);}
  .sla{margin-top:16px;font-size:16.5px;color:var(--mut);}

  /* the market */
  .search input{flex:1;border:none;background:transparent;color:var(--ink);font:inherit;font-size:17.5px;outline:none;} .search input::placeholder{color:#7787ab;}
  .fchip{cursor:pointer;}
  .cards{grid-template-columns:repeat(4,minmax(0,1fr));margin-top:24px;gap:20px;}
  .pcard{cursor:pointer;height:300px;} .pcard.hidden{display:none;}
  .pcard .top .cert,.pcard .top .exp{margin-left:auto;height:26px;padding:0 10px;font-size:13.5px;}
  .pcard .desc{-webkit-line-clamp:3;text-wrap:balance;}
  .pcard .tl{margin-top:12px;font-family:var(--mono);font-size:14px;line-height:21px;color:#7e8caf;display:-webkit-box;-webkit-line-clamp:2;-webkit-box-orient:vertical;overflow:hidden;}
  .pcard .foot{gap:12px;} .pcard .dg{gap:10px;} .pcard .chip{height:30px;padding:0 12px;font-size:14.5px;flex:none;}
  .pcard .own{min-width:0;text-overflow:ellipsis;font-size:15px;} .pcard .cons{flex:none;font-size:14.5px;} .pcard .cons b{font-size:17px;}
  .exp.bad{color:#ff8f8f;background:rgba(248,113,113,.10);border-color:rgba(248,113,113,.32);}
  /* the window bar */
  .navb{margin-left:14px;width:30px;height:30px;border-radius:8px;display:flex;align-items:center;justify-content:center;font-size:26px;line-height:1;color:var(--sec);cursor:pointer;user-select:none;padding-bottom:3px;}
  .navb + .navb{margin-left:2px;} .navb:hover{background:rgba(143,151,255,.12);color:var(--ink);} .navb.off{opacity:.35;pointer-events:none;}
  .crumbs a{cursor:pointer;} .crumbs a:hover{text-decoration:underline;}
  .mono{font-family:var(--mono);}
  .dim{color:var(--sec);}
  /* a product */
  .pview .psplit{height:100%;}
  .pleft{display:flex;flex-direction:column;height:100%;padding:30px 48px 0 56px;}
  .phead{margin-top:18px;} .pdesc{margin-top:10px;font-size:19px;}
  .ptabs{margin-top:18px;flex:none;}
  .ptab{cursor:pointer;} .ptab.off{opacity:.32;cursor:default;}
  .pscroll{flex:1;overflow-y:auto;padding:22px 2px 56px 0;} .pscroll::-webkit-scrollbar{width:0;}
  .pp{display:none;} .pp.on{display:block;}
  .pside{padding-top:30px;}
  .kv.chipsrow{height:auto;min-height:64px;padding:12px 0;align-items:flex-start;} .kv .chips{display:flex;flex-wrap:wrap;gap:8px;justify-content:flex-end;max-width:300px;}
  .kv .chips .chip{height:28px;padding:0 11px;font-size:14px;}
  .ov{font-size:20px;font-weight:600;} .ok{margin-top:3px;font-size:15px;color:var(--mut);}
  .btn.sent{background:rgba(52,211,153,.12);color:var(--green);box-shadow:none;border:1px solid rgba(52,211,153,.3);cursor:default;}
  .docline{display:flex;align-items:center;gap:9px;font-family:var(--mono);font-size:14px;color:var(--mut);margin-bottom:18px;}
  .docline .by{margin-left:auto;font-family:var(--sans);font-size:14.5px;color:#8f97ff;}
  .pstats{display:grid;grid-template-columns:repeat(5,minmax(0,1fr));border:1px solid var(--line);border-radius:12px;background:var(--surf);}
  .pstats .st{padding:16px 20px;border-left:1px solid var(--line);} .pstats .st:first-child{border-left:none;}
  .pstats .v{margin-top:6px;font-size:23px;font-weight:650;font-variant-numeric:tabular-nums;white-space:nowrap;} .pstats .v.sm{font-size:19px;margin-top:9px;}
  .pstats .v.orange{color:var(--amber);} .pstats .s2{margin-top:4px;font-size:14px;color:var(--mut);white-space:nowrap;overflow:hidden;text-overflow:ellipsis;}
  .pp>.sech:first-child{margin-top:4px;}
  .sech{margin-top:30px;display:flex;align-items:center;justify-content:space-between;}
  .sech .t{display:flex;align-items:center;gap:11px;} .sech h3{font-size:20px;font-weight:700;} .sech .c{font-size:15.5px;color:var(--mut);}
  .pleft .trow{grid-template-columns:370px 150px 150px 100px 200px 1fr;height:56px;padding:0 16px;font-size:17px;}
  .pleft .trow.h{height:38px;margin-top:8px;}
  .pleft .trow .tn{font-size:17.5px;min-width:0;} .pleft .trow .zone{font-size:15px;} .pleft .trow .num.late{color:var(--amber);}
  .pleft .trow .go{padding-right:4px;}
  .rrow{display:grid;grid-template-columns:260px 160px 1fr;align-items:center;height:48px;border-bottom:1px solid var(--hair);padding:0 16px;font-size:17px;}
  .rrow .rr{color:#d6e0f5;font-size:16.5px;} .rrow .rp{color:var(--ink);font-weight:600;} .rrow .rw{color:var(--sec);}
  /* grid tables */
  .gt{margin-top:10px;} .gt .gh,.gt .gr{display:grid;grid-template-columns:var(--cols);column-gap:22px;}
  .gt .gh{padding:0 16px 10px;border-bottom:1px solid var(--line);} .gt .gh>*{font-size:14px;font-weight:600;letter-spacing:.07em;text-transform:uppercase;color:var(--mut);}
  .gt .gr{padding:13px 16px;border-bottom:1px solid var(--hair);font-size:16.5px;line-height:1.45;align-items:baseline;}
  .gt .gr>*{min-width:0;overflow-wrap:break-word;} .gt .gh>.r,.gt .r{text-align:right;}
  .gt .col{color:var(--ink);font-weight:600;} .gt .num{text-align:right;font-family:var(--mono);font-variant-numeric:tabular-nums;} .gt .gh>*:nth-child(n+2){}
  .gt .code{font-family:var(--mono);font-size:15px;color:#a9bce0;white-space:pre-wrap;} .gt .orange{color:var(--amber);} .gt .mono{font-family:var(--mono);font-size:15.5px;}
  .gt .kid{color:#a9b0ff;margin-right:6px;} .nw{white-space:nowrap;}
  .tr{margin-top:12px;font-size:17px;line-height:1.5;color:var(--sec);} .tr b{color:var(--ink);font-weight:650;}
  .status{display:flex;align-items:center;gap:14px;font-size:16.5px;color:var(--sec);margin-bottom:6px;}
  .status .draft{margin-left:0;flex:none;} .status .note{flex:none;height:28px;padding:0 12px;border-radius:7px;display:flex;align-items:center;font-size:14px;font-weight:650;color:#a9b0ff;background:rgba(99,102,241,.12);border:1px solid rgba(143,151,255,.32);}
  /* the drawing */
  .star{position:relative;width:1184px;margin-top:4px;}
  .star svg{position:absolute;inset:0;}
  .star .sl{fill:none;stroke:rgba(160,175,255,.5);stroke-width:1.8;} .star .sl.built{stroke-dasharray:6 6;stroke:rgba(160,175,255,.42);}
  .star circle{fill:#0e1524;stroke:rgba(170,185,255,.8);stroke-width:1.6;}
  .sbox{position:absolute;box-sizing:border-box;border-radius:12px;background:var(--surf);border:1px solid var(--line);border-left:3px solid #8b9ac1;padding:14px 18px;box-shadow:0 4px 14px rgba(0,0,6,.32);}
  .sbox .sk{font-size:13.5px;font-weight:650;letter-spacing:.07em;color:var(--mut);height:18px;white-space:nowrap;overflow:hidden;}
  .sbox .sn{margin-top:4px;font-family:var(--mono);font-size:18px;font-weight:600;color:#e9eefb;height:30px;white-space:nowrap;}
  .sbox .sc{display:flex;align-items:center;justify-content:space-between;height:23px;font-family:var(--mono);font-size:15px;color:#d6e0f5;}
  .sbox .sc .cn.key{color:#ffca5f;} .sbox .sc .cn.dim{color:var(--sec);}
  .sbox .tg{font-size:13px;font-weight:700;letter-spacing:.05em;color:#ffca5f;border:1px solid rgba(255,202,95,.35);border-radius:5px;padding:2px 7px;} .sbox .tg.fk{color:#86b8ff;border-color:rgba(134,184,255,.35);}
  .sbox .more{margin-top:2px;font-size:14px;color:var(--mut);}
  .sbox.k-fact{border-left-color:#8f97ff;} .sbox.k-fact .sk{color:#a9b0ff;}
  .sbox.k-dimension{border-left-color:#86b8ff;} .sbox.k-dimension .sk{color:#86b8ff;}
  .sbox.k-one{border-left-color:#ffca5f;} .sbox.k-one .sk{color:#ffca5f;}
  .sbox.k-metric{border-left-color:#5fe0a8;} .sbox.k-metric .sk{color:#5fe0a8;}
  .sbox.k-report{border-left-color:#c9a4f9;} .sbox.k-report .sk{color:#c9a4f9;}
  .sbox.k-bronze{border-left-color:#cd8f52;} .sbox.k-bronze .sk{color:#cd8f52;}
  .sbox.other{opacity:.5;}
  .sbox.stale{border:1.5px dashed rgba(255,202,95,.55);border-left:3px solid rgba(255,202,95,.85);} .sbox.stale .sk{color:#ffca5f;}
  .sbox.deprecated{border:1.5px dashed rgba(167,180,210,.42);border-left:3px solid rgba(167,180,210,.62);} .sbox.deprecated .sk{color:#a7b4d2;}
  .slab{position:absolute;white-space:nowrap;font-family:var(--mono);font-size:14px;color:#c3cfe8;background:#0e1524;border:1px solid var(--line);border-radius:6px;padding:2px 8px;}
  .slab{transform:translate(-50%,-50%);}
  /* the guide */
  .guide{display:grid;grid-template-columns:260px minmax(0,1fr);column-gap:44px;}
  .toc{position:sticky;top:0;align-self:start;border:1px solid var(--line);border-radius:12px;background:var(--surf);padding:14px 10px 10px;}
  .toc .th{padding:0 10px 10px;font-size:15px;font-weight:700;color:var(--ink);border-bottom:1px solid var(--hair);margin-bottom:6px;}
  .step{display:flex;align-items:center;gap:10px;padding:9px 10px;border-radius:8px;cursor:pointer;font-size:15.5px;color:var(--sec);}
  .step:hover{background:rgba(143,151,255,.08);color:var(--ink);} .step .st{flex:1;} .step .mn{font-size:13.5px;color:var(--mut);white-space:nowrap;}
  .gnum{width:24px;height:24px;flex:none;border-radius:50%;display:inline-flex;align-items:center;justify-content:center;font-size:14px;font-weight:700;color:#a9b0ff;border:1px solid rgba(143,151,255,.45);background:rgba(99,102,241,.1);}
  .lead2{font-size:18px;line-height:1.55;color:var(--sec);}
  .gsec{margin-top:26px;} .gsec h4{display:flex;align-items:center;gap:12px;font-size:21px;font-weight:700;} .gsec h4 .mn{margin-left:auto;font-size:14px;font-weight:600;color:var(--mut);}
  .gsec p{margin-top:10px;font-size:17px;line-height:1.55;color:var(--sec);} .gsec p .mono{color:#d6e0f5;}
  pre{margin-top:12px;font-family:var(--mono);font-size:15.5px;line-height:1.55;color:#d6e0f5;background:var(--inset);border:1px solid var(--line);border-radius:10px;padding:14px 18px;white-space:pre-wrap;}
  .ans{margin-top:10px;display:grid;grid-template-columns:270px 190px 1fr;column-gap:20px;align-items:baseline;padding:12px 16px;border:1px solid var(--line);border-radius:10px;background:var(--surf);font-size:16px;color:var(--sec);}
  .ans[data-q]{cursor:pointer;} .ans[data-q]:hover{border-color:rgba(143,151,255,.45);background:#131c31;}
  .ans .q{color:var(--ink);font-weight:600;} .ans b{font-family:var(--mono);font-size:17px;color:#e9eefb;white-space:nowrap;}
  /* metrics */
  .inout{margin-top:10px;display:grid;grid-template-columns:1fr 1fr;gap:20px;align-items:stretch;}
  .card{border:1px solid var(--line);border-radius:12px;background:var(--surf);}
  .card.half{padding:18px 22px 6px;} .card .hd{font-size:18px;font-weight:700;margin-bottom:8px;} .card .hd.out{color:var(--amber);}
  .card .li{display:grid;grid-template-columns:280px minmax(0,1fr);column-gap:16px;padding:10px 0;border-top:1px solid var(--hair);font-size:16px;line-height:1.4;} .card .li b{font-weight:600;} .card .li span{color:var(--sec);}
  /* queries: the number badge, the title, copy */
  .qh{display:flex;align-items:flex-start;gap:12px;} .qh>div{flex:1;min-width:0;}
  .qn{width:30px;height:30px;flex:none;border-radius:8px;display:flex;align-items:center;justify-content:center;font-size:15px;font-weight:700;color:#a9b0ff;background:rgba(99,102,241,.13);border:1px solid rgba(143,151,255,.32);}
  .qt{font-size:17px;font-weight:650;line-height:1.3;} .qg{margin-top:3px;font-size:14.5px;color:var(--mut);}
  /* releases */
  .rcards{display:grid;grid-template-columns:1fr;gap:18px;align-items:start;}
  .rcard{border:1px solid var(--line);border-radius:12px;background:var(--surf);padding:18px 22px;}
  .rcard .rv{display:flex;align-items:baseline;gap:12px;font-size:21px;font-weight:700;} .rcard .rv .dim{font-size:15px;font-weight:500;}
  .rcard .rl{margin-top:6px;font-size:16.5px;color:var(--sec);}
  .ri{margin-top:10px;display:grid;grid-template-columns:190px minmax(0,1fr);column-gap:12px;font-size:16px;line-height:1.45;color:var(--sec);}
  .ri .rk2{font-size:14px;font-weight:650;letter-spacing:.06em;text-transform:uppercase;color:var(--mut);padding-top:3px;} .ri.must span:last-child{color:var(--ink);}
  .card.notice{margin-top:10px;padding:18px 22px;} .card.notice .k{font-family:var(--mono);font-size:14px;color:var(--mut);}
  .card.notice .subj{margin-top:8px;font-size:18px;font-weight:650;} .card.notice p{margin-top:8px;font-size:16.5px;line-height:1.55;color:var(--sec);} .card.notice p b{color:var(--ink);}
  /* the contract */
  .yaml{margin-top:12px;border:1px solid var(--line);border-radius:12px;background:var(--inset);padding:16px 0;font-family:var(--mono);font-size:14px;line-height:1.6;counter-reset:ln;}
  .yl{display:flex;} .yl .ln{width:52px;flex:none;text-align:right;padding-right:18px;color:#46557d;user-select:none;}
  .yl .ln::before{counter-increment:ln;content:counter(ln);} .yl .yc{flex:1;white-space:pre-wrap;word-break:break-word;padding-right:20px;color:#c8d3e8;}
  .ycm{color:#6f7f9f;} .yk{color:#82a7ff;} .yst{color:#8ed081;} .yn{color:#ffb86b;} .yb{color:#c9a4f9;}
  /* the table view, carried over */
  .trow.live .tn{color:#fff;font-weight:600;}
  .row{grid-template-columns:54px 120px 110px 184px 120px 84px 1fr;} .row>*{padding:0 10px;} .row>*:last-child{padding-right:16px;text-align:right;}
  .row .m{font-size:15px;} .row.head>*{font-size:13.5px;}
  .mstats{grid-template-columns:156px 122px 120px 1fr 215px;}
  .mstats .st{padding:0 18px;} .mstats .v{font-size:21px;white-space:nowrap;} .mstats .v.path{font-size:16px;} .mstats .st:last-child .v{font-size:19px;}
  .right{display:flex;flex-direction:column;} .scroll{flex:1;overflow-y:auto;padding-bottom:40px;} .scroll::-webkit-scrollbar{width:0;}
  .ownerRow{margin-top:18px;display:flex;gap:40px;align-items:center;}
  .ownerRow .oitem .v{font-size:18px;font-weight:600;line-height:21px;} .ownerRow .oitem .k{margin-top:2px;font-size:14.5px;color:var(--mut);} .ownerRow .av{width:44px;height:44px;font-size:15px;}
  .srow{grid-template-columns:225px 130px 110px 1fr 96px;} .srow.d{height:auto;min-height:62px;padding:9px 0;} .srow .mean{display:block;font-size:16.5px;line-height:1.35;padding-right:12px;} .tagc{justify-self:end;}
  .add{height:24px;padding:0 9px;border-radius:7px;background:rgba(52,211,153,.10);color:var(--green);border:1px solid rgba(52,211,153,.30);display:inline-flex;align-items:center;font-size:13.5px;font-weight:700;letter-spacing:.03em;white-space:nowrap;}
  .nameRow{height:40px;display:flex;align-items:center;gap:13px;margin-top:2px;} .nameRow .kind{font-size:15px;color:var(--mut);}
  .draft{margin-left:auto;height:28px;padding:0 12px;border-radius:7px;background:rgba(255,202,95,.10);border:1px solid rgba(255,202,95,.30);display:flex;align-items:center;font-size:14px;font-weight:650;color:var(--amber);}
  .shead2 .cnt{margin-left:auto;font-size:15px;color:var(--mut);}
  .smrow{grid-template-columns:265px 300px 1fr;} .smrow.d{height:auto;min-height:62px;padding:8px 0;}
  .formula{font-size:14.5px;white-space:pre-wrap;line-height:1.4;} .smmean{line-height:1.35;}
  .mname{white-space:nowrap;overflow:hidden;text-overflow:ellipsis;padding-right:12px;font-size:18px;}
  .lnode{width:380px;} .lnode .nm{white-space:nowrap;overflow:hidden;text-overflow:ellipsis;font-size:18px;} .lnode.usef{width:352px;}
  /* code colours, the editor's */
  .s-kw{color:#c792ea;} .s-fn{color:#7fd8f0;} .s-str{color:#a5d98f;} .s-num{color:#ffb86b;} .s-com{color:#6f7f9f;}
  .ybr{color:#5d6b8c;}
  /* the drawing's legend */
  /* the starter queries: the list, and one query beside it */
  .qlib{margin-top:16px;display:grid;grid-template-columns:280px minmax(0,1fr);column-gap:24px;align-items:start;}
  .qlist{position:sticky;top:0;border:1px solid var(--line);border-radius:12px;background:var(--surf);padding:6px;}
  .qitem{display:flex;align-items:center;gap:12px;height:46px;padding:0 10px;border-radius:9px;cursor:pointer;font-size:15.5px;color:var(--sec);}
  .qitem:hover{background:rgba(143,151,255,.07);color:var(--ink);}
  .qitem.on{background:rgba(99,102,241,.17);color:var(--ink);font-weight:600;}
  .qitem .qn{width:26px;height:26px;font-size:14px;border-radius:7px;}
  .qitem .qs{white-space:nowrap;}
  .qd{display:none;} .qd.on{display:block;}
  .qd .qh{align-items:center;} .qd .qt{font-size:21px;font-weight:700;line-height:1.3;} .qd .qg{margin-top:4px;font-size:15.5px;}
  .qn.big{width:34px;height:34px;font-size:16px;}
  .qd pre.sql{margin-top:14px;font-size:14.5px;line-height:1.62;padding:16px 18px;}
  .rhd{margin-top:18px;display:flex;align-items:baseline;justify-content:space-between;font-size:16px;font-weight:650;color:var(--ink);} .rhd .dim{font-size:14.5px;font-weight:500;color:var(--mut);}
  .gt.res{margin-top:12px;} .gt.res .gr{padding:8px 16px;font-size:15px;} .gt.res .gh>*{font-family:var(--mono);text-transform:none;letter-spacing:0;font-size:14px;color:#a9b0ff;}
  /* the release notes */
  .bl{margin-top:6px;} .bi{position:relative;padding-left:20px;margin-top:9px;font-size:16.5px;line-height:1.5;color:var(--sec);}
  .bi::before{content:"";position:absolute;left:5px;top:10px;width:6px;height:6px;border-radius:50%;background:var(--indigo);}
  /* the contract */
  .cbar{display:flex;align-items:center;gap:14px;margin-bottom:16px;font-size:15.5px;}
  .seg{display:flex;flex:none;border:1px solid var(--line);border-radius:9px;overflow:hidden;background:#0c1322;}
  .seg span{padding:7px 15px;font-size:15px;font-weight:600;color:var(--mut);cursor:pointer;} .seg span + span{border-left:1px solid var(--line);font-family:var(--mono);font-size:14.5px;}
  .seg span.on{background:rgba(99,102,241,.2);color:var(--ink);}
  .cbar .note{flex:none;height:28px;padding:0 12px;border-radius:7px;display:flex;align-items:center;font-size:14px;font-weight:650;color:#a9b0ff;background:rgba(99,102,241,.12);border:1px solid rgba(143,151,255,.32);}
  .cv{display:none;} .cv.on{display:block;}
  .cfund{display:grid;grid-template-columns:1fr 1fr;border:1px solid var(--line);border-radius:12px;background:var(--surf);}
  .cf{padding:14px 20px;border-top:1px solid var(--hair);min-width:0;} .cf:nth-child(-n+2){border-top:none;} .cf:nth-child(2n){border-left:1px solid var(--hair);}
  .cf .k{display:block;font-size:14px;font-weight:600;letter-spacing:.08em;text-transform:uppercase;color:var(--mut);}
  .cf .v{display:block;margin-top:5px;font-size:17.5px;color:var(--ink);} .cf .v .mono{font-size:16px;color:#d6e0f5;}
  .crow{display:grid;grid-template-columns:150px minmax(0,1fr);column-gap:20px;padding:12px 16px;border-bottom:1px solid var(--hair);font-size:16.5px;line-height:1.5;color:var(--sec);}
  .crow .k{font-family:var(--mono);font-size:15.5px;color:#82a7ff;}
  .tag{display:inline-flex;align-items:center;height:26px;padding:0 9px;margin:0 6px 4px 0;border-radius:7px;font-size:14px;font-weight:650;white-space:nowrap;}
  .tag.public{color:#b9c5da;background:rgba(185,197,218,.08);border:1px solid rgba(185,197,218,.25);}
  .tag.internal{color:#86b8ff;background:rgba(134,184,255,.10);border:1px solid rgba(134,184,255,.30);}
  .tag.additive{color:#5fe0a8;background:rgba(52,211,153,.10);border:1px solid rgba(52,211,153,.30);}
  .tag.non_additive{color:#ffca5f;background:rgba(255,202,95,.10);border:1px solid rgba(255,202,95,.30);}
  .gt.schema .tg{font-size:13px;font-weight:700;color:#ffca5f;border:1px solid rgba(255,202,95,.35);border-radius:5px;padding:2px 7px;margin-left:6px;}
  .ybar{margin-top:8px;padding:0 4px;font-family:var(--mono);font-size:14px;color:var(--mut);}
  /* inline code in prose, a little smaller than the text around it */
  .gsec p .mono,.tr .mono,.card.notice p .mono,.status .mono,.crow .mono,.li .mono,.gt .dim .mono,.gt .gr>div:not(.col):not(.mono):not(.code) .mono{font-size:.92em;}
  /* the quality rules' SQL, one clause per line */
  pre.qsql{margin:0;padding:0;background:none;border:none;white-space:pre;font-size:14.5px;line-height:1.55;color:#c8d3e8;}
  .gt.res .gh,.gt.res .gr{column-gap:16px;} .gt.rec .gr{padding:7px 16px;}
  .fnote{margin-top:14px;font-size:15px;color:var(--mut);}
  .ccard .meta .sl{font-family:var(--sans);font-size:15px;color:var(--mut);}
  /* the way in: the read-only connection line */
  .btn.conn{margin-top:0;width:100%;}
  .conncode{margin-top:12px;font-size:14.5px;line-height:1.55;padding:12px 14px;white-space:pre-wrap;}
  .cconn{margin-top:24px;width:440px;}
  .gt .gr>div,.ri span,.tr,.bi,.gsec p,.card.notice p,.crow span,.li span,.card .li b,.mean,.smmean{text-wrap:pretty;}
</style>
</head>
<body>
<div id="stage">
  <div class="window">
    <div class="bar">
      <div class="side"><div class="dot r"></div><div class="dot y"></div><div class="dot g"></div><div class="navb" id="navBack" title="back">&#8249;</div><div class="navb" id="navFwd" title="forward">&#8250;</div></div>
      <div class="mid"><div class="addr"><svg width="14" height="14" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.8" stroke-linecap="round" stroke-linejoin="round"><rect x="5" y="10.5" width="14" height="9.5" rx="2.4"/><path d="M8.3 10.5V8a3.7 3.7 0 0 1 7.4 0v2.5"/></svg><span id="addr">data-products.internal</span></div></div>
      <div class="side end"></div>
    </div>
    <div class="body">
      <section class="view on" id="vMarket">
        <div class="mhead">
          <div><h1>Data Products</h1><div class="sub">what newvolt-data-platform serves from its gold layer · queries in 2026-08</div></div>
          <div class="search"><svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.9" stroke-linecap="round"><circle cx="11" cy="11" r="6.4"/><path d="M15.9 15.9L20.5 20.5"/></svg><input id="q" type="search" placeholder="Search data products and tables" autocomplete="off"></div>
        </div>
        <div class="filters"><div class="fchip on" data-group="All">All</div><div class="fchip" data-group="Finance">Finance</div><div class="fchip" data-group="Commercial">Commercial</div><div class="fchip" data-group="Marketing">Marketing</div><div class="fchip" data-group="Operations">Operations</div><div class="fchip" data-group="Data science">Data science</div></div>
        <div class="cards"><div class="pcard live" data-go="product" data-key="trading" data-groups="Finance|Commercial|Marketing|Data science" data-s="trading order lines, orders and finance&#x27;s trading measures; the table the monday trading pack sums obt_order_lines fact_order_lines fact_orders metric_trading dim_date finance commercial marketing data science">
            <div class="top"><div class="glyph"><svg width="21" height="21" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg></div><div class="nm">Trading</div><span class="cert">release 1.1.0</span></div>
            <div class="desc">order lines, orders and Finance&#x27;s trading measures; the table the Monday trading pack sums</div>
            <div class="tl">obt_order_lines · fact_order_lines · fact_orders · metric_trading · dim_date</div>
            <div class="foot"><span class="dg"><span class="chip fin">Finance</span><span class="own">5 tables</span></span><span class="cons"><b>2,480</b> queries</span></div>
          </div><div class="pcard" data-go="product" data-key="customers" data-groups="Marketing|Data science" data-s="customers one row per shop account, the channel it signed up on and its country; guests as unknown dim_customers dim_countries dim_channels marketing data science">
            <div class="top"><div class="glyph"><svg width="21" height="21" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><circle cx="12" cy="8" r="4"/><path d="M4 20c1.8-3.4 4.6-5 8-5s6.2 1.6 8 5"/></svg></div><div class="nm">Customers</div></div>
            <div class="desc">one row per shop account, the channel it signed up on and its country; guests as unknown</div>
            <div class="tl">dim_customers · dim_countries · dim_channels</div>
            <div class="foot"><span class="dg"><span class="chip mkt">Marketing</span><span class="own">3 tables</span></span><span class="cons"><b>331</b> queries</span></div>
          </div><div class="pcard" data-go="product" data-key="products" data-groups="Commercial|Finance" data-s="products one row per sku with brand, category and family, and the margin by product family dim_products rpt_margin_by_family commercial finance">
            <div class="top"><div class="glyph"><svg width="21" height="21" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M3 7l9-4 9 4-9 4-9-4z"/><path d="M3 7v10l9 4 9-4V7"/><path d="M12 11v10"/></svg></div><div class="nm">Products</div></div>
            <div class="desc">one row per SKU with brand, category and family, and the margin by product family</div>
            <div class="tl">dim_products · rpt_margin_by_family</div>
            <div class="foot"><span class="dg"><span class="chip sales">Commercial</span><span class="own">2 tables</span></span><span class="cons"><b>381</b> queries</span></div>
          </div><div class="pcard" data-go="product" data-key="delivery" data-groups="Operations" data-s="delivery one row per shipment with the carrier, the promise and the delivery day, and the daily sla fact_shipments dim_carriers rpt_delivery_sla metric_service operations">
            <div class="top"><div class="glyph"><svg width="21" height="21" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="7" width="13" height="9" rx="2"/><path d="M16 10h3l2 3v3h-5M7 19a2 2 0 1 0 0-4 2 2 0 0 0 0 4zM17 19a2 2 0 1 0 0-4 2 2 0 0 0 0 4z"/></svg></div><div class="nm">Delivery</div></div>
            <div class="desc">one row per shipment with the carrier, the promise and the delivery day, and the daily SLA</div>
            <div class="tl">fact_shipments · dim_carriers · rpt_delivery_sla · metric_service</div>
            <div class="foot"><span class="dg"><span class="chip log">Operations</span><span class="own">4 tables</span></span><span class="cons"><b>338</b> queries</span></div>
          </div><div class="pcard" data-go="product" data-key="returns" data-groups="Operations|Finance" data-s="returns one row per returned line with the reason and the refund, and the returns by month and reason fact_returns dim_return_reasons rpt_returns_by_reason operations finance">
            <div class="top"><div class="glyph"><svg width="21" height="21" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M4 15l4-8 4 6 3-4 5 8"/><path d="M3 20h18"/></svg></div><div class="nm">Returns</div></div>
            <div class="desc">one row per returned line with the reason and the refund, and the returns by month and reason</div>
            <div class="tl">fact_returns · dim_return_reasons · rpt_returns_by_reason</div>
            <div class="foot"><span class="dg"><span class="chip log">Operations</span><span class="own">3 tables</span></span><span class="cons"><b>104</b> queries</span></div>
          </div><div class="pcard" data-go="product" data-key="stock-and-purchasing" data-groups="Operations" data-s="stock and purchasing stock per sku and day, purchase orders, the suppliers and their fill rate by month fact_stock_daily fact_purchases dim_suppliers rpt_supplier_fill_rate operations">
            <div class="top"><div class="glyph"><svg width="21" height="21" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="7" rx="1.8"/><rect x="3" y="13" width="18" height="7" rx="1.8"/><path d="M7 7.5h3M7 16.5h3"/></svg></div><div class="nm">Stock and purchasing</div></div>
            <div class="desc">stock per SKU and day, purchase orders, the suppliers and their fill rate by month</div>
            <div class="tl">fact_stock_daily · fact_purchases · dim_suppliers · rpt_supplier_fill_rate</div>
            <div class="foot"><span class="dg"><span class="chip log">Operations</span><span class="own">4 tables</span></span><span class="cons"><b>70</b> queries</span></div>
          </div><div class="pcard" data-go="product" data-key="campaigns" data-groups="Marketing" data-s="campaigns one row per approved campaign window, and the discount offers of the old promotions table dim_campaigns dim_promotions_old marketing">
            <div class="top"><div class="glyph"><svg width="21" height="21" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="5" width="18" height="15" rx="2.5"/><path d="M3 10h18M8 3v4M16 3v4"/></svg></div><div class="nm">Campaigns</div></div>
            <div class="desc">one row per approved campaign window, and the discount offers of the old promotions table</div>
            <div class="tl">dim_campaigns · dim_promotions_old</div>
            <div class="foot"><span class="dg"><span class="chip mkt">Marketing</span><span class="own">2 tables</span></span><span class="cons"><b>34</b> queries</span></div>
          </div><div class="pcard" data-go="product" data-key="daily-sales" data-groups="Finance" data-s="daily sales order lines read straight from bronze; replaced by the one big table on 2026-07-31 rpt_daily_sales_wide finance">
            <div class="top"><div class="glyph"><svg width="21" height="21" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M4 20V10M10 20V4M16 20v-8M21 20H3"/></svg></div><div class="nm">Daily sales</div><span class="exp">deprecated</span></div>
            <div class="desc">order lines read straight from bronze; replaced by the one big table on 2026-07-31</div>
            <div class="tl">rpt_daily_sales_wide</div>
            <div class="foot"><span class="dg"><span class="chip fin">Finance</span><span class="own">1 table</span></span><span class="cons"><b>5</b> queries</span></div>
          </div></div>
      </section><section class="view pview" id="vProduct-trading" data-slug="trading">
        <div class="psplit">
          <div class="pleft">
            <div class="crumbs"><a data-go="market">Data Products</a><span class="sep">/</span><b>Trading</b></div>
            <div class="phead"><div class="glyph"><svg width="30" height="30" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg></div><h1>Trading</h1><span class="cert">release 1.1.0 · active</span></div>
            <div class="pdesc">order lines, orders and Finance&#x27;s trading measures; the table the Monday trading pack sums</div>
            <div class="tabs ptabs"><div class="tab ptab on" data-pt="overview">Overview</div><div class="tab ptab" data-pt="guide">Guide</div><div class="tab ptab" data-pt="model">Data model</div><div class="tab ptab" data-pt="metrics">Metrics</div><div class="tab ptab" data-pt="queries">Queries</div><div class="tab ptab" data-pt="quality">Quality</div><div class="tab ptab" data-pt="releases">Releases</div><div class="tab ptab" data-pt="contract">Contract</div></div>
            <div class="pscroll"><div class="pp on" data-pp="overview"><div class="pstats" style="grid-template-columns:repeat(4,minmax(0,1fr))"><div class="st"><div class="lbl">release</div><div class="v">1.1.0</div><div class="s2">2026-10-07</div></div><div class="st"><div class="lbl">grain</div><div class="v">one order line</div><div class="s2">cancelled orders left out</div></div><div class="st"><div class="lbl">data through</div><div class="v">2026-08-31</div><div class="s2">the last day delivered</div></div><div class="st"><div class="lbl">ready by</div><div class="v">07:00 UTC</div><div class="s2">daily, the SLA</div></div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>Tables</h3></div><div class="c">5 tables · gold_marts</div></div>
            <div class="trow h"><div>table</div><div>kind</div><div>rows</div><div>size</div><div>last update</div><div></div></div>
            <div class="trow live" data-go="table"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>obt_order_lines</div><div class="zone">one big table</div><div class="num">12,418,906</div><div class="num">820 MB</div><div class="num">2026-09-01 05:42</div><div class="go">open →</div></div><div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>fact_order_lines</div><div class="zone">fact</div><div class="num">12,646,385</div><div class="num">610 MB</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div><div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>fact_orders</div><div class="zone">fact</div><div class="num">5,248,906</div><div class="num">190 MB</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div><div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>metric_trading</div><div class="zone">metric</div><div class="num">12,892</div><div class="num">view</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div><div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>dim_date</div><div class="zone">dimension</div><div class="num">4,018</div><div class="num">1 MB</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>Read by</h3></div><div class="c">5 roles in ops/query_logs.csv</div></div>
            <div class="rrow"><div class="rr mono">finance_analyst</div><div class="rp">Finance</div><div class="rw">net revenue, margin and the month end</div></div><div class="rrow"><div class="rr mono">commercial_analyst</div><div class="rp">Commercial</div><div class="rw">sales by brand, category and SKU</div></div><div class="rrow"><div class="rr mono">marketing_analyst</div><div class="rp">Marketing</div><div class="rw">new, returning and guest orders</div></div><div class="rrow"><div class="rr mono">data_scientist</div><div class="rp">Data Science</div><div class="rw">the detail behind a model, read-only</div></div><div class="rrow"><div class="rr mono">monday_pack</div><div class="rp">the BI service</div><div class="rw">the Monday trading pack, safe to sum</div></div></div><div class="pp" data-pp="model"><div class="docline"><svg width="15" height="15" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M6 3h8l4 4v14H6z"/><path d="M14 3v4h4"/></svg><span>docs/data-products/obt_order_lines/model.md</span><span class="by">written by /data-product · 2026-10-07</span></div>
            <div class="star" style="height:872px"><svg width="1180" height="872" viewBox="0 0 1180 872"><path class="sl join" d="M590 286 V202"/><circle cx="590" cy="286" r="4"/><circle cx="590" cy="202" r="4"/><path class="sl join" d="M445 364 H290"/><circle cx="445" cy="364" r="4"/><circle cx="290" cy="364" r="4"/><path class="sl join" d="M735 364 H890"/><circle cx="735" cy="364" r="4"/><circle cx="890" cy="364" r="4"/><path class="sl built" d="M590 534 V618"/><circle cx="590" cy="534" r="4"/><circle cx="590" cy="618" r="4"/><path class="sl built" d="M670 534 V576 H955 V618"/><circle cx="670" cy="534" r="4"/><circle cx="955" cy="618" r="4"/><path class="sl join" d="M145 618 V488"/><circle cx="145" cy="618" r="4"/><circle cx="145" cy="488" r="4"/></svg><div class="sbox k-dimension" style="left:445px;top:0px;width:290px;height:202px"><div class="sk">DIMENSION</div><div class="sn">dim_date</div><div class="sc"><span class="cn key">date_key</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">calendar_date</span></div><div class="sc"><span class="cn dim">year_month</span></div><div class="sc"><span class="cn dim">day_name</span></div><div class="more">+ 9 columns</div></div><div class="sbox k-dimension other" style="left:0px;top:286px;width:290px;height:202px"><div class="sk">DIMENSION · CUSTOMERS</div><div class="sn">dim_customers</div><div class="sc"><span class="cn key">customer_id</span><span class="tg">PK</span></div><div class="sc"><span class="cn">home_country</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">signup_channel</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn dim">is_business</span></div><div class="more">+ 6 columns</div></div><div class="sbox k-fact" style="left:445px;top:286px;width:290px;height:248px"><div class="sk">FACT</div><div class="sn">fact_order_lines</div><div class="sc"><span class="cn key">line_id</span><span class="tg">PK</span></div><div class="sc"><span class="cn">date_key</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">customer_id</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">sku</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn dim">is_cancelled</span></div><div class="sc"><span class="cn dim">net_eur</span></div><div class="more">+ 12 columns</div></div><div class="sbox k-dimension other" style="left:890px;top:286px;width:290px;height:202px"><div class="sk">DIMENSION · PRODUCTS</div><div class="sn">dim_products</div><div class="sc"><span class="cn key">sku</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">product_name</span></div><div class="sc"><span class="cn dim">brand</span></div><div class="sc"><span class="cn dim">category</span></div><div class="more">+ 8 columns</div></div><div class="sbox k-fact" style="left:0px;top:618px;width:290px;height:248px"><div class="sk">FACT</div><div class="sn">fact_orders</div><div class="sc"><span class="cn key">order_id</span><span class="tg">PK</span></div><div class="sc"><span class="cn">date_key</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">customer_id</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">campaign_id</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn dim">is_cancelled</span></div><div class="sc"><span class="cn dim">net_eur</span></div><div class="more">+ 4 columns</div></div><div class="sbox k-one" style="left:445px;top:618px;width:290px;height:202px"><div class="sk">ONE BIG TABLE</div><div class="sn">obt_order_lines</div><div class="sc"><span class="cn key">line_id</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">order_id</span></div><div class="sc"><span class="cn dim">ordered_on</span></div><div class="sc"><span class="cn dim">net_eur</span></div><div class="more">+ 19 columns</div></div><div class="sbox k-metric" style="left:890px;top:618px;width:290px;height:202px"><div class="sk">METRIC</div><div class="sn">metric_trading</div><div class="sc"><span class="cn dim">order_month</span></div><div class="sc"><span class="cn dim">ship_country</span></div><div class="sc"><span class="cn dim">net_revenue_eur</span></div><div class="sc"><span class="cn dim">orders</span></div><div class="more">+ 9 columns</div></div><div class="slab" style="left:590px;top:244px">date_key</div><div class="slab" style="left:368px;top:364px">customer_id</div><div class="slab" style="left:812px;top:364px">sku</div><div class="slab" style="left:590px;top:576px">flattened</div><div class="slab" style="left:812px;top:576px">built from</div><div class="slab" style="left:145px;top:553px">customer_id</div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>One row is</h3></div><div class="c">5 tables</div></div>
            <div class="gt " style="--cols:290px minmax(0,1fr) 200px 320px"><div class="gh"><div>table</div><div>one row is</div><div>key</div><div>joins on</div></div><div class="gr"><div class="col"><span class="mono">obt_order_lines</span></div><div class="dim">an order line of an order that was not cancelled</div><div class=""><span class="mono">line_id</span></div><div class="dim">flattened from the fact and its dimensions</div></div><div class="gr"><div class="col"><span class="mono">fact_order_lines</span></div><div class="dim">an order line, cancelled ones included</div><div class=""><span class="mono">line_id</span></div><div class="dim">date_key, customer_id, sku</div></div><div class="gr"><div class="col"><span class="mono">fact_orders</span></div><div class="dim">an accepted order, cancelled ones included</div><div class=""><span class="mono">order_id</span></div><div class="dim">date_key, customer_id, campaign_id</div></div><div class="gr"><div class="col"><span class="mono">metric_trading</span></div><div class="dim">a month, market, channel, customer type and category, with Finance&#x27;s measures</div><div class="">the 5 columns</div><div class="dim">the same 5 columns, summed</div></div><div class="gr"><div class="col"><span class="mono">dim_date</span></div><div class="dim">a calendar day</div><div class=""><span class="mono">date_key</span></div><div class="dim">ordered_on = calendar_date</div></div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>Grain rules</h3></div><div class="c"></div></div><div class="tr"><b>One order has one or more lines.</b> <span>Count orders with count(DISTINCT order_id).</span></div><div class="tr"><b>One account has many orders.</b> <span>Count customers with count(DISTINCT customer_id), and leave out unknown.</span></div><div class="tr"><b>A product has one row in dim_products.</b> <span>Its price and cost have many versions in silver_core; the table already took the one valid on the order day.</span></div></div><div class="pp" data-pp="guide"><div class="docline"><svg width="15" height="15" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M6 3h8l4 4v14H6z"/><path d="M14 3v4h4"/></svg><span>docs/data-products/obt_order_lines/tour.md</span><span class="by">written by /data-product · 2026-10-07</span></div>
            <div class="guide">
              <div class="toc"><div class="th">Your first hour with obt_order_lines</div><div class="step" data-jump="g1"><span class="gnum">1</span><span class="st">What it is</span><span class="mn">5 min</span></div><div class="step" data-jump="g2"><span class="gnum">2</span><span class="st">What to trust</span><span class="mn">10 min</span></div><div class="step" data-jump="g3"><span class="gnum">3</span><span class="st">Open it</span><span class="mn">5 min</span></div><div class="step" data-jump="g4"><span class="gnum">4</span><span class="st">Run 3 starter queries</span><span class="mn">30 min</span></div><div class="step" data-jump="g5"><span class="gnum">5</span><span class="st">When something looks wrong</span><span class="mn">10 min</span></div><div class="step" data-jump="g6"><span class="gnum">6</span><span class="st">Whom to ask</span><span class="mn"></span></div></div>
              <div class="gbody">
                <p class="lead2">For a new consumer: an analyst, a team lead, a new member of Finance. Read this once, run the 3 queries, and you have the numbers of the Monday trading pack: net revenue, orders and margin by month, market and category.</p>
                <div class="gsec" id="g1"><h4><span class="gnum">1</span>What it is<span class="mn">5 min</span></h4>
                  <p>One row per order line of an order that was not cancelled, with its day, customer and product beside it. 12,418,906 rows, from 2022-01-01 to 2026-08-31. It lives in the warehouse as <span class="mono">gold_marts.obt_order_lines</span>, and it is rebuilt by every run that succeeds, daily from 05:30 UTC.</p></div>
                <div class="gsec" id="g2"><h4><span class="gnum">2</span>What to trust<span class="mn">10 min</span></h4><div class="tr"><b>Sum the money, never the counts.</b> <span>sum(net_eur) is Finance&#x27;s net revenue for any selection. Orders and customers are count(DISTINCT ...), recomputed for each selection.</span></div><div class="tr"><b>Cancelled orders are already out.</b> <span>Do not filter on status; there is none.</span></div><div class="tr"><b>Euros without VAT.</b> <span>No shipping, no refunds. Net revenue is not what the customer paid at checkout.</span></div><div class="tr"><b>The day is the UTC day of the checkout.</b> <span>An order placed at 01:30 in Berlin belongs to the day before.</span></div><div class="tr"><b>Guests are unknown.</b> <span>They have no account, so they share one customer_id.</span></div><div class="tr"><b>The data is as good as the last run that succeeded.</b> <span>When a delivery is late, the gold tasks are skipped and consumers read the gold of the last run that built it. A wrong file or row is quarantined and the rest of the day is built; the Quality tab lists both.</span></div></div>
                <div class="gsec" id="g3"><h4><span class="gnum">3</span>Open it<span class="mn">5 min</span></h4>
                  <p>Read-only, and never while the daily run is writing. In Python:</p>
                  <pre><span class="s-kw">import</span> duckdb
con = duckdb.connect(<span class="s-str">&quot;data/warehouse/newvolt.duckdb&quot;</span>, read_only=<span class="s-num">True</span>)
con.sql(<span class="s-str">&quot;SELECT count(*) FROM gold_marts.obt_order_lines&quot;</span>).show()</pre>
                  <p class="dim">If it says the file is locked, a run is writing. Wait until the run has finished, about 12 min after 05:30 UTC. More in <span class="mono">knowledge/connections.md</span>.</p></div>
                <div class="gsec" id="g4"><h4><span class="gnum">4</span>Run 3 starter queries<span class="mn">30 min</span></h4>
                  <div class="ans" data-q="1"><span class="q">Net revenue by month · query 1</span><b>EUR 51,276,728.40</b><span>97,030 orders · EUR 528.46 per order</span></div>
                  <div class="ans" data-q="2"><span class="q">The month by market · query 2</span><b>EUR 21,934,110.52</b><span>Germany, 39,780 of the month's orders</span></div>
                  <div class="ans" data-q="4"><span class="q">Margin by category · query 4</span><b>EUR 7,036,218.52</b><span>13.7 percent of the month's net revenue</span></div>
                  <p class="dim">If your numbers differ from these, the table was rebuilt since this page was written, or your filter differs. Ask before you report.</p></div>
                <div class="gsec" id="g5"><h4><span class="gnum">5</span>When something looks wrong<span class="mn">10 min</span></h4>
                  <div class="tr"><b>First the known issues.</b> <span>It may be known, with a workaround.</span></div>
                  <div class="tr"><b>Then the Quality tab, or the Runs page.</b> <span>When the gold tasks of a run were skipped, the newest day is not in.</span></div>
                  <div class="tr"><b>Then write to the data engineer,</b> <span>with your query and the number you expected. Your correction goes into corrections.md.</span></div></div>
                <div class="gsec" id="g6"><h4><span class="gnum">6</span>Whom to ask</h4><div class="gt " style="--cols:250px 190px minmax(0,1fr)"><div class="gh"><div>question</div><div>who</div><div>address</div></div><div class="gr"><div class="col">What a measure means</div><div class="">Finance</div><div class="dim"><span class="mono">Finance team</span></div></div><div class="gr"><div class="col">A number that looks wrong</div><div class="">the data engineer</div><div class="dim"><span class="mono">data engineering team</span></div></div><div class="gr"><div class="col">A product, a price, a listing</div><div class="">Commercial</div><div class="dim"><span class="mono">Commercial team</span></div></div><div class="gr"><div class="col">A campaign or a voucher</div><div class="">Marketing</div><div class="dim"><span class="mono">Marketing team</span></div></div></div></div>
              </div>
            </div></div><div class="pp" data-pp="metrics"><div class="docline"><svg width="15" height="15" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M6 3h8l4 4v14H6z"/><path d="M14 3v4h4"/></svg><span>docs/data-products/obt_order_lines/metrics.md</span><span class="by">written by /data-product · 2026-10-07</span></div>
            <div class="status"><span class="draft">draft for Finance</span><span class="dim">Finance signs them · 8 of the 12 are also in the view <span class="mono">gold_marts.metric_trading</span></span></div>
            <div class="gt " style="--cols:210px minmax(0,1fr) 170px 280px"><div class="gh"><div>measure</div><div>formula on this table</div><div>sums across rows</div><div>Finance's words</div></div><div class="gr"><div class="col">Gross merchandise</div><div class="code"><span class="mono"><span class="s-fn">sum</span>(gross_eur)</span></div><div class="">yes</div><div class="dim">quantity times list price, before discount</div></div><div class="gr"><div class="col">Discount</div><div class="code"><span class="mono"><span class="s-fn">sum</span>(discount_eur)</span></div><div class="">yes</div><div class="dim">the whole-line discount</div></div><div class="gr"><div class="col">Net revenue</div><div class="code"><span class="mono"><span class="s-fn">sum</span>(net_eur)</span></div><div class="">yes</div><div class="dim">line net after discount; excludes shipping and refunds</div></div><div class="gr"><div class="col">Units sold</div><div class="code"><span class="mono"><span class="s-fn">sum</span>(quantity)</span></div><div class="">yes</div><div class="dim">the ordered units of the selected lines</div></div><div class="gr"><div class="col">Orders</div><div class="code"><span class="mono"><span class="s-fn">count</span>(<span class="s-kw">DISTINCT</span> order_id)</span></div><div class="dim">no: an order can sit in 2 categories</div><div class="dim">distinct non-cancelled order references</div></div><div class="gr"><div class="col">Average order value</div><div class="code"><span class="mono"><span class="s-fn">sum</span>(net_eur) / <span class="s-fn">count</span>(<span class="s-kw">DISTINCT</span> order_id)</span></div><div class="dim">no: recompute per selection</div><div class="dim">selected net revenue divided by selected distinct orders</div></div><div class="gr"><div class="col">Weighted discount</div><div class="code"><span class="mono"><span class="s-fn">sum</span>(discount_eur) / <span class="s-fn">sum</span>(gross_eur)</span></div><div class="dim">no</div><div class="dim">total line discount divided by gross merchandise</div></div><div class="gr"><div class="col">Standard cost</div><div class="code"><span class="mono"><span class="s-fn">sum</span>(standard_cost_eur)</span></div><div class="">yes</div><div class="dim">units sold times the dated standard cost</div></div><div class="gr"><div class="col">Margin</div><div class="code"><span class="mono"><span class="s-fn">sum</span>(net_eur) - <span class="s-fn">sum</span>(standard_cost_eur)</span></div><div class="">yes</div><div class="dim">net revenue minus units sold times dated standard cost</div></div><div class="gr"><div class="col">Margin percent</div><div class="code"><span class="mono">(<span class="s-fn">sum</span>(net_eur) - <span class="s-fn">sum</span>(standard_cost_eur))
/ <span class="s-fn">sum</span>(net_eur)</span></div><div class="dim">no</div><div class="dim">margin divided by net revenue</div></div><div class="gr"><div class="col">Registered customers</div><div class="code"><span class="mono"><span class="s-fn">count</span>(<span class="s-kw">DISTINCT</span> customer_id)
<span class="s-kw">FILTER</span> (<span class="s-kw">WHERE</span> customer_id &lt;&gt; <span class="s-str">&#x27;unknown&#x27;</span>)</span></div><div class="dim">no</div><div class="dim">accounts with a selected order; distinct within the selection</div></div><div class="gr"><div class="col">Guest share of orders</div><div class="code"><span class="mono"><span class="s-fn">count</span>(<span class="s-kw">DISTINCT</span> order_id)
<span class="s-kw">FILTER</span> (<span class="s-kw">WHERE</span> customer_type = <span class="s-str">&#x27;guest&#x27;</span>)
/ <span class="s-fn">count</span>(<span class="s-kw">DISTINCT</span> order_id)</span></div><div class="dim">no</div><div class="dim">guest orders divided by all orders</div></div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>Rules for every measure</h3></div><div class="c"></div></div>
            <div class="tr"><b>A zero denominator gives a blank, never a percentage.</b> <span>nullif(..., 0) in every ratio.</span></div><div class="tr"><b>Never add counts.</b> <span>In <span class="nw">2026-08</span> the orders of the 6 markets add to 97,030 only because an order ships to 1 country; the orders of the 5 categories add to 118,276, because an order with a cable and a laptop counts in both.</span></div><div class="tr"><b>The day is the UTC day of the checkout.</b> <span>ordered_on and order_month come from it. Refund postings and cash dates are other time bases and are not in this table.</span></div><div class="tr"><b>Year on year compares the same days.</b> <span>A new product with no sales a year before has no growth percentage.</span></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>Not here, on purpose</h3></div><div class="c">4 measures</div></div>
            <div class="gt " style="--cols:250px minmax(0,1fr) 330px"><div class="gh"><div>measure</div><div>why not</div><div>where it will come from</div></div><div class="gr"><div class="col">Margin after refunds</div><div class="dim">refunds arrive up to 60 days after the sale and would change closed months</div><div class="dim">a join of this table with <span class="mono">gold_marts.fact_returns</span> on line_id; open in the decision log</div></div><div class="gr"><div class="col">Order-return rate</div><div class="dim">returns are not in this table</div><div class="dim"><span class="mono">gold_marts.fact_returns</span>, the Returns product</div></div><div class="gr"><div class="col">Recorded order contribution</div><div class="dim">needs shipping fees, refunds and parcel expense</div><div class="dim">not built</div></div><div class="gr"><div class="col">Target attainment</div><div class="dim">needs sales_targets</div><div class="dim">the clean table, by month and country</div></div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>What is in, what is out</h3></div><div class="c">business-logic.md</div></div>
            <div class="inout">
              <div class="card half"><div class="hd">in the table</div><div class="li"><b>one row per order line</b><span>line_id is the key</span></div><div class="li"><b>booked orders</b><span>status 10 and 25 count; not statutory revenue</span></div><div class="li"><b>history from 2022-01-01</b><span>earlier trading is outside the data</span></div><div class="li"><b>the UTC day of the checkout</b><span>23:30 UTC on <span class="nw">2026-08-19</span> is <span class="nw">2026-08-19</span></span></div><div class="li"><b>euros without VAT</b><span>converted once from whole cents</span></div><div class="li"><b>the standard cost of the order day</b><span>never the current cost</span></div><div class="li"><b>the campaign window</b><span>the discount says whether an offer was used</span></div></div>
              <div class="card half"><div class="hd out">not in the table</div><div class="li"><b>cancelled orders</b><span>status 90; so a plain sum is the trading number</span></div><div class="li"><b>the shipping fee</b><span>per order; shipping_fee_cents in <span class="mono">silver_clean.orders</span></span></div><div class="li"><b>refunds and returns</b><span>margin is before refunds</span></div><div class="li"><b>VAT</b><span>the German shop shows 19 percent VAT; this table never shows VAT</span></div><div class="li"><b>names, emails, years of birth</b><span>they stay in <span class="mono">silver_core.customers</span></span></div><div class="li"><b>cities and postal codes</b><span>removed in 1.1.0; in <span class="mono">gold_marts.dim_customers</span></span></div><div class="li"><b>the current cost on an old sale</b><span>standard_cost_eur holds the cost of the day</span></div></div>
            </div></div><div class="pp" data-pp="queries"><div class="docline"><svg width="15" height="15" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M6 3h8l4 4v14H6z"/><path d="M14 3v4h4"/></svg><span>docs/data-products/obt_order_lines/starter-queries.sql</span><span class="by">written by /data-product · 2026-10-07</span></div>
            <div class="status"><span class="note">10 queries</span><span class="dim">from <span class="mono">ops/query_logs.csv</span> and the corrections consumers sent</span></div>
            <div class="qlib"><div class="qlist"><div class="qitem on" data-q="1"><span class="qn">1</span><span class="qs">Net revenue by month</span></div><div class="qitem" data-q="2"><span class="qn">2</span><span class="qs">The month by market</span></div><div class="qitem" data-q="3"><span class="qn">3</span><span class="qs">2026-08 against 2025-08</span></div><div class="qitem" data-q="4"><span class="qn">4</span><span class="qs">Margin by category</span></div><div class="qitem" data-q="5"><span class="qn">5</span><span class="qs">New, returning and guest</span></div><div class="qitem" data-q="6"><span class="qn">6</span><span class="qs">Top 10 products</span></div><div class="qitem" data-q="7"><span class="qn">7</span><span class="qs">Discount by channel</span></div><div class="qitem" data-q="8"><span class="qn">8</span><span class="qs">Campaign windows</span></div><div class="qitem" data-q="9"><span class="qn">9</span><span class="qs">Customers and guest share</span></div><div class="qitem" data-q="10"><span class="qn">10</span><span class="qs">One order, line by line</span></div></div><div class="qdetail"><div class="qd on" data-qd="1">
              <div class="qh"><span class="qn big">1</span><div><div class="qt">Net revenue, orders and average order value by month</div><div class="qg">one row per month</div></div></div>
              <pre class="sql"><span class="s-kw">SELECT</span>
  order_month,
  <span class="s-fn">sum</span>(net_eur)                                                  <span class="s-kw">AS</span> net_revenue_eur,
  <span class="s-fn">count</span>(<span class="s-kw">DISTINCT</span> order_id)                                      <span class="s-kw">AS</span> orders,
  <span class="s-fn">round</span>(<span class="s-fn">sum</span>(net_eur) / <span class="s-fn">nullif</span>(<span class="s-fn">count</span>(<span class="s-kw">DISTINCT</span> order_id), <span class="s-num">0</span>), <span class="s-num">2</span>)  <span class="s-kw">AS</span> average_order_value_eur
<span class="s-kw">FROM</span> gold_marts.obt_order_lines
<span class="s-kw">WHERE</span> order_month &gt;= <span class="s-str">&#x27;2026-01&#x27;</span>
<span class="s-kw">GROUP BY</span> order_month
<span class="s-kw">ORDER BY</span> order_month;</pre><div class="rhd"><span>Result</span><span class="dim">8 rows · as run on 2026-10-07</span></div><div class="gt res" style="--cols:190px minmax(0,1fr) minmax(0,1fr) minmax(0,1fr)"><div class="gh"><div>order_month</div><div class=r>net_revenue_eur</div><div class=r>orders</div><div class=r>average_order_value_eur</div></div><div class="gr"><div class="mono">2026-01</div><div class="mono num r">48,076,758.96</div><div class="mono num r">104,632</div><div class="mono num r">459.48</div></div><div class="gr"><div class="mono">2026-02</div><div class="mono num r">36,972,587.01</div><div class="mono num r">71,021</div><div class="mono num r">520.59</div></div><div class="gr"><div class="mono">2026-03</div><div class="mono num r">47,816,213.46</div><div class="mono num r">90,311</div><div class="mono num r">529.46</div></div><div class="gr"><div class="mono">2026-04</div><div class="mono num r">45,909,425.22</div><div class="mono num r">89,795</div><div class="mono num r">511.27</div></div><div class="gr"><div class="mono">2026-05</div><div class="mono num r">52,303,291.17</div><div class="mono num r">101,455</div><div class="mono num r">515.53</div></div><div class="gr"><div class="mono">2026-06</div><div class="mono num r">52,655,239.23</div><div class="mono num r">100,614</div><div class="mono num r">523.34</div></div><div class="gr"><div class="mono">2026-07</div><div class="mono num r">44,882,531.34</div><div class="mono num r">80,605</div><div class="mono num r">556.82</div></div><div class="gr"><div class="mono">2026-08</div><div class="mono num r">51,276,728.40</div><div class="mono num r">97,030</div><div class="mono num r">528.46</div></div></div></div><div class="qd" data-qd="2">
              <div class="qh"><span class="qn big">2</span><div><div class="qt">The month by market: where the orders shipped to</div><div class="qg">one row per ship country</div></div></div>
              <pre class="sql"><span class="s-kw">SELECT</span>
  ship_country,
  <span class="s-fn">count</span>(<span class="s-kw">DISTINCT</span> order_id)  <span class="s-kw">AS</span> orders,
  <span class="s-fn">sum</span>(net_eur)              <span class="s-kw">AS</span> net_revenue_eur
<span class="s-kw">FROM</span> gold_marts.obt_order_lines
<span class="s-kw">WHERE</span> order_month = <span class="s-str">&#x27;2026-08&#x27;</span>
<span class="s-kw">GROUP BY</span> ship_country
<span class="s-kw">ORDER BY</span> net_revenue_eur <span class="s-kw">DESC</span>;</pre><div class="rhd"><span>Result</span><span class="dim">6 rows · as run on 2026-10-07</span></div><div class="gt res" style="--cols:190px minmax(0,1fr) minmax(0,1fr)"><div class="gh"><div>ship_country</div><div class=r>orders</div><div class=r>net_revenue_eur</div></div><div class="gr"><div class="mono">DE</div><div class="mono num r">39,780</div><div class="mono num r">21,934,110.52</div></div><div class="gr"><div class="mono">FR</div><div class="mono num r">17,180</div><div class="mono num r">9,021,604.80</div></div><div class="gr"><div class="mono">NL</div><div class="mono num r">11,981</div><div class="mono num r">6,391,880.16</div></div><div class="gr"><div class="mono">AT</div><div class="mono num r">10,388</div><div class="mono num r">5,409,224.00</div></div><div class="gr"><div class="mono">IT</div><div class="mono num r">9,436</div><div class="mono num r">4,816,117.12</div></div><div class="gr"><div class="mono">ES</div><div class="mono num r">8,265</div><div class="mono num r">3,703,791.80</div></div></div></div><div class="qd" data-qd="3">
              <div class="qh"><span class="qn big">3</span><div><div class="qt">The same month a year before, the same days</div><div class="qg">one row per year</div></div></div>
              <pre class="sql"><span class="s-kw">SELECT</span>
  order_year,
  <span class="s-fn">sum</span>(net_eur)              <span class="s-kw">AS</span> net_revenue_eur,
  <span class="s-fn">count</span>(<span class="s-kw">DISTINCT</span> order_id)  <span class="s-kw">AS</span> orders
<span class="s-kw">FROM</span> gold_marts.obt_order_lines
<span class="s-kw">WHERE</span> <span class="s-fn">month</span>(ordered_on) = <span class="s-num">8</span>
  <span class="s-kw">AND</span> order_year <span class="s-kw">IN</span> (<span class="s-num">2025</span>, <span class="s-num">2026</span>)
<span class="s-kw">GROUP BY</span> order_year
<span class="s-kw">ORDER BY</span> order_year;</pre><div class="rhd"><span>Result</span><span class="dim">2 rows · as run on 2026-10-07</span></div><div class="gt res" style="--cols:190px minmax(0,1fr) minmax(0,1fr)"><div class="gh"><div>order_year</div><div class=r>net_revenue_eur</div><div class=r>orders</div></div><div class="gr"><div class="mono">2025</div><div class="mono num r">51,925,498.33</div><div class="mono num r">110,550</div></div><div class="gr"><div class="mono">2026</div><div class="mono num r">51,276,728.40</div><div class="mono num r">97,030</div></div></div></div><div class="qd" data-qd="4">
              <div class="qh"><span class="qn big">4</span><div><div class="qt">Margin by category</div><div class="qg">one row per category; margin is net revenue minus the cost of the order day</div></div></div>
              <pre class="sql"><span class="s-kw">SELECT</span>
  category,
  <span class="s-fn">sum</span>(net_eur)                                 <span class="s-kw">AS</span> net_revenue_eur,
  <span class="s-fn">sum</span>(standard_cost_eur)                       <span class="s-kw">AS</span> standard_cost_eur,
  <span class="s-fn">sum</span>(net_eur) - <span class="s-fn">sum</span>(standard_cost_eur)        <span class="s-kw">AS</span> margin_eur,
  <span class="s-fn">round</span>((<span class="s-fn">sum</span>(net_eur) - <span class="s-fn">sum</span>(standard_cost_eur))
        / <span class="s-fn">nullif</span>(<span class="s-fn">sum</span>(net_eur), <span class="s-num">0</span>), <span class="s-num">4</span>)          <span class="s-kw">AS</span> margin_pct
<span class="s-kw">FROM</span> gold_marts.obt_order_lines
<span class="s-kw">WHERE</span> order_month = <span class="s-str">&#x27;2026-08&#x27;</span>
<span class="s-kw">GROUP BY</span> category
<span class="s-kw">ORDER BY</span> margin_eur <span class="s-kw">DESC</span>;</pre><div class="rhd"><span>Result</span><span class="dim">5 rows · as run on 2026-10-07</span></div><div class="gt res" style="--cols:190px minmax(0,1fr) minmax(0,1fr) minmax(0,1fr) minmax(0,1fr)"><div class="gh"><div>category</div><div class=r>net_revenue_eur</div><div class=r>standard_cost_eur</div><div class=r>margin_eur</div><div class=r>margin_pct</div></div><div class="gr"><div class="mono">Phones and Tablets</div><div class="mono num r">18,462,906.15</div><div class="mono num r">16,363,396.78</div><div class="mono num r">2,099,509.37</div><div class="mono num r">0.1137</div></div><div class="gr"><div class="mono">Accessories</div><div class="mono num r">7,182,406.15</div><div class="mono num r">5,448,989.88</div><div class="mono num r">1,733,416.27</div><div class="mono num r">0.2413</div></div><div class="gr"><div class="mono">Computers</div><div class="mono num r">14,918,377.42</div><div class="mono num r">13,450,662.69</div><div class="mono num r">1,467,714.73</div><div class="mono num r">0.0984</div></div><div class="gr"><div class="mono">Monitors</div><div class="mono num r">6,408,219.90</div><div class="mono num r">5,430,665.18</div><div class="mono num r">977,554.72</div><div class="mono num r">0.1525</div></div><div class="gr"><div class="mono">Audio</div><div class="mono num r">4,304,818.78</div><div class="mono num r">3,546,795.35</div><div class="mono num r">758,023.43</div><div class="mono num r">0.1761</div></div></div></div><div class="qd" data-qd="5">
              <div class="qh"><span class="qn big">5</span><div><div class="qt">New, returning and guest orders</div><div class="qg">one row per customer type; Finance&#x27;s type, set at checkout</div></div></div>
              <pre class="sql"><span class="s-kw">SELECT</span>
  customer_type,
  <span class="s-fn">count</span>(<span class="s-kw">DISTINCT</span> order_id)  <span class="s-kw">AS</span> orders,
  <span class="s-fn">sum</span>(net_eur)              <span class="s-kw">AS</span> net_revenue_eur
<span class="s-kw">FROM</span> gold_marts.obt_order_lines
<span class="s-kw">WHERE</span> order_month = <span class="s-str">&#x27;2026-08&#x27;</span>
<span class="s-kw">GROUP BY</span> customer_type
<span class="s-kw">ORDER BY</span> customer_type;</pre><div class="rhd"><span>Result</span><span class="dim">3 rows · as run on 2026-10-07</span></div><div class="gt res" style="--cols:190px minmax(0,1fr) minmax(0,1fr)"><div class="gh"><div>customer_type</div><div class=r>orders</div><div class=r>net_revenue_eur</div></div><div class="gr"><div class="mono">guest</div><div class="mono num r">12,529</div><div class="mono num r">6,703,067.26</div></div><div class="gr"><div class="mono">new</div><div class="mono num r">20,049</div><div class="mono num r">10,898,631.59</div></div><div class="gr"><div class="mono">returning</div><div class="mono num r">64,452</div><div class="mono num r">33,675,029.55</div></div></div></div><div class="qd" data-qd="6">
              <div class="qh"><span class="qn big">6</span><div><div class="qt">The 10 products with the highest net revenue in the month</div><div class="qg">one row per product</div></div></div>
              <pre class="sql"><span class="s-kw">SELECT</span>
  sku,
  product_name,
  brand,
  <span class="s-fn">sum</span>(quantity)  <span class="s-kw">AS</span> units,
  <span class="s-fn">sum</span>(net_eur)   <span class="s-kw">AS</span> net_revenue_eur
<span class="s-kw">FROM</span> gold_marts.obt_order_lines
<span class="s-kw">WHERE</span> order_month = <span class="s-str">&#x27;2026-08&#x27;</span>
<span class="s-kw">GROUP BY</span> sku, product_name, brand
<span class="s-kw">ORDER BY</span> net_revenue_eur <span class="s-kw">DESC</span>
<span class="s-kw">LIMIT</span> <span class="s-num">10</span>;</pre><div class="rhd"><span>Result</span><span class="dim">10 rows · as run on 2026-10-07</span></div><div class="gt res" style="--cols:96px minmax(0,1fr) 62px 70px 132px"><div class="gh"><div>sku</div><div>product_name</div><div>brand</div><div class=r>units</div><div class=r>net_revenue_eur</div></div><div class="gr"><div class="mono">PA-11001</div><div class="mono">Pavo One 8 Phone 128GB</div><div class="mono">Pavo</div><div class="mono num r">11,790</div><div class="mono num r">2,733,315.29</div></div><div class="gr"><div class="mono">PA-12001</div><div class="mono">Pavo One 8 Phone 128GB (silver)</div><div class="mono">Pavo</div><div class="mono num r">8,498</div><div class="mono num r">1,713,892.29</div></div><div class="gr"><div class="mono">KO-25003</div><div class="mono">Kova G3-1740 15.6 Laptop 16GB/1024GB</div><div class="mono">Kova</div><div class="mono num r">1,668</div><div class="mono num r">1,620,792.95</div></div><div class="gr"><div class="mono">PA-13001</div><div class="mono">Pavo One 8 Phone 256GB White</div><div class="mono">Pavo</div><div class="mono num r">5,450</div><div class="mono num r">1,485,920.67</div></div><div class="gr"><div class="mono">KO-24603</div><div class="mono">Kova K7-1890 15.6 Laptop 32GB/1024GB (green)</div><div class="mono">Kova</div><div class="mono num r">957</div><div class="mono num r">1,083,056.66</div></div><div class="gr"><div class="mono">KO-23303</div><div class="mono">Kova K5-1440 14 Laptop 16GB/512GB White</div><div class="mono">Kova</div><div class="mono num r">1,513</div><div class="mono num r">1,077,220.47</div></div><div class="gr"><div class="mono">KA-17003</div><div class="mono">Kaivo X 15 Gen 3 Phone 256GB Red</div><div class="mono">Kaivo</div><div class="mono num r">1,624</div><div class="mono num r">970,514.10</div></div><div class="gr"><div class="mono">KA-12003</div><div class="mono">Kaivo Pro 10 Gen 3 Phone 64GB (silver)</div><div class="mono">Kaivo</div><div class="mono num r">2,425</div><div class="mono num r">914,208.96</div></div><div class="gr"><div class="mono">KO-21603</div><div class="mono">Kova K3-1890 15.6 Laptop 32GB/1024GB (green)</div><div class="mono">Kova</div><div class="mono num r">979</div><div class="mono num r">914,099.79</div></div><div class="gr"><div class="mono">KO-27003</div><div class="mono">Kova G3-2040 16 Laptop 32GB/1024GB Red</div><div class="mono">Kova</div><div class="mono num r">845</div><div class="mono num r">878,536.08</div></div></div></div><div class="qd" data-qd="7">
              <div class="qh"><span class="qn big">7</span><div><div class="qt">The weighted discount by channel</div><div class="qg">one row per channel; the whole discount over the whole gross</div></div></div>
              <pre class="sql"><span class="s-kw">SELECT</span>
  channel,
  <span class="s-fn">sum</span>(gross_eur)                                           <span class="s-kw">AS</span> gross_merchandise_eur,
  <span class="s-fn">sum</span>(discount_eur)                                        <span class="s-kw">AS</span> discount_eur,
  <span class="s-fn">round</span>(<span class="s-fn">sum</span>(discount_eur) / <span class="s-fn">nullif</span>(<span class="s-fn">sum</span>(gross_eur), <span class="s-num">0</span>), <span class="s-num">4</span>)  <span class="s-kw">AS</span> weighted_discount
<span class="s-kw">FROM</span> gold_marts.obt_order_lines
<span class="s-kw">WHERE</span> order_month = <span class="s-str">&#x27;2026-08&#x27;</span>
<span class="s-kw">GROUP BY</span> channel
<span class="s-kw">ORDER BY</span> gross_merchandise_eur <span class="s-kw">DESC</span>;</pre><div class="rhd"><span>Result</span><span class="dim">3 rows · as run on 2026-10-07</span></div><div class="gt res" style="--cols:190px minmax(0,1fr) minmax(0,1fr) minmax(0,1fr)"><div class="gh"><div>channel</div><div class=r>gross_merchandise_eur</div><div class=r>discount_eur</div><div class=r>weighted_discount</div></div><div class="gr"><div class="mono">web</div><div class="mono num r">36,471,259.13</div><div class="mono num r">3,508,953.74</div><div class="mono num r">0.0962</div></div><div class="gr"><div class="mono">app</div><div class="mono num r">19,057,359.81</div><div class="mono num r">1,737,561.01</div><div class="mono num r">0.0912</div></div><div class="gr"><div class="mono">marketplace</div><div class="mono num r">1,088,872.01</div><div class="mono num r">94,247.80</div><div class="mono num r">0.0866</div></div></div></div><div class="qd" data-qd="8">
              <div class="qh"><span class="qn big">8</span><div><div class="qt">Orders inside a campaign window</div><div class="qg">one row per campaign; a window is not proof an offer was used</div></div></div>
              <pre class="sql"><span class="s-kw">SELECT</span>
  campaign_id,
  <span class="s-fn">count</span>(<span class="s-kw">DISTINCT</span> order_id)  <span class="s-kw">AS</span> orders,
  <span class="s-fn">sum</span>(discount_eur)         <span class="s-kw">AS</span> discount_eur,
  <span class="s-fn">sum</span>(net_eur)              <span class="s-kw">AS</span> net_revenue_eur
<span class="s-kw">FROM</span> gold_marts.obt_order_lines
<span class="s-kw">WHERE</span> order_month = <span class="s-str">&#x27;2026-08&#x27;</span>
  <span class="s-kw">AND</span> campaign_id <span class="s-kw">IS</span> <span class="s-kw">NOT</span> <span class="s-kw">NULL</span>
<span class="s-kw">GROUP BY</span> campaign_id
<span class="s-kw">ORDER BY</span> orders <span class="s-kw">DESC</span>;</pre><div class="rhd"><span>Result</span><span class="dim">3 rows · as run on 2026-10-07</span></div><div class="gt res" style="--cols:190px minmax(0,1fr) minmax(0,1fr) minmax(0,1fr)"><div class="gh"><div>campaign_id</div><div class=r>orders</div><div class=r>discount_eur</div><div class=r>net_revenue_eur</div></div><div class="gr"><div class="mono">BTS2026</div><div class="mono num r">50,687</div><div class="mono num r">4,318,512.25</div><div class="mono num r">26,249,196.17</div></div><div class="gr"><div class="mono">WB20260803</div><div class="mono num r">1,819</div><div class="mono num r">144,022.02</div><div class="mono num r">1,144,746.05</div></div><div class="gr"><div class="mono">WB20260720</div><div class="mono num r">855</div><div class="mono num r">49,309.05</div><div class="mono num r">425,443.67</div></div></div></div><div class="qd" data-qd="9">
              <div class="qh"><span class="qn big">9</span><div><div class="qt">Registered customers in the month, and the guest share of orders</div><div class="qg">one row</div></div></div>
              <pre class="sql"><span class="s-kw">SELECT</span>
  <span class="s-fn">count</span>(<span class="s-kw">DISTINCT</span> customer_id) <span class="s-kw">FILTER</span> (<span class="s-kw">WHERE</span> customer_id &lt;&gt; <span class="s-str">&#x27;unknown&#x27;</span>)
    <span class="s-kw">AS</span> registered_customers,
  <span class="s-fn">round</span>(<span class="s-fn">count</span>(<span class="s-kw">DISTINCT</span> order_id) <span class="s-kw">FILTER</span> (<span class="s-kw">WHERE</span> customer_type = <span class="s-str">&#x27;guest&#x27;</span>)
        / <span class="s-fn">nullif</span>(<span class="s-fn">count</span>(<span class="s-kw">DISTINCT</span> order_id), <span class="s-num">0</span>), <span class="s-num">4</span>)
    <span class="s-kw">AS</span> guest_share_of_orders
<span class="s-kw">FROM</span> gold_marts.obt_order_lines
<span class="s-kw">WHERE</span> order_month = <span class="s-str">&#x27;2026-08&#x27;</span>;</pre><div class="rhd"><span>Result</span><span class="dim">1 row · as run on 2026-10-07</span></div><div class="gt res" style="--cols:minmax(0,1fr) minmax(0,1fr)"><div class="gh"><div class=r>registered_customers</div><div class=r>guest_share_of_orders</div></div><div class="gr"><div class="mono num r">78,433</div><div class="mono num r">0.1291</div></div></div></div><div class="qd" data-qd="10">
              <div class="qh"><span class="qn big">10</span><div><div class="qt">One order, line by line: to check a number against the shop</div><div class="qg">one row per line</div></div></div>
              <pre class="sql"><span class="s-kw">SELECT</span>
  line_id, ordered_on, sku, product_name,
  quantity, gross_eur, discount_eur, net_eur
<span class="s-kw">FROM</span> gold_marts.obt_order_lines
<span class="s-kw">WHERE</span> order_id = <span class="s-str">&#x27;SO372035&#x27;</span>
<span class="s-kw">ORDER BY</span> line_id;</pre><div class="rhd"><span>Result</span><span class="dim">1 row · as run on 2026-10-07</span></div><div class="gt res rec" style="--cols:200px minmax(0,1fr)"><div class="gh"><div>column</div><div>value</div></div><div class="gr"><div class="col"><span class="mono">line_id</span></div><div class="mono">SO372035-01</div></div><div class="gr"><div class="col"><span class="mono">ordered_on</span></div><div class="mono">2026-08-01</div></div><div class="gr"><div class="col"><span class="mono">sku</span></div><div class="mono">KO-26003</div></div><div class="gr"><div class="col"><span class="mono">product_name</span></div><div class="mono">Kova G3-1890 15.6 Laptop 32GB/1024GB (green)</div></div><div class="gr"><div class="col"><span class="mono">quantity</span></div><div class="mono">1</div></div><div class="gr"><div class="col"><span class="mono">gross_eur</span></div><div class="mono">949.57</div></div><div class="gr"><div class="col"><span class="mono">discount_eur</span></div><div class="mono">0.00</div></div><div class="gr"><div class="col"><span class="mono">net_eur</span></div><div class="mono">949.57</div></div></div></div></div></div></div><div class="pp" data-pp="quality"><div class="docline"><svg width="15" height="15" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M6 3h8l4 4v14H6z"/><path d="M14 3v4h4"/></svg><span>docs/data-products/obt_order_lines/known-issues.md · health.md · consumer-safe.md</span><span class="by">written by /data-product · 2026-10-07</span></div>
            <div class="pstats" style="grid-template-columns:repeat(5,minmax(0,1fr))"><div class="st"><div class="lbl">data through</div><div class="v">2026-08-31</div><div class="s2">the last day delivered</div></div><div class="st"><div class="lbl">last build</div><div class="v sm">2026-09-01 05:42</div><div class="s2">succeeded in 12 min 12 s</div></div><div class="st"><div class="lbl">the month</div><div class="v">final</div><div class="s2">41 of 41 tables reconciled</div></div><div class="st"><div class="lbl">checks · last run</div><div class="v">28 passed</div><div class="s2">3 warned, 0 failed</div></div><div class="st"><div class="lbl">known issues</div><div class="v orange">5 open</div><div class="s2">3 closed</div></div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>Known issues</h3></div><div class="c">8 issues, newest first</div></div>
            <div class="gt " style="--cols:minmax(0,1fr) 300px 190px 210px"><div class="gh"><div>issue</div><div>workaround</div><div>owner</div><div>status</div></div><div class="gr"><div class="">212 of 1,106 queries on fact_order_lines in <span class="nw">2026-08</span> sum net_eur without NOT is_cancelled and overstate the month by EUR 646,086.78, 1.26 percent</div><div class="dim">read obt_order_lines, or add NOT is_cancelled</div><div class="dim">the data engineer</div><div class="orange">open since <span class="nw">2026-10-07</span></div></div><div class="gr"><div class="">the 4 euro columns are DOUBLE in the warehouse, not DECIMAL(18,2) as the contract says</div><div class="dim">round(sum(net_eur), 2); a sum can print 51276728.400000013</div><div class="dim">the data engineer, task t15</div><div class="orange">open since 1.0.0</div></div><div class="gr"><div class="">no refunds in the table: margin is before refunds, and returns arrive up to 60 days after the sale</div><div class="dim">for refunds, read <span class="mono">gold_marts.fact_returns</span>, refund_eur</div><div class="dim">the data engineer and Finance</div><div class="orange">open</div></div><div class="gr"><div class="">home_country is the country of the account, not the market of the sale</div><div class="dim">use ship_country for sales by market</div><div class="dim">the data engineer</div><div class="orange">open, by design</div></div><div class="gr"><div class="">acquisition_source is marketplace on every marketplace order; the marketplace reports no source</div><div class="dim">compare sources within a channel</div><div class="dim">Marketing</div><div class="orange">open, by design</div></div><div class="gr"><div class="">city and postal_code in the one big table, personal detail no consumer read</div><div class="dim">do not read them from this table</div><div class="dim">the data engineer</div><div class="dim">closed <span class="nw">2026-10-07</span></div></div><div class="gr"><div class="">the gold tasks were skipped on 6 days: <span class="nw">2026-08-12</span> to <span class="nw">2026-08-15</span> and <span class="nw">2026-08-18</span> after complete_feed failed, <span class="nw">2026-08-19</span> after silver_clean failed on orders</div><div class="dim">consumers read the gold of <span class="nw">2026-08-11</span> and <span class="nw">2026-08-17</span>; the changes loaded on <span class="nw">2026-08-16</span> and <span class="nw">2026-08-20</span></div><div class="dim">Data Platform</div><div class="dim">closed <span class="nw">2026-08-20</span></div></div><div class="gr"><div class="">a duplicate delivery of one order carried a delivered status 6 days before the shipment; unique_sequence quarantined it on <span class="nw">2026-08-08</span></div><div class="dim">the first copy stood; the changed copy is in ops/quarantine/</div><div class="dim">Data Platform</div><div class="dim">closed <span class="nw">2026-08-11</span></div></div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>No personal data</h3></div><div class="c">checked for release 1.1.0</div></div>
            <div class="gt " style="--cols:280px minmax(0,1fr) 330px"><div class="gh"><div>data</div><div>where it stays</div><div>since</div></div><div class="gr"><div class="col">first name, last name</div><div class="dim"><span class="mono">silver_core.customers</span></div><div class="dim">always</div></div><div class="gr"><div class="col">email address, year of birth</div><div class="dim"><span class="mono">silver_core.customers</span>, <span class="mono">silver_clean.contacts</span></div><div class="dim">always</div></div><div class="gr"><div class="col">city, postal code</div><div class="dim"><span class="mono">gold_marts.dim_customers</span>, for the regional analysis</div><div class="dim">removed from this table in 1.1.0</div></div><div class="gr"><div class="col">support messages</div><div class="dim"><span class="mono">silver_clean.messages</span></div><div class="dim">always</div></div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>Safe to sum</h3></div><div class="c">6 checks</div></div>
            <div class="gt " style="--cols:300px minmax(0,1fr) 360px"><div class="gh"><div>check</div><div>result</div><div>how it is checked</div></div><div class="gr"><div class="col">cancelled orders are out</div><div class="dim">0 cancelled lines</div><div class="dim">the table filters them; the contract counts them</div></div><div class="gr"><div class="col">one row per line</div><div class="dim">12,418,906 lines, 12,418,906 keys</div><div class="dim">the contract&#x27;s quality rule on line_id</div></div><div class="gr"><div class="col">money is exact</div><div class="dim">DECIMAL(18,2) in the contract; DOUBLE in the warehouse, a known issue</div><div class="dim">round every total to the cent</div></div><div class="gr"><div class="col">no double counting</div><div class="dim">one row per line, no join that multiplies</div><div class="dim">the joins are on the dimensions&#x27; keys</div></div><div class="gr"><div class="col">no VAT, shipping or refunds mixed in</div><div class="dim">net_eur is net revenue only</div><div class="dim">said in every amount&#x27;s description</div></div><div class="gr"><div class="col">the cost of the day</div><div class="dim">standard_cost_eur from the cost valid on ordered_on</div><div class="dim">an as-of join in core, never an aggregate</div></div></div></div><div class="pp" data-pp="releases"><div class="docline"><svg width="15" height="15" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M6 3h8l4 4v14H6z"/><path d="M14 3v4h4"/></svg><span>docs/data-products/obt_order_lines/release-notes.md · number-diff.md · deprecation.md</span><span class="by">written by /data-product · 2026-10-07</span></div>
            <div class="rcards"><div class="rcard"><div class="rv"><span class="mono">1.1.0</span><span class="dim">2026-10-07</span></div><div class="rl">No personal data in the table, and every column described in contract.yaml.</div><div class="ri"><span class="rk2">Removed</span><span>city and postal_code; personal detail the one big table does not need, read by no query of <span class="nw">2026-08</span>; they stay in <span class="mono">gold_marts.dim_customers</span></span></div><div class="ri"><span class="rk2">Changed</span><span>every column has a description, a sensitivity tag and, for a measure, an additivity tag in contract.yaml; <span class="nw">2026-08</span> is complete and final</span></div><div class="ri"><span class="rk2">Fixed</span><span>the description of net_eur said &quot;with shipping&quot;; it never included shipping. Thanks to Finance</span></div><div class="ri must"><span class="rk2">What you must do</span><span>a query that reads city or postal_code from this table fails from <span class="nw">2026-10-07</span>; join <span class="mono">gold_marts.dim_customers</span> on customer_id instead</span></div></div><div class="rcard"><div class="rv"><span class="mono">1.0.0</span><span class="dim">2026-08-01</span></div><div class="rl">The first release, built on the baseline of <span class="nw">2026-07-31</span>.</div><div class="ri"><span class="rk2">Added</span><span><span class="mono">gold_marts.obt_order_lines</span>, the star flattened, 25 columns: cancelled orders out, money in euros without VAT, the standard cost of the order day, the contract, the tour, the starter queries</span></div><div class="ri must"><span class="rk2">What you must do</span><span>nothing</span></div></div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>The number diff, 1.0.0 to 1.1.0</h3></div><div class="c">releases/1.1.0.json</div></div>
            <div class="gt " style="--cols:260px minmax(0,1fr) minmax(0,1fr) minmax(0,1fr)"><div class="gh"><div>number</div><div class=r>1.0.0 · 2026-08-01</div><div class=r>1.1.0 · 2026-10-07</div><div class=r>change</div></div><div class="gr"><div class="col">rows</div><div class="num dim r">12,187,491</div><div class="num r">12,418,906</div><div class="num r">+231,415 · +1.90 %</div></div><div class="gr"><div class="col">orders</div><div class="num dim r">5,044,178</div><div class="num r">5,141,206</div><div class="num r">+97,028 · +1.92 %</div></div><div class="gr"><div class="col">sum of net_eur</div><div class="num dim r">2,567,171,039.98</div><div class="num r">2,618,447,309.62</div><div class="num r">+51,276,269.64 · +2.00 %</div></div></div>
            <div class="bl"><div class="bi"><span class="nw">2026-08</span> is new: 231,418 lines and 97,030 orders, EUR 51,276,728.40 of net revenue, accepted by the gates and reconciled with the export on <span class="nw">2026-08-31</span>.</div><div class="bi"><span class="nw">2026-07</span> lost 2 orders and EUR 458.76: an order of <span class="nw">2026-07-30</span>, EUR 436.92, and an order of <span class="nw">2026-07-31</span>, EUR 21.84, were cancelled in <span class="nw">2026-08</span>.</div><div class="bi"><span class="nw">2026-05</span> and <span class="nw">2026-06</span> did not move, to the cent.</div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>The deprecation notice, as sent</h3></div><div class="c">2026-09-26 · 5 roles</div></div>
            <div class="card notice"><div class="k">to finance_analyst, marketing_analyst, commercial_analyst, data_scientist and monday_pack</div>
              <div class="subj">Subject: obt_order_lines loses city and postal_code on 2026-10-07</div>
              <p>From release 1.1.0 on 2026-10-07, <span class="mono">gold_marts.obt_order_lines</span> no longer carries city and postal_code. The one big table is read by 5 roles, and personal detail belongs where few people read it. None of the queries of 2026-08 read them. A query outside the log keeps working when it joins <span class="mono">gold_marts.dim_customers</span>, as below. Nothing else in the table changes.</p>
              <pre><span class="s-com">-- Before, until 1.0.0</span>
<span class="s-kw">SELECT</span> postal_code, <span class="s-fn">sum</span>(net_eur) <span class="s-kw">AS</span> net_revenue_eur
<span class="s-kw">FROM</span> gold_marts.obt_order_lines
<span class="s-kw">WHERE</span> order_month = <span class="s-str">&#x27;2026-08&#x27;</span>
<span class="s-kw">GROUP BY</span> postal_code;

<span class="s-com">-- After, from 1.1.0: the postal code comes from the customer dimension</span>
<span class="s-kw">SELECT</span> customers.postal_code, <span class="s-fn">sum</span>(lines.net_eur) <span class="s-kw">AS</span> net_revenue_eur
<span class="s-kw">FROM</span> gold_marts.obt_order_lines <span class="s-kw">AS</span> lines
<span class="s-kw">JOIN</span> gold_marts.dim_customers <span class="s-kw">AS</span> customers
  <span class="s-kw">ON</span> customers.customer_id = lines.customer_id
<span class="s-kw">WHERE</span> lines.order_month = <span class="s-str">&#x27;2026-08&#x27;</span>
<span class="s-kw">GROUP BY</span> customers.postal_code;</pre></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>What consumers reported</h3></div><div class="c">corrections.md</div></div>
            <div class="gt " style="--cols:140px 200px minmax(0,1fr) minmax(0,1fr)"><div class="gh"><div>day</div><div>from</div><div>what they said</div><div>what changed</div></div><div class="gr"><div class="mono dim nw">2026-10-05</div><div class="col">Operations</div><div class="dim">guest orders show the customer unknown, so 1 customer was counted too many</div><div class="dim">the tour says: leave out unknown when counting customers; query 9 does it</div></div><div class="gr"><div class="mono dim nw">2026-10-02</div><div class="col">Finance</div><div class="dim">a margin query joined the current standard cost to old sales</div><div class="dim">standard_cost_eur already holds the cost of the order day; query 4</div></div><div class="gr"><div class="mono dim nw">2026-10-01</div><div class="col">Commercial</div><div class="dim">adding up the orders of each category gave more orders than the month had</div><div class="dim">orders are counted, not added; 118,276 against 97,030 in <span class="nw">2026-08</span></div></div><div class="gr"><div class="mono dim nw">2026-09-29</div><div class="col">Finance</div><div class="dim">the description of net_eur said &quot;with shipping&quot;</div><div class="dim">fixed in 1.1.0: net revenue excludes shipping and refunds</div></div></div></div><div class="pp" data-pp="contract"><div class="docline"><svg width="15" height="15" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M6 3h8l4 4v14H6z"/><path d="M14 3v4h4"/></svg><span>docs/data-products/obt_order_lines/contract.yaml</span><span class="by">written by /data-product · 2026-10-07</span></div>
            <div class="cbar"><div class="seg"><span class="on" data-cv="r">Contract</span><span data-cv="y">contract.yaml</span></div><span class="note">ODCS 3.1.0</span></div>
            <div class="cv on" data-cvp="r">
              <div class="cfund"><div class="cf"><span class="k">id</span><span class="v"><span class="mono">newvolt-obt-order-lines</span></span></div><div class="cf"><span class="k">version</span><span class="v">1.1.0 · active</span></div><div class="cf"><span class="k">owner</span><span class="v">the data engineer</span></div><div class="cf"><span class="k">steward</span><span class="v">Finance</span></div><div class="cf"><span class="k">server</span><span class="v"><span class="mono">duckdb · gold_marts</span></span></div><div class="cf"><span class="k">built by</span><span class="v"><span class="mono">pipeline/gold/marts/obt_order_lines.sql</span></span></div></div>
              <div class="sech"><div class="t"><div class="accent"></div><h3>What it is for</h3></div><div class="c">description</div></div>
              <div class="crow"><span class="k">purpose</span><span>One row per order line of an order that was not cancelled, with its day, customer and product beside it. The table the Monday trading pack and the analysts sum.</span></div><div class="crow"><span class="k">usage</span><span>Sum the measures freely: cancelled orders are out, so a plain sum gives Finance&#x27;s trading number. Count orders and customers with count(DISTINCT ...), never by adding counts.</span></div><div class="crow"><span class="k">limitations</span><span>No refunds, no returns, no shipping fees: net_eur is net revenue only. Amounts exclude VAT. History starts on <span class="nw">2022-01-01</span>. Guest checkouts share the customer_id unknown.</span></div>
              <div class="sech"><div class="t"><div class="accent"></div><h3>Service levels</h3></div><div class="c">4 properties</div></div>
              <div class="gt " style="--cols:230px 120px minmax(0,1fr)"><div class="gh"><div>property</div><div>value</div><div>description</div></div><div class="gr"><div class="col"><span class="mono">frequency</span></div><div class="mono">1 d</div><div class="dim">Rebuilt by every run that succeeds. When the gold tasks are skipped, consumers read the gold of the last run that built it.</div></div><div class="gr"><div class="col"><span class="mono">latency</span></div><div class="mono">1 d</div><div class="dim">The data of day D is in the table by 07:00 UTC on D+1, when D&#x27;s delivery passed its gates.</div></div><div class="gr"><div class="col"><span class="mono">retention</span></div><div class="mono">all</div><div class="dim">Every order since <span class="nw">2022-01-01</span>. Nothing is rolled off.</div></div><div class="gr"><div class="col"><span class="mono">timeOfAvailability</span></div><div class="mono">07:00</div><div class="dim">UTC, for the Monday trading pack.</div></div></div>
              <div class="sech"><div class="t"><div class="accent"></div><h3>Quality rules</h3></div><div class="c">4 rules, each must be 0</div></div>
              <div class="gt " style="--cols:290px minmax(0,1fr) 110px"><div class="gh"><div>rule</div><div>query</div><div class=r>must be</div></div><div class="gr"><div class="col">One row per line.</div><div class=""><pre class="qsql"><span class="s-kw">SELECT</span> <span class="s-fn">count</span>(*) - <span class="s-fn">count</span>(<span class="s-kw">DISTINCT</span> line_id)
<span class="s-kw">FROM</span> gold_marts.obt_order_lines</pre></div><div class="num r">0</div></div><div class="gr"><div class="col">No line of a cancelled order.</div><div class=""><pre class="qsql"><span class="s-kw">SELECT</span> <span class="s-fn">count</span>(*)
<span class="s-kw">FROM</span> gold_marts.obt_order_lines
<span class="s-kw">JOIN</span> silver_core.orders <span class="s-kw">USING</span> (order_id)
<span class="s-kw">WHERE</span> is_cancelled</pre></div><div class="num r">0</div></div><div class="gr"><div class="col">The net revenue equals the fact&#x27;s, for orders that were not cancelled.</div><div class=""><pre class="qsql"><span class="s-kw">SELECT</span> <span class="s-fn">round</span>(<span class="s-fn">abs</span>(
  (<span class="s-kw">SELECT</span> <span class="s-fn">sum</span>(net_eur) <span class="s-kw">FROM</span> gold_marts.obt_order_lines)
  - (<span class="s-kw">SELECT</span> <span class="s-fn">sum</span>(net_eur) <span class="s-kw">FROM</span> gold_marts.fact_order_lines
     <span class="s-kw">WHERE</span> <span class="s-kw">NOT</span> is_cancelled)), <span class="s-num">2</span>)</pre></div><div class="num r">0</div></div><div class="gr"><div class="col">Every line has a cost from the day it was ordered.</div><div class=""><pre class="qsql"><span class="s-kw">SELECT</span> <span class="s-fn">count</span>(*)
<span class="s-kw">FROM</span> gold_marts.obt_order_lines
<span class="s-kw">WHERE</span> standard_cost_eur <span class="s-kw">IS</span> <span class="s-kw">NULL</span></pre></div><div class="num r">0</div></div></div>
              <div class="sech"><div class="t"><div class="accent"></div><h3>Schema</h3></div><div class="c">23 columns</div></div>
              <div class="gt schema" style="--cols:200px 150px 90px 200px minmax(0,1fr)"><div class="gh"><div>column</div><div>type</div><div>required</div><div>tags</div><div>description</div></div><div class="gr"><div class="col"><span class="mono">line_id</span> <span class="tg">PK</span></div><div class="dim"><span class="mono">VARCHAR</span></div><div class="dim">yes</div><div class=""><span class="tag internal">internal</span></div><div class="dim">The order line number, like SO372035-01. The key.</div></div><div class="gr"><div class="col"><span class="mono">order_id</span></div><div class="dim"><span class="mono">VARCHAR</span></div><div class="dim">yes</div><div class=""><span class="tag internal">internal</span></div><div class="dim">The order the line belongs to. Several lines share one order.</div></div><div class="gr"><div class="col"><span class="mono">ordered_on</span></div><div class="dim"><span class="mono">DATE</span></div><div class="dim">yes</div><div class=""><span class="tag public">public</span></div><div class="dim">The day the order was placed, the UTC day of the checkout.</div></div><div class="gr"><div class="col"><span class="mono">order_month</span></div><div class="dim"><span class="mono">VARCHAR</span></div><div class="dim">yes</div><div class=""><span class="tag public">public</span></div><div class="dim">The month the order was placed, like <span class="nw">2026-08</span>.</div></div><div class="gr"><div class="col"><span class="mono">order_year</span></div><div class="dim"><span class="mono">BIGINT</span></div><div class="dim">yes</div><div class=""><span class="tag public">public</span><span class="tag non_additive">non additive</span></div><div class="dim">The year the order was placed.</div></div><div class="gr"><div class="col"><span class="mono">customer_id</span></div><div class="dim"><span class="mono">VARCHAR</span></div><div class="dim">yes</div><div class=""><span class="tag internal">internal</span></div><div class="dim">The shop account that ordered, or unknown for a guest checkout. An account is not always one person.</div></div><div class="gr"><div class="col"><span class="mono">customer_type</span></div><div class="dim"><span class="mono">VARCHAR</span></div><div class="dim">yes</div><div class=""><span class="tag internal">internal</span></div><div class="dim">Finance&#x27;s customer type at placement: guest, new or returning. Set at checkout, never recalculated.</div></div><div class="gr"><div class="col"><span class="mono">home_country</span></div><div class="dim"><span class="mono">VARCHAR</span></div><div class="dim">no</div><div class=""><span class="tag internal">internal</span></div><div class="dim">The country of the customer&#x27;s account, as an <span class="nw">ISO 3166-1 alpha-2</span> code. Missing for a guest. Not where the order was sent.</div></div><div class="gr"><div class="col"><span class="mono">signup_channel</span></div><div class="dim"><span class="mono">VARCHAR</span></div><div class="dim">no</div><div class=""><span class="tag internal">internal</span></div><div class="dim">Where the account was created: web or app. Missing for a guest.</div></div><div class="gr"><div class="col"><span class="mono">is_business</span></div><div class="dim"><span class="mono">BOOLEAN</span></div><div class="dim">no</div><div class=""><span class="tag internal">internal</span></div><div class="dim">True when the account belongs to a business account. Missing for a guest.</div></div><div class="gr"><div class="col"><span class="mono">sku</span></div><div class="dim"><span class="mono">VARCHAR</span></div><div class="dim">yes</div><div class=""><span class="tag public">public</span></div><div class="dim">The product on the line, one physical variant.</div></div><div class="gr"><div class="col"><span class="mono">product_name</span></div><div class="dim"><span class="mono">VARCHAR</span></div><div class="dim">yes</div><div class=""><span class="tag public">public</span></div><div class="dim">The name of the product. It does not always say the colour.</div></div><div class="gr"><div class="col"><span class="mono">brand</span></div><div class="dim"><span class="mono">VARCHAR</span></div><div class="dim">yes</div><div class=""><span class="tag public">public</span></div><div class="dim">The brand: Kaivo, Kova, Nodo, Ondia, Pavo or Visna.</div></div><div class="gr"><div class="col"><span class="mono">category</span></div><div class="dim"><span class="mono">VARCHAR</span></div><div class="dim">yes</div><div class=""><span class="tag public">public</span></div><div class="dim">The category: Phones and Tablets, Computers, Monitors, Accessories or Audio.</div></div><div class="gr"><div class="col"><span class="mono">ship_country</span></div><div class="dim"><span class="mono">VARCHAR</span></div><div class="dim">yes</div><div class=""><span class="tag public">public</span></div><div class="dim">The country the order ships to, as an <span class="nw">ISO 3166-1 alpha-2</span> code. The market of the sale.</div></div><div class="gr"><div class="col"><span class="mono">channel</span></div><div class="dim"><span class="mono">VARCHAR</span></div><div class="dim">yes</div><div class=""><span class="tag public">public</span></div><div class="dim">Where the order was placed: web, app or marketplace.</div></div><div class="gr"><div class="col"><span class="mono">acquisition_source</span></div><div class="dim"><span class="mono">VARCHAR</span></div><div class="dim">no</div><div class=""><span class="tag internal">internal</span></div><div class="dim">The last touch that brought the checkout, as the shop recorded it. Always marketplace on a marketplace order.</div></div><div class="gr"><div class="col"><span class="mono">campaign_id</span></div><div class="dim"><span class="mono">VARCHAR</span></div><div class="dim">no</div><div class=""><span class="tag internal">internal</span></div><div class="dim">The campaign window the order fell in, if any. It does not prove an offer was used.</div></div><div class="gr"><div class="col"><span class="mono">quantity</span></div><div class="dim"><span class="mono">INTEGER</span></div><div class="dim">yes</div><div class=""><span class="tag internal">internal</span><span class="tag additive">additive</span></div><div class="dim">The ordered units on the line.</div></div><div class="gr"><div class="col"><span class="mono">gross_eur</span></div><div class="dim"><span class="mono">DECIMAL(18,2)</span></div><div class="dim">yes</div><div class=""><span class="tag internal">internal</span><span class="tag additive">additive</span></div><div class="dim">Quantity times list price, before any discount, in euros without VAT.</div></div><div class="gr"><div class="col"><span class="mono">discount_eur</span></div><div class="dim"><span class="mono">DECIMAL(18,2)</span></div><div class="dim">yes</div><div class=""><span class="tag internal">internal</span><span class="tag additive">additive</span></div><div class="dim">The whole discount on the line, in euros without VAT.</div></div><div class="gr"><div class="col"><span class="mono">net_eur</span></div><div class="dim"><span class="mono">DECIMAL(18,2)</span></div><div class="dim">yes</div><div class=""><span class="tag internal">internal</span><span class="tag additive">additive</span></div><div class="dim">What the line is worth after the discount, in euros without VAT. Net revenue: no shipping, no refunds.</div></div><div class="gr"><div class="col"><span class="mono">standard_cost_eur</span></div><div class="dim"><span class="mono">DECIMAL(18,2)</span></div><div class="dim">yes</div><div class=""><span class="tag internal">internal</span><span class="tag additive">additive</span></div><div class="dim">Quantity times the standard cost valid on the order day, in euros.</div></div></div>
            </div>
            <div class="cv" data-cvp="y"><div class="yaml"><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"><span class="ycm"># The data contract of gold_marts.obt_order_lines: what the consumers of the one big table can rely on.</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"><span class="ycm"># Format: the open standard ODCS, version 3.1.0, as the source contracts in contracts/. Written by the data-product skill,</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"><span class="ycm"># owned by the data engineer, the definitions signed by Finance. A change to a column is a new version and a release note.</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"><span class="yk">kind</span>: DataContract</span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"><span class="yk">apiVersion</span>: v3.1.0</span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"><span class="yk">id</span>: newvolt-obt-order-lines</span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"><span class="yk">name</span>: obt_order_lines</span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"><span class="yk">version</span>: <span class="yn">1.1.0</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"><span class="yk">status</span>: active</span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"><span class="yk">description</span>:</span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:6ch;text-indent:-4ch"><span class="yk">purpose</span>: <span class="yst">&quot;One row per order line of an order that was not cancelled, with its day, customer and product beside it. The table the Monday trading pack and the analysts sum.&quot;</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:6ch;text-indent:-4ch"><span class="yk">usage</span>: <span class="yst">&quot;Sum the measures freely: cancelled orders are out, so a plain sum gives Finance&#x27;s trading number. Count orders and customers with count(DISTINCT ...), never by adding counts.&quot;</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:6ch;text-indent:-4ch"><span class="yk">limitations</span>: <span class="yst">&quot;No refunds, no returns, no shipping fees: net_eur is net revenue only. Amounts exclude VAT. History starts on <span class="nw">2022-01-01</span>. Guest checkouts share the customer_id unknown.&quot;</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"><span class="yk">servers</span>:</span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:6ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">server</span>: newvolt, <span class="yk">type</span>: duckdb, <span class="yk">database</span>: data/warehouse/newvolt.duckdb, <span class="yk">schema</span>: gold_marts, <span class="yk">description</span>: <span class="yst">&quot;Open it read-only, between runs. See knowledge/connections.md.&quot;</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"><span class="yk">team</span>:</span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:6ch;text-indent:-4ch"><span class="yk">name</span>: data-platform</span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:6ch;text-indent:-4ch"><span class="yk">members</span>:</span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:8ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">username</span>: data-engineering, <span class="yk">name</span>: <span class="yst">&quot;the data engineer&quot;</span>, <span class="yk">role</span>: owner, <span class="yk">description</span>: <span class="yst">&quot;Builds the table, answers for the data.&quot;</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:8ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">username</span>: finance, <span class="yk">name</span>: Finance, <span class="yk">role</span>: steward, <span class="yk">description</span>: <span class="yst">&quot;Owns the definitions of the measures, signs them.&quot;</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"><span class="yk">slaProperties</span>:</span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:6ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">property</span>: frequency, <span class="yk">value</span>: <span class="yn">1</span>, <span class="yk">unit</span>: d, <span class="yk">description</span>: <span class="yst">&quot;Rebuilt by every run that succeeds. When the gold tasks are skipped, consumers read the gold of the last run that built it.&quot;</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:6ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">property</span>: latency, <span class="yk">value</span>: <span class="yn">1</span>, <span class="yk">unit</span>: d, <span class="yk">description</span>: <span class="yst">&quot;The data of day D is in the table by 07:00 UTC on D+1, when D&#x27;s delivery passed its gates.&quot;</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:6ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">property</span>: retention, <span class="yk">value</span>: all, <span class="yk">description</span>: <span class="yst">&quot;Every order since <span class="nw">2022-01-01</span>. Nothing is rolled off.&quot;</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:6ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">property</span>: timeOfAvailability, <span class="yk">value</span>: <span class="yst">&quot;07:00&quot;</span>, <span class="yk">description</span>: <span class="yst">&quot;UTC, for the Monday trading pack.&quot;</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"><span class="yk">customProperties</span>:</span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:6ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">property</span>: grain, <span class="yk">value</span>: <span class="yst">&quot;one order line of an order that was not cancelled&quot;</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:6ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">property</span>: builtBy, <span class="yk">value</span>: pipeline/gold/marts/obt_order_lines.sql<span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:6ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">property</span>: consumers, <span class="yk">value</span>: <span class="yst">&quot;monday_pack, finance analysts, commercial analysts, marketing analysts&quot;</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:6ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">property</span>: docs, <span class="yk">value</span>: docs/data-products/obt_order_lines/<span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:4ch;text-indent:-4ch"><span class="yk">schema</span>:</span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:6ch;text-indent:-4ch">- <span class="yk">name</span>: obt_order_lines</span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:8ch;text-indent:-4ch"><span class="yk">physicalName</span>: gold_marts.obt_order_lines</span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:8ch;text-indent:-4ch"><span class="yk">physicalType</span>: table</span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:8ch;text-indent:-4ch"><span class="yk">description</span>: <span class="yst">&quot;One row per order line of an order that was not cancelled, with the day, the customer and the product beside it.&quot;</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:8ch;text-indent:-4ch"><span class="yk">quality</span>:</span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">type</span>: sql, <span class="yk">description</span>: <span class="yst">&quot;One row per line.&quot;</span>, <span class="yk">query</span>: <span class="yst">&quot;SELECT count(*) - count(DISTINCT line_id) FROM gold_marts.obt_order_lines&quot;</span>, <span class="yk">mustBe</span>: <span class="yn">0</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">type</span>: sql, <span class="yk">description</span>: <span class="yst">&quot;No line of a cancelled order.&quot;</span>, <span class="yk">query</span>: <span class="yst">&quot;SELECT count(*) FROM gold_marts.obt_order_lines JOIN silver_core.orders USING (order_id) WHERE is_cancelled&quot;</span>, <span class="yk">mustBe</span>: <span class="yn">0</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">type</span>: sql, <span class="yk">description</span>: <span class="yst">&quot;The net revenue equals the fact&#x27;s, for orders that were not cancelled.&quot;</span>, <span class="yk">query</span>: <span class="yst">&quot;SELECT round(abs((SELECT sum(net_eur) FROM gold_marts.obt_order_lines) - (SELECT sum(net_eur) FROM gold_marts.fact_order_lines WHERE NOT is_cancelled)), 2)&quot;</span>, <span class="yk">mustBe</span>: <span class="yn">0</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">type</span>: sql, <span class="yk">description</span>: <span class="yst">&quot;Every line has a cost from the day it was ordered.&quot;</span>, <span class="yk">query</span>: <span class="yst">&quot;SELECT count(*) FROM gold_marts.obt_order_lines WHERE standard_cost_eur IS NULL&quot;</span>, <span class="yk">mustBe</span>: <span class="yn">0</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:8ch;text-indent:-4ch"><span class="yk">properties</span>:</span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: line_id, <span class="yk">logicalType</span>: string, <span class="yk">physicalType</span>: VARCHAR, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">primaryKey</span>: <span class="yb">true</span>, <span class="yk">primaryKeyPosition</span>: <span class="yn">1</span>, <span class="yk">description</span>: <span class="yst">&quot;The order line number, like SO372035-01. The key.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: internal<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: order_id, <span class="yk">logicalType</span>: string, <span class="yk">physicalType</span>: VARCHAR, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">&quot;The order the line belongs to. Several lines share one order.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: internal<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: ordered_on, <span class="yk">logicalType</span>: date, <span class="yk">physicalType</span>: DATE, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">&quot;The day the order was placed, the UTC day of the checkout.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: public<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: order_month, <span class="yk">logicalType</span>: string, <span class="yk">physicalType</span>: VARCHAR, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">&quot;The month the order was placed, like 2026-08.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: public<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: order_year, <span class="yk">logicalType</span>: integer, <span class="yk">physicalType</span>: BIGINT, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">&quot;The year the order was placed.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: public<span class="ybr">}</span>, <span class="ybr">{</span><span class="yk">property</span>: additivity, <span class="yk">value</span>: non_additive<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: customer_id, <span class="yk">logicalType</span>: string, <span class="yk">physicalType</span>: VARCHAR, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">&quot;The shop account that ordered, or unknown for a guest checkout. An account is not always one person.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: internal<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: customer_type, <span class="yk">logicalType</span>: string, <span class="yk">physicalType</span>: VARCHAR, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">&quot;Finance&#x27;s customer type at placement: guest, new or returning. Set at checkout, never recalculated.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: internal<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: home_country, <span class="yk">logicalType</span>: string, <span class="yk">physicalType</span>: VARCHAR, <span class="yk">required</span>: <span class="yb">false</span>, <span class="yk">description</span>: <span class="yst">&quot;The country of the customer&#x27;s account, as an ISO 3166-1 alpha-2 code. Missing for a guest. Not where the order was sent.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: internal<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: signup_channel, <span class="yk">logicalType</span>: string, <span class="yk">physicalType</span>: VARCHAR, <span class="yk">required</span>: <span class="yb">false</span>, <span class="yk">description</span>: <span class="yst">&quot;Where the account was created: web or app. Missing for a guest.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: internal<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: is_business, <span class="yk">logicalType</span>: boolean, <span class="yk">physicalType</span>: BOOLEAN, <span class="yk">required</span>: <span class="yb">false</span>, <span class="yk">description</span>: <span class="yst">&quot;True when the account belongs to a business account. Missing for a guest.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: internal<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: sku, <span class="yk">logicalType</span>: string, <span class="yk">physicalType</span>: VARCHAR, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">&quot;The product on the line, one physical variant.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: public<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: product_name, <span class="yk">logicalType</span>: string, <span class="yk">physicalType</span>: VARCHAR, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">&quot;The name of the product. It does not always say the colour.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: public<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: brand, <span class="yk">logicalType</span>: string, <span class="yk">physicalType</span>: VARCHAR, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">&quot;The brand: Kaivo, Kova, Nodo, Ondia, Pavo or Visna.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: public<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: category, <span class="yk">logicalType</span>: string, <span class="yk">physicalType</span>: VARCHAR, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">&quot;The category: Phones and Tablets, Computers, Monitors, Accessories or Audio.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: public<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: ship_country, <span class="yk">logicalType</span>: string, <span class="yk">physicalType</span>: VARCHAR, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">&quot;The country the order ships to, as an ISO 3166-1 alpha-2 code. The market of the sale.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: public<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: channel, <span class="yk">logicalType</span>: string, <span class="yk">physicalType</span>: VARCHAR, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">&quot;Where the order was placed: web, app or marketplace.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: public<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: acquisition_source, <span class="yk">logicalType</span>: string, <span class="yk">physicalType</span>: VARCHAR, <span class="yk">required</span>: <span class="yb">false</span>, <span class="yk">description</span>: <span class="yst">&quot;The last touch that brought the checkout, as the shop recorded it. Always marketplace on a marketplace order.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: internal<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: campaign_id, <span class="yk">logicalType</span>: string, <span class="yk">physicalType</span>: VARCHAR, <span class="yk">required</span>: <span class="yb">false</span>, <span class="yk">description</span>: <span class="yst">&quot;The campaign window the order fell in, if any. It does not prove an offer was used.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: internal<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: quantity, <span class="yk">logicalType</span>: integer, <span class="yk">physicalType</span>: INTEGER, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">&quot;The ordered units on the line.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: internal<span class="ybr">}</span>, <span class="ybr">{</span><span class="yk">property</span>: additivity, <span class="yk">value</span>: additive<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: gross_eur, <span class="yk">logicalType</span>: number, <span class="yk">physicalType</span>: <span class="yst">&quot;DECIMAL(18,2)&quot;</span>, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">&quot;Quantity times list price, before any discount, in euros without VAT.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: internal<span class="ybr">}</span>, <span class="ybr">{</span><span class="yk">property</span>: additivity, <span class="yk">value</span>: additive<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: discount_eur, <span class="yk">logicalType</span>: number, <span class="yk">physicalType</span>: <span class="yst">&quot;DECIMAL(18,2)&quot;</span>, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">&quot;The whole discount on the line, in euros without VAT.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: internal<span class="ybr">}</span>, <span class="ybr">{</span><span class="yk">property</span>: additivity, <span class="yk">value</span>: additive<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: net_eur, <span class="yk">logicalType</span>: number, <span class="yk">physicalType</span>: <span class="yst">&quot;DECIMAL(18,2)&quot;</span>, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">&quot;What the line is worth after the discount, in euros without VAT. Net revenue: no shipping, no refunds.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: internal<span class="ybr">}</span>, <span class="ybr">{</span><span class="yk">property</span>: additivity, <span class="yk">value</span>: additive<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div><div class="yl"><span class="ln"></span><span class="yc" style="padding-left:10ch;text-indent:-4ch">- <span class="ybr">{</span><span class="yk">name</span>: standard_cost_eur, <span class="yk">logicalType</span>: number, <span class="yk">physicalType</span>: <span class="yst">&quot;DECIMAL(18,2)&quot;</span>, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">&quot;Quantity times the standard cost valid on the order day, in euros.&quot;</span>, <span class="yk">customProperties</span>: <span class="ybr">[</span><span class="ybr">{</span><span class="yk">property</span>: sensitivity, <span class="yk">value</span>: internal<span class="ybr">}</span>, <span class="ybr">{</span><span class="yk">property</span>: additivity, <span class="yk">value</span>: additive<span class="ybr">}</span><span class="ybr">]</span><span class="ybr">}</span></span></div></div><div class="ybar">YAML · ODCS 3.1.0 · 70 lines · read only</div></div></div></div>
          </div>
          <div class="pside">
            <div class="kv"><span class="lbl">tables</span><span class="v">5</span></div>
            <div class="kv"><span class="lbl">size</span><span class="v">1.6 GB</span></div>
            <div class="kv"><span class="lbl">queries · 2026-08</span><span class="v">2,480</span></div>
            <div class="kv"><span class="lbl">last update</span><span class="v">2026-09-01 05:42</span></div>
            <div class="kv chipsrow"><span class="lbl">read by</span><span class="chips"><span class="chip fin">Finance</span><span class="chip sales">Commercial</span><span class="chip mkt">Marketing</span><span class="chip mfg">Data science</span></span></div>
            <div class="sidesep"></div>
            <div class="oitem"><div class="av">FI</div><div><div class="v ov">Finance</div><div class="k ok">steward, signs the definitions</div></div></div>
            <div class="oitem"><div class="av">DP</div><div><div class="v ov">Data Platform</div><div class="k ok">head of data platform, signs off a release</div></div></div>
            <div class="oitem"><div class="av">DE</div><div><div class="v ov">Data engineering</div><div class="k ok">the data engineer, owner</div></div></div>
            <div class="sidesep"></div>
            <button class="btn conn">Copy the read-only connection</button><pre class="conncode" hidden>duckdb.connect(<span class="s-str">&quot;data/warehouse/newvolt.duckdb&quot;</span>,
    read_only=<span class="s-num">True</span>)</pre>
          </div>
        </div>
      </section><section class="view pview" id="vProduct-customers" data-slug="customers">
        <div class="psplit">
          <div class="pleft">
            <div class="crumbs"><a data-go="market">Data Products</a><span class="sep">/</span><b>Customers</b></div>
            <div class="phead"><div class="glyph"><svg width="30" height="30" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><circle cx="12" cy="8" r="4"/><path d="M4 20c1.8-3.4 4.6-5 8-5s6.2 1.6 8 5"/></svg></div><h1>Customers</h1><span class="exp">no data contract</span></div>
            <div class="pdesc">one row per shop account, the channel it signed up on and its country; guests as unknown</div>
            <div class="tabs ptabs"><div class="tab ptab on" data-pt="overview">Overview</div><div class="tab ptab off" data-pt="guide">Guide</div><div class="tab ptab" data-pt="model">Data model</div><div class="tab ptab off" data-pt="metrics">Metrics</div><div class="tab ptab off" data-pt="queries">Queries</div><div class="tab ptab off" data-pt="quality">Quality</div><div class="tab ptab off" data-pt="releases">Releases</div><div class="tab ptab off" data-pt="contract">Contract</div></div>
            <div class="pscroll"><div class="pp on" data-pp="overview">
            <div class="sech"><div class="t"><div class="accent"></div><h3>Tables</h3></div><div class="c">3 tables · gold_marts</div></div>
            <div class="trow h"><div>table</div><div>kind</div><div>rows</div><div>size</div><div>last update</div><div></div></div>
            <div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>dim_customers</div><div class="zone">dimension</div><div class="num">1,842,310</div><div class="num">48 MB</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div><div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>dim_countries</div><div class="zone">dimension</div><div class="num">27</div><div class="num">1 MB</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div><div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>dim_channels</div><div class="zone">dimension</div><div class="num">3</div><div class="num">1 MB</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>Read by</h3></div><div class="c">2 roles in ops/query_logs.csv</div></div>
            <div class="rrow"><div class="rr mono">marketing_analyst</div><div class="rp">Marketing</div><div class="rw">new, returning and guest customers</div></div><div class="rrow"><div class="rr mono">data_scientist</div><div class="rp">Data Science</div><div class="rw">customer features, read-only</div></div></div><div class="pp" data-pp="model"><div class="docline"><svg width="15" height="15" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M6 3h8l4 4v14H6z"/><path d="M14 3v4h4"/></svg><span>read from the warehouse and the SQL headers</span></div>
            <div class="star" style="height:540px"><svg width="1180" height="540" viewBox="0 0 1180 540"><path class="sl join" d="M445 78 H290"/><circle cx="445" cy="78" r="4"/><circle cx="290" cy="78" r="4"/><path class="sl join" d="M735 78 H890"/><circle cx="735" cy="78" r="4"/><circle cx="890" cy="78" r="4"/><path class="sl join" d="M590 286 V202"/><circle cx="590" cy="286" r="4"/><circle cx="590" cy="202" r="4"/><path class="sl join" d="M955 286 V244 H670 V202"/><circle cx="955" cy="286" r="4"/><circle cx="670" cy="202" r="4"/></svg><div class="sbox k-dimension" style="left:0px;top:0px;width:290px;height:180px"><div class="sk">DIMENSION</div><div class="sn">dim_countries</div><div class="sc"><span class="cn key">country_code</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">name</span></div><div class="sc"><span class="cn dim">region</span></div><div class="sc"><span class="cn dim">currency</span></div></div><div class="sbox k-dimension" style="left:445px;top:0px;width:290px;height:202px"><div class="sk">DIMENSION</div><div class="sn">dim_customers</div><div class="sc"><span class="cn key">customer_id</span><span class="tg">PK</span></div><div class="sc"><span class="cn">home_country</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">signup_channel</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn dim">is_business</span></div><div class="more">+ 6 columns</div></div><div class="sbox k-dimension" style="left:890px;top:0px;width:290px;height:134px"><div class="sk">DIMENSION</div><div class="sn">dim_channels</div><div class="sc"><span class="cn key">channel</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">name</span></div></div><div class="sbox k-fact other" style="left:445px;top:286px;width:290px;height:248px"><div class="sk">FACT · TRADING</div><div class="sn">fact_order_lines</div><div class="sc"><span class="cn key">line_id</span><span class="tg">PK</span></div><div class="sc"><span class="cn">date_key</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">customer_id</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">sku</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn dim">is_cancelled</span></div><div class="sc"><span class="cn dim">net_eur</span></div><div class="more">+ 12 columns</div></div><div class="sbox k-fact other" style="left:890px;top:286px;width:290px;height:248px"><div class="sk">FACT · TRADING</div><div class="sn">fact_orders</div><div class="sc"><span class="cn key">order_id</span><span class="tg">PK</span></div><div class="sc"><span class="cn">date_key</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">customer_id</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">campaign_id</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn dim">is_cancelled</span></div><div class="sc"><span class="cn dim">net_eur</span></div><div class="more">+ 4 columns</div></div><div class="slab" style="left:368px;top:78px">home_country</div><div class="slab" style="left:812px;top:78px">signup_channel</div><div class="slab" style="left:590px;top:244px">customer_id</div><div class="slab" style="left:812px;top:244px">customer_id</div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>One row is</h3></div><div class="c">3 tables</div></div>
            <div class="gt " style="--cols:290px minmax(0,1fr) 200px 320px"><div class="gh"><div>table</div><div>one row is</div><div>key</div><div>joins on</div></div><div class="gr"><div class="col"><span class="mono">dim_customers</span></div><div class="dim">a shop account, with unknown for guests</div><div class=""><span class="mono">customer_id</span></div><div class="dim">home_country, signup_channel</div></div><div class="gr"><div class="col"><span class="mono">dim_countries</span></div><div class="dim">a country, <span class="nw">ISO 3166-1 alpha-2</span></div><div class=""><span class="mono">country_code</span></div><div class="dim"></div></div><div class="gr"><div class="col"><span class="mono">dim_channels</span></div><div class="dim">a sales channel: web, app or marketplace</div><div class=""><span class="mono">channel</span></div><div class="dim"></div></div></div>
            </div></div>
          </div>
          <div class="pside">
            <div class="kv"><span class="lbl">tables</span><span class="v">3</span></div>
            <div class="kv"><span class="lbl">size</span><span class="v">50 MB</span></div>
            <div class="kv"><span class="lbl">queries · 2026-08</span><span class="v">331</span></div>
            <div class="kv"><span class="lbl">last update</span><span class="v">2026-09-01 05:42</span></div>
            <div class="kv chipsrow"><span class="lbl">read by</span><span class="chips"><span class="chip mkt">Marketing</span><span class="chip mfg">Data science</span></span></div>
            <div class="sidesep"></div>
            <div class="oitem"><div class="av">AM</div><div><div class="v ov">Marketing</div><div class="k ok">head of marketing</div></div></div>
            <div class="oitem"><div class="av">DP</div><div><div class="v ov">Data Platform</div><div class="k ok">head of data platform, signs off a release</div></div></div>
            <div class="oitem"><div class="av">DE</div><div><div class="v ov">Data engineering</div><div class="k ok">the data engineer, owner</div></div></div>
            <div class="sidesep"></div>
            <button class="btn conn">Copy the read-only connection</button><pre class="conncode" hidden>duckdb.connect(<span class="s-str">&quot;data/warehouse/newvolt.duckdb&quot;</span>,
    read_only=<span class="s-num">True</span>)</pre>
          </div>
        </div>
      </section><section class="view pview" id="vProduct-products" data-slug="products">
        <div class="psplit">
          <div class="pleft">
            <div class="crumbs"><a data-go="market">Data Products</a><span class="sep">/</span><b>Products</b></div>
            <div class="phead"><div class="glyph"><svg width="30" height="30" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M3 7l9-4 9 4-9 4-9-4z"/><path d="M3 7v10l9 4 9-4V7"/><path d="M12 11v10"/></svg></div><h1>Products</h1><span class="exp">no data contract</span></div>
            <div class="pdesc">one row per SKU with brand, category and family, and the margin by product family</div>
            <div class="tabs ptabs"><div class="tab ptab on" data-pt="overview">Overview</div><div class="tab ptab off" data-pt="guide">Guide</div><div class="tab ptab" data-pt="model">Data model</div><div class="tab ptab off" data-pt="metrics">Metrics</div><div class="tab ptab off" data-pt="queries">Queries</div><div class="tab ptab off" data-pt="quality">Quality</div><div class="tab ptab off" data-pt="releases">Releases</div><div class="tab ptab off" data-pt="contract">Contract</div></div>
            <div class="pscroll"><div class="pp on" data-pp="overview">
            <div class="sech"><div class="t"><div class="accent"></div><h3>Tables</h3></div><div class="c">2 tables · gold_marts</div></div>
            <div class="trow h"><div>table</div><div>kind</div><div>rows</div><div>size</div><div>last update</div><div></div></div>
            <div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>dim_products</div><div class="zone">dimension</div><div class="num">9,214</div><div class="num">2 MB</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div><div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>rpt_margin_by_family</div><div class="zone">report table</div><div class="num">2,304</div><div class="num">1 MB</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>Read by</h3></div><div class="c">2 roles in ops/query_logs.csv</div></div>
            <div class="rrow"><div class="rr mono">commercial_analyst</div><div class="rp">Commercial</div><div class="rw">launch reviews, brands and categories</div></div><div class="rrow"><div class="rr mono">finance_analyst</div><div class="rp">Finance</div><div class="rw">margin by product family</div></div></div><div class="pp" data-pp="model"><div class="docline"><svg width="15" height="15" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M6 3h8l4 4v14H6z"/><path d="M14 3v4h4"/></svg><span>read from the warehouse and the SQL headers</span></div>
            <div class="star" style="height:540px"><svg width="1180" height="540" viewBox="0 0 1180 540"><path class="sl join" d="M225 286 V244 H510 V202"/><circle cx="225" cy="286" r="4"/><circle cx="510" cy="202" r="4"/><path class="sl built" d="M590 202 V286"/><circle cx="590" cy="202" r="4"/><circle cx="590" cy="286" r="4"/><path class="sl join" d="M955 286 V244 H670 V202"/><circle cx="955" cy="286" r="4"/><circle cx="670" cy="202" r="4"/></svg><div class="sbox k-dimension" style="left:445px;top:0px;width:290px;height:202px"><div class="sk">DIMENSION</div><div class="sn">dim_products</div><div class="sc"><span class="cn key">sku</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">product_name</span></div><div class="sc"><span class="cn dim">brand</span></div><div class="sc"><span class="cn dim">category</span></div><div class="more">+ 8 columns</div></div><div class="sbox k-fact other" style="left:0px;top:286px;width:290px;height:248px"><div class="sk">FACT · TRADING</div><div class="sn">fact_order_lines</div><div class="sc"><span class="cn key">line_id</span><span class="tg">PK</span></div><div class="sc"><span class="cn">date_key</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">customer_id</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">sku</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn dim">is_cancelled</span></div><div class="sc"><span class="cn dim">net_eur</span></div><div class="more">+ 12 columns</div></div><div class="sbox k-report" style="left:445px;top:286px;width:290px;height:202px"><div class="sk">REPORT TABLE</div><div class="sn">rpt_margin_by_family</div><div class="sc"><span class="cn key">month</span><span class="tg">PK</span></div><div class="sc"><span class="cn key">family_id</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">net_eur</span></div><div class="sc"><span class="cn dim">margin_eur</span></div><div class="more">+ 3 columns</div></div><div class="sbox k-fact other" style="left:890px;top:286px;width:290px;height:202px"><div class="sk">FACT · STOCK AND PURCHASING</div><div class="sn">fact_stock_daily</div><div class="sc"><span class="cn key">date_key</span><span class="tg">PK</span></div><div class="sc"><span class="cn key">sku</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">on_hand</span></div><div class="sc"><span class="cn dim">days_of_cover</span></div><div class="more">+ 1 column</div></div><div class="slab" style="left:368px;top:244px">sku</div><div class="slab" style="left:590px;top:244px">built from</div><div class="slab" style="left:812px;top:244px">sku</div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>One row is</h3></div><div class="c">2 tables</div></div>
            <div class="gt " style="--cols:290px minmax(0,1fr) 200px 320px"><div class="gh"><div>table</div><div>one row is</div><div>key</div><div>joins on</div></div><div class="gr"><div class="col"><span class="mono">dim_products</span></div><div class="dim">a product variant, one SKU</div><div class=""><span class="mono">sku</span></div><div class="dim">supplier_id</div></div><div class="gr"><div class="col"><span class="mono">rpt_margin_by_family</span></div><div class="dim">a month and a product family</div><div class=""><span class="mono">month, family_id</span></div><div class="dim">built from fact_order_lines and dim_products</div></div></div>
            </div></div>
          </div>
          <div class="pside">
            <div class="kv"><span class="lbl">tables</span><span class="v">2</span></div>
            <div class="kv"><span class="lbl">size</span><span class="v">3 MB</span></div>
            <div class="kv"><span class="lbl">queries · 2026-08</span><span class="v">381</span></div>
            <div class="kv"><span class="lbl">last update</span><span class="v">2026-09-01 05:42</span></div>
            <div class="kv chipsrow"><span class="lbl">read by</span><span class="chips"><span class="chip sales">Commercial</span><span class="chip fin">Finance</span></span></div>
            <div class="sidesep"></div>
            <div class="oitem"><div class="av">CO</div><div><div class="v ov">Commercial</div><div class="k ok">head of commercial</div></div></div>
            <div class="oitem"><div class="av">DP</div><div><div class="v ov">Data Platform</div><div class="k ok">head of data platform, signs off a release</div></div></div>
            <div class="oitem"><div class="av">DE</div><div><div class="v ov">Data engineering</div><div class="k ok">the data engineer, owner</div></div></div>
            <div class="sidesep"></div>
            <button class="btn conn">Copy the read-only connection</button><pre class="conncode" hidden>duckdb.connect(<span class="s-str">&quot;data/warehouse/newvolt.duckdb&quot;</span>,
    read_only=<span class="s-num">True</span>)</pre>
          </div>
        </div>
      </section><section class="view pview" id="vProduct-delivery" data-slug="delivery">
        <div class="psplit">
          <div class="pleft">
            <div class="crumbs"><a data-go="market">Data Products</a><span class="sep">/</span><b>Delivery</b></div>
            <div class="phead"><div class="glyph"><svg width="30" height="30" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="7" width="13" height="9" rx="2"/><path d="M16 10h3l2 3v3h-5M7 19a2 2 0 1 0 0-4 2 2 0 0 0 0 4zM17 19a2 2 0 1 0 0-4 2 2 0 0 0 0 4z"/></svg></div><h1>Delivery</h1><span class="exp">no data contract</span></div>
            <div class="pdesc">one row per shipment with the carrier, the promise and the delivery day, and the daily SLA</div>
            <div class="tabs ptabs"><div class="tab ptab on" data-pt="overview">Overview</div><div class="tab ptab off" data-pt="guide">Guide</div><div class="tab ptab" data-pt="model">Data model</div><div class="tab ptab off" data-pt="metrics">Metrics</div><div class="tab ptab off" data-pt="queries">Queries</div><div class="tab ptab off" data-pt="quality">Quality</div><div class="tab ptab off" data-pt="releases">Releases</div><div class="tab ptab off" data-pt="contract">Contract</div></div>
            <div class="pscroll"><div class="pp on" data-pp="overview">
            <div class="sech"><div class="t"><div class="accent"></div><h3>Tables</h3></div><div class="c">4 tables · gold_marts</div></div>
            <div class="trow h"><div>table</div><div>kind</div><div>rows</div><div>size</div><div>last update</div><div></div></div>
            <div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>fact_shipments</div><div class="zone">fact</div><div class="num">5,012,884</div><div class="num">160 MB</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div><div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>dim_carriers</div><div class="zone">dimension</div><div class="num">6</div><div class="num">1 MB</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div><div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>rpt_delivery_sla</div><div class="zone">report table</div><div class="num">8,766</div><div class="num">1 MB</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div><div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>metric_service</div><div class="zone">metric</div><div class="num">1,461</div><div class="num">view</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>Read by</h3></div><div class="c">1 role in ops/query_logs.csv</div></div>
            <div class="rrow"><div class="rr mono">operations_analyst</div><div class="rp">Operations</div><div class="rw">shipments against promises, by carrier</div></div></div><div class="pp" data-pp="model"><div class="docline"><svg width="15" height="15" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M6 3h8l4 4v14H6z"/><path d="M14 3v4h4"/></svg><span>read from the warehouse and the SQL headers</span></div>
            <div class="star" style="height:803px"><svg width="1180" height="803" viewBox="0 0 1180 803"><path class="sl join" d="M590 286 V202"/><circle cx="590" cy="286" r="4"/><circle cx="590" cy="202" r="4"/><path class="sl join" d="M445 364 H290"/><circle cx="445" cy="364" r="4"/><circle cx="290" cy="364" r="4"/><path class="sl join" d="M735 364 H890"/><circle cx="735" cy="364" r="4"/><circle cx="890" cy="364" r="4"/><path class="sl built" d="M590 511 V595"/><circle cx="590" cy="511" r="4"/><circle cx="590" cy="595" r="4"/><path class="sl built" d="M670 511 V553 H955 V595"/><circle cx="670" cy="511" r="4"/><circle cx="955" cy="595" r="4"/></svg><div class="sbox k-dimension other" style="left:445px;top:0px;width:290px;height:202px"><div class="sk">DIMENSION · TRADING</div><div class="sn">dim_date</div><div class="sc"><span class="cn key">date_key</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">calendar_date</span></div><div class="sc"><span class="cn dim">year_month</span></div><div class="sc"><span class="cn dim">day_name</span></div><div class="more">+ 9 columns</div></div><div class="sbox k-dimension other" style="left:0px;top:286px;width:290px;height:180px"><div class="sk">DIMENSION · CUSTOMERS</div><div class="sn">dim_countries</div><div class="sc"><span class="cn key">country_code</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">name</span></div><div class="sc"><span class="cn dim">region</span></div><div class="sc"><span class="cn dim">currency</span></div></div><div class="sbox k-fact" style="left:445px;top:286px;width:290px;height:225px"><div class="sk">FACT</div><div class="sn">fact_shipments</div><div class="sc"><span class="cn key">shipment_id</span><span class="tg">PK</span></div><div class="sc"><span class="cn">date_key</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">carrier</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">ship_country</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn dim">on_time</span></div><div class="more">+ 3 columns</div></div><div class="sbox k-dimension" style="left:890px;top:286px;width:290px;height:157px"><div class="sk">DIMENSION</div><div class="sn">dim_carriers</div><div class="sc"><span class="cn key">carrier</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">name</span></div><div class="sc"><span class="cn dim">country</span></div></div><div class="sbox k-report" style="left:445px;top:595px;width:290px;height:202px"><div class="sk">REPORT TABLE</div><div class="sn">rpt_delivery_sla</div><div class="sc"><span class="cn key">day</span><span class="tg">PK</span></div><div class="sc"><span class="cn key">carrier</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">shipments</span></div><div class="sc"><span class="cn dim">on_time_pct</span></div><div class="more">+ 3 columns</div></div><div class="sbox k-metric" style="left:890px;top:595px;width:290px;height:202px"><div class="sk">METRIC</div><div class="sn">metric_service</div><div class="sc"><span class="cn key">day</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">shipments</span></div><div class="sc"><span class="cn dim">on_time_pct</span></div><div class="sc"><span class="cn dim">returns</span></div><div class="more">+ 3 columns</div></div><div class="slab" style="left:590px;top:244px">date_key</div><div class="slab" style="left:368px;top:364px">ship_country</div><div class="slab" style="left:812px;top:364px">carrier</div><div class="slab" style="left:590px;top:553px">built from</div><div class="slab" style="left:812px;top:553px">built from</div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>One row is</h3></div><div class="c">4 tables</div></div>
            <div class="gt " style="--cols:290px minmax(0,1fr) 200px 320px"><div class="gh"><div>table</div><div>one row is</div><div>key</div><div>joins on</div></div><div class="gr"><div class="col"><span class="mono">fact_shipments</span></div><div class="dim">a shipment of an order</div><div class=""><span class="mono">shipment_id</span></div><div class="dim">order_id, date_key, carrier, ship_country</div></div><div class="gr"><div class="col"><span class="mono">dim_carriers</span></div><div class="dim">a carrier</div><div class=""><span class="mono">carrier</span></div><div class="dim"></div></div><div class="gr"><div class="col"><span class="mono">rpt_delivery_sla</span></div><div class="dim">a day and a carrier</div><div class=""><span class="mono">day, carrier</span></div><div class="dim">built from fact_shipments</div></div><div class="gr"><div class="col"><span class="mono">metric_service</span></div><div class="dim">a day</div><div class=""><span class="mono">day</span></div><div class="dim">built from fact_shipments, fact_returns and the tickets</div></div></div>
            </div></div>
          </div>
          <div class="pside">
            <div class="kv"><span class="lbl">tables</span><span class="v">4</span></div>
            <div class="kv"><span class="lbl">size</span><span class="v">162 MB</span></div>
            <div class="kv"><span class="lbl">queries · 2026-08</span><span class="v">338</span></div>
            <div class="kv"><span class="lbl">last update</span><span class="v">2026-09-01 05:42</span></div>
            <div class="kv chipsrow"><span class="lbl">read by</span><span class="chips"><span class="chip log">Operations</span></span></div>
            <div class="sidesep"></div>
            <div class="oitem"><div class="av">PL</div><div><div class="v ov">Purchasing and Logistics</div><div class="k ok">head of purchasing and logistics</div></div></div>
            <div class="oitem"><div class="av">DP</div><div><div class="v ov">Data Platform</div><div class="k ok">head of data platform, signs off a release</div></div></div>
            <div class="oitem"><div class="av">DE</div><div><div class="v ov">Data engineering</div><div class="k ok">the data engineer, owner</div></div></div>
            <div class="sidesep"></div>
            <button class="btn conn">Copy the read-only connection</button><pre class="conncode" hidden>duckdb.connect(<span class="s-str">&quot;data/warehouse/newvolt.duckdb&quot;</span>,
    read_only=<span class="s-num">True</span>)</pre>
          </div>
        </div>
      </section><section class="view pview" id="vProduct-returns" data-slug="returns">
        <div class="psplit">
          <div class="pleft">
            <div class="crumbs"><a data-go="market">Data Products</a><span class="sep">/</span><b>Returns</b></div>
            <div class="phead"><div class="glyph"><svg width="30" height="30" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M4 15l4-8 4 6 3-4 5 8"/><path d="M3 20h18"/></svg></div><h1>Returns</h1><span class="exp">no data contract</span></div>
            <div class="pdesc">one row per returned line with the reason and the refund, and the returns by month and reason</div>
            <div class="tabs ptabs"><div class="tab ptab on" data-pt="overview">Overview</div><div class="tab ptab off" data-pt="guide">Guide</div><div class="tab ptab" data-pt="model">Data model</div><div class="tab ptab off" data-pt="metrics">Metrics</div><div class="tab ptab off" data-pt="queries">Queries</div><div class="tab ptab off" data-pt="quality">Quality</div><div class="tab ptab off" data-pt="releases">Releases</div><div class="tab ptab off" data-pt="contract">Contract</div></div>
            <div class="pscroll"><div class="pp on" data-pp="overview">
            <div class="sech"><div class="t"><div class="accent"></div><h3>Tables</h3></div><div class="c">3 tables · gold_marts</div></div>
            <div class="trow h"><div>table</div><div>kind</div><div>rows</div><div>size</div><div>last update</div><div></div></div>
            <div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>fact_returns</div><div class="zone">fact</div><div class="num">402,118</div><div class="num">14 MB</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div><div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>dim_return_reasons</div><div class="zone">dimension</div><div class="num">14</div><div class="num">1 MB</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div><div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>rpt_returns_by_reason</div><div class="zone">report table</div><div class="num">672</div><div class="num">1 MB</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>Read by</h3></div><div class="c">2 roles in ops/query_logs.csv</div></div>
            <div class="rrow"><div class="rr mono">operations_analyst</div><div class="rp">Operations</div><div class="rw">returns and their reasons</div></div><div class="rrow"><div class="rr mono">finance_analyst</div><div class="rp">Finance</div><div class="rw">refunds by month</div></div></div><div class="pp" data-pp="model"><div class="docline"><svg width="15" height="15" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M6 3h8l4 4v14H6z"/><path d="M14 3v4h4"/></svg><span>read from the warehouse and the SQL headers</span></div>
            <div class="star" style="height:872px"><svg width="1180" height="872" viewBox="0 0 1180 872"><path class="sl join" d="M590 286 V202"/><circle cx="590" cy="286" r="4"/><circle cx="590" cy="202" r="4"/><path class="sl join" d="M445 364 H290"/><circle cx="445" cy="364" r="4"/><circle cx="290" cy="364" r="4"/><path class="sl join" d="M735 364 H890"/><circle cx="735" cy="364" r="4"/><circle cx="890" cy="364" r="4"/><path class="sl built" d="M590 534 V618"/><circle cx="590" cy="534" r="4"/><circle cx="590" cy="618" r="4"/><path class="sl join" d="M510 534 V576 H225 V618"/><circle cx="510" cy="534" r="4"/><circle cx="225" cy="618" r="4"/></svg><div class="sbox k-dimension other" style="left:445px;top:0px;width:290px;height:202px"><div class="sk">DIMENSION · TRADING</div><div class="sn">dim_date</div><div class="sc"><span class="cn key">date_key</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">calendar_date</span></div><div class="sc"><span class="cn dim">year_month</span></div><div class="sc"><span class="cn dim">day_name</span></div><div class="more">+ 9 columns</div></div><div class="sbox k-dimension other" style="left:0px;top:286px;width:290px;height:202px"><div class="sk">DIMENSION · PRODUCTS</div><div class="sn">dim_products</div><div class="sc"><span class="cn key">sku</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">product_name</span></div><div class="sc"><span class="cn dim">brand</span></div><div class="sc"><span class="cn dim">category</span></div><div class="more">+ 8 columns</div></div><div class="sbox k-fact" style="left:445px;top:286px;width:290px;height:248px"><div class="sk">FACT</div><div class="sn">fact_returns</div><div class="sc"><span class="cn key">return_id</span><span class="tg">PK</span></div><div class="sc"><span class="cn">line_id</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">date_key</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">reason_code</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">sku</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn dim">refund_eur</span></div><div class="more">+ 2 columns</div></div><div class="sbox k-dimension" style="left:890px;top:286px;width:290px;height:157px"><div class="sk">DIMENSION</div><div class="sn">dim_return_reasons</div><div class="sc"><span class="cn key">reason_code</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">reason</span></div><div class="sc"><span class="cn dim">reason_group</span></div></div><div class="sbox k-fact other" style="left:0px;top:618px;width:290px;height:248px"><div class="sk">FACT · TRADING</div><div class="sn">fact_order_lines</div><div class="sc"><span class="cn key">line_id</span><span class="tg">PK</span></div><div class="sc"><span class="cn">date_key</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">customer_id</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">sku</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn dim">is_cancelled</span></div><div class="sc"><span class="cn dim">net_eur</span></div><div class="more">+ 12 columns</div></div><div class="sbox k-report" style="left:445px;top:618px;width:290px;height:202px"><div class="sk">REPORT TABLE</div><div class="sn">rpt_returns_by_reason</div><div class="sc"><span class="cn key">month</span><span class="tg">PK</span></div><div class="sc"><span class="cn key">reason_code</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">returns</span></div><div class="sc"><span class="cn dim">refund_eur</span></div><div class="more">+ 2 columns</div></div><div class="slab" style="left:590px;top:244px">date_key</div><div class="slab" style="left:368px;top:364px">sku</div><div class="slab" style="left:812px;top:364px">reason_code</div><div class="slab" style="left:590px;top:576px">built from</div><div class="slab" style="left:368px;top:576px">line_id</div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>One row is</h3></div><div class="c">3 tables</div></div>
            <div class="gt " style="--cols:290px minmax(0,1fr) 200px 320px"><div class="gh"><div>table</div><div>one row is</div><div>key</div><div>joins on</div></div><div class="gr"><div class="col"><span class="mono">fact_returns</span></div><div class="dim">a returned order line</div><div class=""><span class="mono">return_id</span></div><div class="dim">line_id, date_key, reason_code, sku</div></div><div class="gr"><div class="col"><span class="mono">dim_return_reasons</span></div><div class="dim">a return reason</div><div class=""><span class="mono">reason_code</span></div><div class="dim"></div></div><div class="gr"><div class="col"><span class="mono">rpt_returns_by_reason</span></div><div class="dim">a month and a reason</div><div class=""><span class="mono">month, reason_code</span></div><div class="dim">built from fact_returns</div></div></div>
            </div></div>
          </div>
          <div class="pside">
            <div class="kv"><span class="lbl">tables</span><span class="v">3</span></div>
            <div class="kv"><span class="lbl">size</span><span class="v">16 MB</span></div>
            <div class="kv"><span class="lbl">queries · 2026-08</span><span class="v">104</span></div>
            <div class="kv"><span class="lbl">last update</span><span class="v">2026-09-01 05:42</span></div>
            <div class="kv chipsrow"><span class="lbl">read by</span><span class="chips"><span class="chip log">Operations</span><span class="chip fin">Finance</span></span></div>
            <div class="sidesep"></div>
            <div class="oitem"><div class="av">CO</div><div><div class="v ov">Customer Operations</div><div class="k ok">head of customer operations</div></div></div>
            <div class="oitem"><div class="av">DP</div><div><div class="v ov">Data Platform</div><div class="k ok">head of data platform, signs off a release</div></div></div>
            <div class="oitem"><div class="av">DE</div><div><div class="v ov">Data engineering</div><div class="k ok">the data engineer, owner</div></div></div>
            <div class="sidesep"></div>
            <button class="btn conn">Copy the read-only connection</button><pre class="conncode" hidden>duckdb.connect(<span class="s-str">&quot;data/warehouse/newvolt.duckdb&quot;</span>,
    read_only=<span class="s-num">True</span>)</pre>
          </div>
        </div>
      </section><section class="view pview" id="vProduct-stock-and-purchasing" data-slug="stock-and-purchasing">
        <div class="psplit">
          <div class="pleft">
            <div class="crumbs"><a data-go="market">Data Products</a><span class="sep">/</span><b>Stock and purchasing</b></div>
            <div class="phead"><div class="glyph"><svg width="30" height="30" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="7" rx="1.8"/><rect x="3" y="13" width="18" height="7" rx="1.8"/><path d="M7 7.5h3M7 16.5h3"/></svg></div><h1>Stock and purchasing</h1><span class="exp">no data contract</span></div>
            <div class="pdesc">stock per SKU and day, purchase orders, the suppliers and their fill rate by month</div>
            <div class="tabs ptabs"><div class="tab ptab on" data-pt="overview">Overview</div><div class="tab ptab off" data-pt="guide">Guide</div><div class="tab ptab" data-pt="model">Data model</div><div class="tab ptab off" data-pt="metrics">Metrics</div><div class="tab ptab off" data-pt="queries">Queries</div><div class="tab ptab off" data-pt="quality">Quality</div><div class="tab ptab off" data-pt="releases">Releases</div><div class="tab ptab off" data-pt="contract">Contract</div></div>
            <div class="pscroll"><div class="pp on" data-pp="overview">
            <div class="sech"><div class="t"><div class="accent"></div><h3>Tables</h3></div><div class="c">4 tables · gold_marts</div></div>
            <div class="trow h"><div>table</div><div>kind</div><div>rows</div><div>size</div><div>last update</div><div></div></div>
            <div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>fact_stock_daily</div><div class="zone">fact</div><div class="num">13,402,118</div><div class="num">210 MB</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div><div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>fact_purchases</div><div class="zone">fact</div><div class="num">6,870</div><div class="num">1 MB</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div><div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>dim_suppliers</div><div class="zone">dimension</div><div class="num">8</div><div class="num">1 MB</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div><div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>rpt_supplier_fill_rate</div><div class="zone">report table</div><div class="num">384</div><div class="num">1 MB</div><div class="num late">2026-07-22 05:41</div><div class="go"></div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>Read by</h3></div><div class="c">1 role in ops/query_logs.csv</div></div>
            <div class="rrow"><div class="rr mono">operations_analyst</div><div class="rp">Operations</div><div class="rw">stock, purchase orders and the fill rate</div></div></div><div class="pp" data-pp="model"><div class="docline"><svg width="15" height="15" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M6 3h8l4 4v14H6z"/><path d="M14 3v4h4"/></svg><span>read from the warehouse and the SQL headers</span></div>
            <div class="star" style="height:803px"><svg width="1180" height="803" viewBox="0 0 1180 803"><path class="sl join" d="M225 286 V244 H510 V202"/><circle cx="225" cy="286" r="4"/><circle cx="510" cy="202" r="4"/><path class="sl join" d="M955 286 V244 H670 V202"/><circle cx="955" cy="286" r="4"/><circle cx="670" cy="202" r="4"/><path class="sl join" d="M290 364 H445"/><circle cx="290" cy="364" r="4"/><circle cx="445" cy="364" r="4"/><path class="sl join" d="M890 364 H735"/><circle cx="890" cy="364" r="4"/><circle cx="735" cy="364" r="4"/><path class="sl join" d="M1035 286 V202"/><circle cx="1035" cy="286" r="4"/><circle cx="1035" cy="202" r="4"/><path class="sl built" d="M1035 511 V595"/><circle cx="1035" cy="511" r="4"/><circle cx="1035" cy="595" r="4"/></svg><div class="sbox k-dimension other" style="left:445px;top:0px;width:290px;height:202px"><div class="sk">DIMENSION · TRADING</div><div class="sn">dim_date</div><div class="sc"><span class="cn key">date_key</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">calendar_date</span></div><div class="sc"><span class="cn dim">year_month</span></div><div class="sc"><span class="cn dim">day_name</span></div><div class="more">+ 9 columns</div></div><div class="sbox k-dimension" style="left:890px;top:0px;width:290px;height:202px"><div class="sk">DIMENSION</div><div class="sn">dim_suppliers</div><div class="sc"><span class="cn key">supplier_id</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">name</span></div><div class="sc"><span class="cn dim">country</span></div><div class="sc"><span class="cn dim">lead_days</span></div><div class="more">+ 1 column</div></div><div class="sbox k-fact" style="left:0px;top:286px;width:290px;height:202px"><div class="sk">FACT</div><div class="sn">fact_stock_daily</div><div class="sc"><span class="cn key">date_key</span><span class="tg">PK</span></div><div class="sc"><span class="cn key">sku</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">on_hand</span></div><div class="sc"><span class="cn dim">days_of_cover</span></div><div class="more">+ 1 column</div></div><div class="sbox k-dimension other" style="left:445px;top:286px;width:290px;height:202px"><div class="sk">DIMENSION · PRODUCTS</div><div class="sn">dim_products</div><div class="sc"><span class="cn key">sku</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">product_name</span></div><div class="sc"><span class="cn dim">brand</span></div><div class="sc"><span class="cn dim">category</span></div><div class="more">+ 8 columns</div></div><div class="sbox k-fact" style="left:890px;top:286px;width:290px;height:225px"><div class="sk">FACT</div><div class="sn">fact_purchases</div><div class="sc"><span class="cn key">po_id</span><span class="tg">PK</span></div><div class="sc"><span class="cn">date_key</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">supplier_id</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">sku</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn dim">lead_days</span></div><div class="more">+ 3 columns</div></div><div class="sbox k-report stale" style="left:890px;top:595px;width:290px;height:202px"><div class="sk">REPORT TABLE · STALE</div><div class="sn">rpt_supplier_fill_rate</div><div class="sc"><span class="cn key">month</span><span class="tg">PK</span></div><div class="sc"><span class="cn key">supplier_id</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">fill_rate_pct</span></div><div class="sc"><span class="cn dim">avg_lead_days</span></div><div class="more">+ 2 columns</div></div><div class="slab" style="left:368px;top:244px">date_key</div><div class="slab" style="left:812px;top:244px">date_key</div><div class="slab" style="left:368px;top:364px">sku</div><div class="slab" style="left:812px;top:364px">sku</div><div class="slab" style="left:1035px;top:224px">supplier_id</div><div class="slab" style="left:1035px;top:553px">built from</div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>One row is</h3></div><div class="c">4 tables</div></div>
            <div class="gt " style="--cols:290px minmax(0,1fr) 200px 320px"><div class="gh"><div>table</div><div>one row is</div><div>key</div><div>joins on</div></div><div class="gr"><div class="col"><span class="mono">fact_stock_daily</span></div><div class="dim">a SKU on a day</div><div class=""><span class="mono">date_key, sku</span></div><div class="dim">date_key, sku</div></div><div class="gr"><div class="col"><span class="mono">fact_purchases</span></div><div class="dim">a purchase order of one product</div><div class=""><span class="mono">po_id</span></div><div class="dim">date_key, supplier_id, sku</div></div><div class="gr"><div class="col"><span class="mono">dim_suppliers</span></div><div class="dim">a supplier</div><div class=""><span class="mono">supplier_id</span></div><div class="dim"></div></div><div class="gr"><div class="col"><span class="mono">rpt_supplier_fill_rate</span></div><div class="dim">a month and a supplier</div><div class=""><span class="mono">month, supplier_id</span></div><div class="dim">built from fact_purchases; last rebuilt <span class="nw">2026-07-22</span></div></div></div>
            </div></div>
          </div>
          <div class="pside">
            <div class="kv"><span class="lbl">tables</span><span class="v">4</span></div>
            <div class="kv"><span class="lbl">size</span><span class="v">213 MB</span></div>
            <div class="kv"><span class="lbl">queries · 2026-08</span><span class="v">70</span></div>
            <div class="kv"><span class="lbl">last update</span><span class="v">2026-09-01 05:42</span></div>
            <div class="kv chipsrow"><span class="lbl">read by</span><span class="chips"><span class="chip log">Operations</span></span></div>
            <div class="sidesep"></div>
            <div class="oitem"><div class="av">PL</div><div><div class="v ov">Purchasing and Logistics</div><div class="k ok">head of purchasing and logistics</div></div></div>
            <div class="oitem"><div class="av">DP</div><div><div class="v ov">Data Platform</div><div class="k ok">head of data platform, signs off a release</div></div></div>
            <div class="oitem"><div class="av">DE</div><div><div class="v ov">Data engineering</div><div class="k ok">the data engineer, owner</div></div></div>
            <div class="sidesep"></div>
            <button class="btn conn">Copy the read-only connection</button><pre class="conncode" hidden>duckdb.connect(<span class="s-str">&quot;data/warehouse/newvolt.duckdb&quot;</span>,
    read_only=<span class="s-num">True</span>)</pre>
          </div>
        </div>
      </section><section class="view pview" id="vProduct-campaigns" data-slug="campaigns">
        <div class="psplit">
          <div class="pleft">
            <div class="crumbs"><a data-go="market">Data Products</a><span class="sep">/</span><b>Campaigns</b></div>
            <div class="phead"><div class="glyph"><svg width="30" height="30" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="5" width="18" height="15" rx="2.5"/><path d="M3 10h18M8 3v4M16 3v4"/></svg></div><h1>Campaigns</h1><span class="exp">no data contract</span></div>
            <div class="pdesc">one row per approved campaign window, and the discount offers of the old promotions table</div>
            <div class="tabs ptabs"><div class="tab ptab on" data-pt="overview">Overview</div><div class="tab ptab off" data-pt="guide">Guide</div><div class="tab ptab" data-pt="model">Data model</div><div class="tab ptab off" data-pt="metrics">Metrics</div><div class="tab ptab off" data-pt="queries">Queries</div><div class="tab ptab off" data-pt="quality">Quality</div><div class="tab ptab off" data-pt="releases">Releases</div><div class="tab ptab off" data-pt="contract">Contract</div></div>
            <div class="pscroll"><div class="pp on" data-pp="overview">
            <div class="sech"><div class="t"><div class="accent"></div><h3>Tables</h3></div><div class="c">2 tables · gold_marts</div></div>
            <div class="trow h"><div>table</div><div>kind</div><div>rows</div><div>size</div><div>last update</div><div></div></div>
            <div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>dim_campaigns</div><div class="zone">dimension</div><div class="num">1,844</div><div class="num">1 MB</div><div class="num">2026-09-01 05:42</div><div class="go"></div></div><div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>dim_promotions_old</div><div class="zone">dimension</div><div class="num">20,362</div><div class="num">3 MB</div><div class="num late">2026-08-14 10:12</div><div class="go"></div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>Read by</h3></div><div class="c">1 role in ops/query_logs.csv</div></div>
            <div class="rrow"><div class="rr mono">marketing_analyst</div><div class="rp">Marketing</div><div class="rw">campaign windows and their offers</div></div></div><div class="pp" data-pp="model"><div class="docline"><svg width="15" height="15" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M6 3h8l4 4v14H6z"/><path d="M14 3v4h4"/></svg><span>read from the warehouse and the SQL headers</span></div>
            <div class="star" style="height:540px"><svg width="1180" height="540" viewBox="0 0 1180 540"><path class="sl join" d="M668 78 H512"/><circle cx="668" cy="78" r="4"/><circle cx="512" cy="78" r="4"/><path class="sl join" d="M368 286 V202"/><circle cx="368" cy="286" r="4"/><circle cx="368" cy="202" r="4"/><path class="sl join" d="M812 202 V286"/><circle cx="812" cy="202" r="4"/><circle cx="812" cy="286" r="4"/></svg><div class="sbox k-dimension" style="left:222px;top:0px;width:290px;height:202px"><div class="sk">DIMENSION</div><div class="sn">dim_campaigns</div><div class="sc"><span class="cn key">campaign_id</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">name</span></div><div class="sc"><span class="cn dim">starts_on</span></div><div class="sc"><span class="cn dim">ends_on</span></div><div class="more">+ 2 columns</div></div><div class="sbox k-dimension stale" style="left:668px;top:0px;width:290px;height:202px"><div class="sk">DIMENSION · STALE</div><div class="sn">dim_promotions_old</div><div class="sc"><span class="cn key">offer_id</span><span class="tg">PK</span></div><div class="sc"><span class="cn">sku</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">campaign_id</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn dim">discount_pct</span></div><div class="more">+ 8 columns</div></div><div class="sbox k-fact other" style="left:222px;top:286px;width:290px;height:248px"><div class="sk">FACT · TRADING</div><div class="sn">fact_orders</div><div class="sc"><span class="cn key">order_id</span><span class="tg">PK</span></div><div class="sc"><span class="cn">date_key</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">customer_id</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn">campaign_id</span><span class="tg fk">FK</span></div><div class="sc"><span class="cn dim">is_cancelled</span></div><div class="sc"><span class="cn dim">net_eur</span></div><div class="more">+ 4 columns</div></div><div class="sbox k-dimension other" style="left:668px;top:286px;width:290px;height:202px"><div class="sk">DIMENSION · PRODUCTS</div><div class="sn">dim_products</div><div class="sc"><span class="cn key">sku</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">product_name</span></div><div class="sc"><span class="cn dim">brand</span></div><div class="sc"><span class="cn dim">category</span></div><div class="more">+ 8 columns</div></div><div class="slab" style="left:590px;top:78px">campaign_id</div><div class="slab" style="left:368px;top:244px">campaign_id</div><div class="slab" style="left:812px;top:244px">sku</div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>One row is</h3></div><div class="c">2 tables</div></div>
            <div class="gt " style="--cols:290px minmax(0,1fr) 200px 320px"><div class="gh"><div>table</div><div>one row is</div><div>key</div><div>joins on</div></div><div class="gr"><div class="col"><span class="mono">dim_campaigns</span></div><div class="dim">an approved campaign window</div><div class=""><span class="mono">campaign_id</span></div><div class="dim"></div></div><div class="gr"><div class="col"><span class="mono">dim_promotions_old</span></div><div class="dim">a discount offer on one SKU</div><div class=""><span class="mono">offer_id</span></div><div class="dim">sku, campaign_id; run manually on <span class="nw">2026-08-14</span></div></div></div>
            </div></div>
          </div>
          <div class="pside">
            <div class="kv"><span class="lbl">tables</span><span class="v">2</span></div>
            <div class="kv"><span class="lbl">size</span><span class="v">4 MB</span></div>
            <div class="kv"><span class="lbl">queries · 2026-08</span><span class="v">34</span></div>
            <div class="kv"><span class="lbl">last update</span><span class="v">2026-09-01 05:42</span></div>
            <div class="kv chipsrow"><span class="lbl">read by</span><span class="chips"><span class="chip mkt">Marketing</span></span></div>
            <div class="sidesep"></div>
            <div class="oitem"><div class="av">AM</div><div><div class="v ov">Marketing</div><div class="k ok">head of marketing</div></div></div>
            <div class="oitem"><div class="av">DP</div><div><div class="v ov">Data Platform</div><div class="k ok">head of data platform, signs off a release</div></div></div>
            <div class="oitem"><div class="av">DE</div><div><div class="v ov">Data engineering</div><div class="k ok">the data engineer, owner</div></div></div>
            <div class="sidesep"></div>
            <button class="btn conn">Copy the read-only connection</button><pre class="conncode" hidden>duckdb.connect(<span class="s-str">&quot;data/warehouse/newvolt.duckdb&quot;</span>,
    read_only=<span class="s-num">True</span>)</pre>
          </div>
        </div>
      </section><section class="view pview" id="vProduct-daily-sales" data-slug="daily-sales">
        <div class="psplit">
          <div class="pleft">
            <div class="crumbs"><a data-go="market">Data Products</a><span class="sep">/</span><b>Daily sales</b></div>
            <div class="phead"><div class="glyph"><svg width="30" height="30" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M4 20V10M10 20V4M16 20v-8M21 20H3"/></svg></div><h1>Daily sales</h1><span class="exp">deprecated</span></div>
            <div class="pdesc">order lines read straight from bronze; replaced by the one big table on 2026-07-31</div>
            <div class="tabs ptabs"><div class="tab ptab on" data-pt="overview">Overview</div><div class="tab ptab off" data-pt="guide">Guide</div><div class="tab ptab" data-pt="model">Data model</div><div class="tab ptab off" data-pt="metrics">Metrics</div><div class="tab ptab off" data-pt="queries">Queries</div><div class="tab ptab off" data-pt="quality">Quality</div><div class="tab ptab off" data-pt="releases">Releases</div><div class="tab ptab off" data-pt="contract">Contract</div></div>
            <div class="pscroll"><div class="pp on" data-pp="overview">
            <div class="sech"><div class="t"><div class="accent"></div><h3>Tables</h3></div><div class="c">1 table · gold_marts</div></div>
            <div class="trow h"><div>table</div><div>kind</div><div>rows</div><div>size</div><div>last update</div><div></div></div>
            <div class="trow"><div class="tn"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>rpt_daily_sales_wide</div><div class="zone">report table</div><div class="num">16,902,377</div><div class="num">1.2 GB</div><div class="num late">2026-07-31 05:41</div><div class="go"></div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>Read by</h3></div><div class="c">1 role in ops/query_logs.csv</div></div>
            <div class="rrow"><div class="rr mono">monday_pack</div><div class="rp">the BI service</div><div class="rw">5 queries in 2026-08 against a table that holds no 2026-08</div></div></div><div class="pp" data-pp="model"><div class="docline"><svg width="15" height="15" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><path d="M6 3h8l4 4v14H6z"/><path d="M14 3v4h4"/></svg><span>read from the warehouse and the SQL headers</span></div>
            <div class="star" style="height:494px"><svg width="1180" height="494" viewBox="0 0 1180 494"><path class="sl built" d="M290 78 H445"/><circle cx="290" cy="78" r="4"/><circle cx="445" cy="78" r="4"/><path class="sl built" d="M225 286 V244 H510 V202"/><circle cx="225" cy="286" r="4"/><circle cx="510" cy="202" r="4"/><path class="sl built" d="M735 78 H890"/><circle cx="735" cy="78" r="4"/><circle cx="890" cy="78" r="4"/></svg><div class="sbox k-bronze other" style="left:0px;top:0px;width:290px;height:202px"><div class="sk">BRONZE TABLE</div><div class="sn">commerce_orders</div><div class="sc"><span class="cn dim">ord_id</span></div><div class="sc"><span class="cn dim">ord_ts</span></div><div class="sc"><span class="cn dim">cust_ref</span></div><div class="sc"><span class="cn dim">status</span></div><div class="more">+ 17 columns</div></div><div class="sbox k-report deprecated" style="left:445px;top:0px;width:290px;height:202px"><div class="sk">REPORT TABLE · DEPRECATED</div><div class="sn">rpt_daily_sales_wide</div><div class="sc"><span class="cn dim">sales_day</span></div><div class="sc"><span class="cn dim">ord_id</span></div><div class="sc"><span class="cn dim">net_ct</span></div><div class="sc"><span class="cn dim">_corrupt_record</span></div><div class="more">+ 33 columns</div></div><div class="sbox k-one other" style="left:890px;top:0px;width:290px;height:202px"><div class="sk">ONE BIG TABLE · TRADING</div><div class="sn">obt_order_lines</div><div class="sc"><span class="cn key">line_id</span><span class="tg">PK</span></div><div class="sc"><span class="cn dim">order_id</span></div><div class="sc"><span class="cn dim">ordered_on</span></div><div class="sc"><span class="cn dim">net_eur</span></div><div class="more">+ 19 columns</div></div><div class="sbox k-bronze other" style="left:0px;top:286px;width:290px;height:202px"><div class="sk">BRONZE TABLE</div><div class="sn">commerce_order_lines</div><div class="sc"><span class="cn dim">line_ref</span></div><div class="sc"><span class="cn dim">ord_id</span></div><div class="sc"><span class="cn dim">sku</span></div><div class="sc"><span class="cn dim">net_ct</span></div><div class="more">+ 9 columns</div></div><div class="slab" style="left:368px;top:78px">built from</div><div class="slab" style="left:368px;top:244px">built from</div><div class="slab" style="left:812px;top:78px">replaced by</div></div>
            <div class="sech"><div class="t"><div class="accent"></div><h3>One row is</h3></div><div class="c">1 table</div></div>
            <div class="gt " style="--cols:290px minmax(0,1fr) 200px 320px"><div class="gh"><div>table</div><div>one row is</div><div>key</div><div>joins on</div></div><div class="gr"><div class="col"><span class="mono">rpt_daily_sales_wide</span></div><div class="dim">a bronze order line joined to its bronze order, as delivered</div><div class="">none</div><div class="dim">read from bronze; deprecated on <span class="nw">2026-07-31</span></div></div></div>
            </div></div>
          </div>
          <div class="pside">
            <div class="kv"><span class="lbl">tables</span><span class="v">1</span></div>
            <div class="kv"><span class="lbl">size</span><span class="v">1.2 GB</span></div>
            <div class="kv"><span class="lbl">queries · 2026-08</span><span class="v">5</span></div>
            <div class="kv"><span class="lbl">last update</span><span class="v">2026-07-31 05:41</span></div>
            <div class="kv chipsrow"><span class="lbl">read by</span><span class="chips"><span class="chip fin">Finance</span></span></div>
            <div class="sidesep"></div>
            <div class="oitem"><div class="av">FI</div><div><div class="v ov">Finance</div><div class="k ok">head of finance; Trading replaced it on 2026-07-31</div></div></div>
            <div class="oitem"><div class="av">DP</div><div><div class="v ov">Data Platform</div><div class="k ok">head of data platform, signs off a release</div></div></div>
            <div class="oitem"><div class="av">DE</div><div><div class="v ov">Data engineering</div><div class="k ok">the data engineer, owner</div></div></div>
            <div class="sidesep"></div>
            <button class="btn conn">Copy the read-only connection</button><pre class="conncode" hidden>duckdb.connect(<span class="s-str">&quot;data/warehouse/newvolt.duckdb&quot;</span>,
    read_only=<span class="s-num">True</span>)</pre>
          </div>
        </div>
      </section><section class="view" id="vTable">
        <div class="tbody">
          <div class="left">
            <div class="crumbs" style="margin-bottom:18px;"><a data-go="market">Data Products</a><span class="sep">/</span><a data-go="product" data-key="trading">Trading</a><span class="sep">/</span><b>obt_order_lines</b></div>
            <div class="paneTitle">Data</div>
            <div class="paneSub">the table itself</div>
            <div class="gcard">
              <div class="gbar"><div class="gname"><svg width="19" height="19" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg>obt_order_lines</div><div class="filter"><svg width="15" height="15" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.9" stroke-linecap="round"><circle cx="11" cy="11" r="6.4"/><path d="M15.9 15.9L20.5 20.5"/></svg>Filter rows</div></div>
              <div class="row head"><div>#</div><div>line_id</div><div>ordered_on</div><div>category</div><div>ship_country</div><div>quantity</div><div>net_eur</div></div>
              <div class="row rec"><div class="num2">1</div><div class="m">SO468920-01</div><div class="m">2026-08-31</div><div class="m">Monitors</div><div class="m">DE</div><div class="m">2</div><div class="m">205.87</div></div><div class="row rec"><div class="num2">2</div><div class="m">SO468920-02</div><div class="m">2026-08-31</div><div class="m">Phones and Tablets</div><div class="m">DE</div><div class="m">3</div><div class="m">680.55</div></div><div class="row rec"><div class="num2">3</div><div class="m">SO468920-03</div><div class="m">2026-08-31</div><div class="m">Accessories</div><div class="m">DE</div><div class="m">1</div><div class="m">16.63</div></div><div class="row rec"><div class="num2">4</div><div class="m">SO468921-01</div><div class="m">2026-08-31</div><div class="m">Monitors</div><div class="m">DE</div><div class="m">1</div><div class="m">182.77</div></div><div class="row rec"><div class="num2">5</div><div class="m">SO468922-01</div><div class="m">2026-08-31</div><div class="m">Phones and Tablets</div><div class="m">FR</div><div class="m">1</div><div class="m">149.99</div></div><div class="row rec"><div class="num2">6</div><div class="m">SO468923-01</div><div class="m">2026-08-31</div><div class="m">Accessories</div><div class="m">DE</div><div class="m">1</div><div class="m">36.13</div></div><div class="row rec"><div class="num2">7</div><div class="m">SO468924-01</div><div class="m">2026-08-31</div><div class="m">Computers</div><div class="m">IT</div><div class="m">2</div><div class="m">1115.95</div></div><div class="row rec"><div class="num2">8</div><div class="m">SO468925-01</div><div class="m">2026-08-31</div><div class="m">Accessories</div><div class="m">DE</div><div class="m">2</div><div class="m">41.66</div></div><div class="row rec"><div class="num2">9</div><div class="m">SO468925-02</div><div class="m">2026-08-31</div><div class="m">Audio</div><div class="m">DE</div><div class="m">2</div><div class="m">252.08</div></div><div class="row rec"><div class="num2">10</div><div class="m">SO468925-03</div><div class="m">2026-08-31</div><div class="m">Accessories</div><div class="m">DE</div><div class="m">1</div><div class="m">31.08</div></div>
              <div class="gfoot">12,418,906 rows · showing 10</div>
            </div>
          </div>
          <div class="right">
            <div class="rhead"><div><div class="paneTitle">obt_order_lines</div><div class="paneSub">everything the platform knows about this table</div></div><span class="cert">release 1.1.0 · active</span></div>
            <div class="tabs">
              <div class="tab rtab on" data-tv="tvMeta">Metadata</div><div class="tab rtab" data-tv="tvSem">Semantic</div><div class="tab rtab" data-tv="tvLin">Lineage</div><div class="tab rtab" data-tv="tvCon">Contact</div>
            </div>
            <div class="scroll">
            <div class="tv on" id="tvMeta">
              <div class="mdesc">one row per order line of an order that was not cancelled, with its day, customer and product beside it</div>
              <div class="mstats">
                <div class="st"><div class="lbl">rows</div><div class="v">12,418,906</div></div><div class="st"><div class="lbl">size</div><div class="v">820 MB</div></div>
                <div class="st"><div class="lbl">format</div><div class="v mono">duckdb</div></div><div class="st"><div class="lbl">location</div><div class="v path">newvolt.duckdb/gold_marts</div></div>
                <div class="st"><div class="lbl">last update</div><div class="v">2026-09-01 05:42</div></div>
              </div>
              <div class="ownerRow">
                <div class="oitem"><div class="av">DE</div><div><div class="v">the data engineer</div><div class="k">owner</div></div></div>
                <div class="oitem"><div class="av"><svg width="18" height="18" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="4" width="18" height="16" rx="2.6"/><path d="M3 9.4h18M9.6 9.4V20"/></svg></div><div><div class="v">pipeline/gold/marts/obt_order_lines.sql</div><div class="k">built by · every run that succeeds, 05:30 UTC</div></div></div>
              </div>
              <div class="srow h"><div>column</div><div>type</div><div>nulls</div><div>meaning</div><div></div></div>
              <div class="srow d"><div class="cname">line_id</div><div><span class="pill var">VARCHAR</span></div><div class="nn">not null</div><div class="mean">the order line number, like SO372035-01; the key</div><div class="tagc"></div></div><div class="srow d"><div class="cname">order_id</div><div><span class="pill var">VARCHAR</span></div><div class="nn">not null</div><div class="mean">the order the line belongs to; several lines share one order</div><div class="tagc"></div></div><div class="srow d"><div class="cname">ordered_on</div><div><span class="pill date">DATE</span></div><div class="nn">not null</div><div class="mean">the day the order was placed, the UTC day of the checkout</div><div class="tagc"></div></div><div class="srow d"><div class="cname">order_month</div><div><span class="pill var">VARCHAR</span></div><div class="nn">not null</div><div class="mean">the month the order was placed, like <span class="nw">2026-08</span></div><div class="tagc"></div></div><div class="srow d"><div class="cname">order_year</div><div><span class="pill int">BIGINT</span></div><div class="nn">not null</div><div class="mean">the year the order was placed</div><div class="tagc"></div></div><div class="srow d"><div class="cname">customer_id</div><div><span class="pill var">VARCHAR</span></div><div class="nn">not null</div><div class="mean">the shop account that ordered, or unknown for a guest checkout</div><div class="tagc"></div></div><div class="srow d"><div class="cname">customer_type</div><div><span class="pill var">VARCHAR</span></div><div class="nn">not null</div><div class="mean">Finance&#x27;s customer type at placement: guest, new or returning</div><div class="tagc"></div></div><div class="srow d"><div class="cname">home_country</div><div><span class="pill var">VARCHAR</span></div><div class="cn2">can be null</div><div class="mean">the country of the customer&#x27;s account, <span class="nw">ISO 3166-1 alpha-2</span>; not where the order was sent</div><div class="tagc"></div></div><div class="srow d"><div class="cname">signup_channel</div><div><span class="pill var">VARCHAR</span></div><div class="cn2">can be null</div><div class="mean">where the account was created: web or app</div><div class="tagc"></div></div><div class="srow d"><div class="cname">is_business</div><div><span class="pill int">BOOLEAN</span></div><div class="cn2">can be null</div><div class="mean">true when the account belongs to a business account</div><div class="tagc"></div></div><div class="srow d"><div class="cname">sku</div><div><span class="pill var">VARCHAR</span></div><div class="nn">not null</div><div class="mean">the product on the line, one physical variant</div><div class="tagc"></div></div><div class="srow d"><div class="cname">product_name</div><div><span class="pill var">VARCHAR</span></div><div class="nn">not null</div><div class="mean">the name of the product; it does not always say the colour</div><div class="tagc"></div></div><div class="srow d"><div class="cname">brand</div><div><span class="pill var">VARCHAR</span></div><div class="nn">not null</div><div class="mean">the brand: Kaivo, Kova, Nodo, Ondia, Pavo or Visna</div><div class="tagc"></div></div><div class="srow d"><div class="cname">category</div><div><span class="pill var">VARCHAR</span></div><div class="nn">not null</div><div class="mean">the category: Phones and Tablets, Computers, Monitors, Accessories or Audio</div><div class="tagc"></div></div><div class="srow d"><div class="cname">ship_country</div><div><span class="pill var">VARCHAR</span></div><div class="nn">not null</div><div class="mean">the country the order ships to, <span class="nw">ISO 3166-1 alpha-2</span>; the market of the sale</div><div class="tagc"></div></div><div class="srow d"><div class="cname">channel</div><div><span class="pill var">VARCHAR</span></div><div class="nn">not null</div><div class="mean">where the order was placed: web, app or marketplace</div><div class="tagc"></div></div><div class="srow d"><div class="cname">acquisition_source</div><div><span class="pill var">VARCHAR</span></div><div class="cn2">can be null</div><div class="mean">the last touch that brought the checkout; always marketplace on a marketplace order</div><div class="tagc"></div></div><div class="srow d"><div class="cname">campaign_id</div><div><span class="pill var">VARCHAR</span></div><div class="cn2">can be null</div><div class="mean">the campaign window the order fell in, if any; it does not prove an offer was used</div><div class="tagc"></div></div><div class="srow d"><div class="cname">quantity</div><div><span class="pill int">INTEGER</span></div><div class="nn">not null</div><div class="mean">the ordered units on the line</div><div class="tagc"><span class="add">additive</span></div></div><div class="srow d"><div class="cname">gross_eur</div><div><span class="pill int">DOUBLE</span></div><div class="nn">not null</div><div class="mean">quantity times list price, before any discount, in euros without VAT</div><div class="tagc"><span class="add">additive</span></div></div><div class="srow d"><div class="cname">discount_eur</div><div><span class="pill int">DOUBLE</span></div><div class="nn">not null</div><div class="mean">the whole discount on the line, in euros without VAT</div><div class="tagc"><span class="add">additive</span></div></div><div class="srow d"><div class="cname">net_eur</div><div><span class="pill int">DOUBLE</span></div><div class="nn">not null</div><div class="mean">the line after the discount, in euros without VAT; net revenue, no shipping, no refunds</div><div class="tagc"><span class="add">additive</span></div></div><div class="srow d"><div class="cname">standard_cost_eur</div><div><span class="pill int">DOUBLE</span></div><div class="cn2">can be null</div><div class="mean">quantity times the standard cost valid on the order day, in euros</div><div class="tagc"><span class="add">additive</span></div></div>
              <div class="fnote">The 4 euro columns are DOUBLE in the warehouse and DECIMAL(18,2) in the contract, a known issue: round every total to the cent.</div>
            </div>
            <div class="tv" id="tvSem">
              <div class="nameRow"><h2>metric_trading</h2><span class="kind">view · one definition per measure</span><span class="draft">draft for Finance</span></div>
              <div class="mdesc">Finance's trading measures by month, ship country, channel, customer type and category; cancelled orders are left out</div>
              <div class="shead2"><div class="accent g"></div><h3>Measures</h3><span class="cnt">8 measures</span></div>
              <div class="smrow h"><div>measure</div><div>formula</div><div>meaning</div></div>
              <div class="smrow d"><div class="mname">gross_merchandise_eur</div><div class="formula">sum(gross_eur)</div><div class="smmean">quantity times list price before discount, in euros without VAT; additive</div></div><div class="smrow d"><div class="mname">discount_eur</div><div class="formula">sum(discount_eur)</div><div class="smmean">the total line discount, in euros without VAT; additive</div></div><div class="smrow d"><div class="mname">net_revenue_eur</div><div class="formula">sum(net_eur)</div><div class="smmean">the line amounts after discount, in euros without VAT; excludes shipping and refunds; additive</div></div><div class="smrow d"><div class="mname">orders</div><div class="formula">count(DISTINCT order_id)</div><div class="smmean">distinct orders that were not cancelled; not additive</div></div><div class="smrow d"><div class="mname">registered_customers</div><div class="formula">count(DISTINCT customer_id)
FILTER (WHERE
  customer_id &lt;&gt; &#x27;unknown&#x27;)</div><div class="smmean">distinct shop accounts with an order; guests are not counted; not additive</div></div><div class="smrow d"><div class="mname">sold_units</div><div class="formula">sum(quantity)</div><div class="smmean">the units sold; additive</div></div><div class="smrow d"><div class="mname">average_order_value_eur</div><div class="formula">sum(net_eur) / nullif(
  count(DISTINCT order_id), 0)</div><div class="smmean">net revenue divided by distinct orders; blank when there is no order</div></div><div class="smrow d"><div class="mname">weighted_discount</div><div class="formula">sum(discount_eur) / nullif(
  sum(gross_eur), 0)</div><div class="smmean">total line discount divided by gross merchandise, not the average of line percentages</div></div>
              <div class="shead2"><div class="accent b"></div><h3>Dimensions</h3><span class="cnt">5 dimensions</span></div>
              <div class="smrow h"><div>dimension</div><div>formula</div><div>meaning</div></div>
              <div class="smrow d"><div class="mname dim">order_month</div><div class="formula">dim_date.year_month</div><div class="smmean">the month the order was placed, like 2026-08</div></div><div class="smrow d"><div class="mname dim">ship_country</div><div class="formula">fact_order_lines.ship_country</div><div class="smmean">the country the order ships to</div></div><div class="smrow d"><div class="mname dim">channel</div><div class="formula">fact_order_lines.channel</div><div class="smmean">where the order was placed: web, app or marketplace</div></div><div class="smrow d"><div class="mname dim">customer_type</div><div class="formula">fact_order_lines.customer_type</div><div class="smmean">Finance&#x27;s customer type at placement: guest, new or returning</div></div><div class="smrow d"><div class="mname dim">category</div><div class="formula">dim_products.category</div><div class="smmean">the category of the product</div></div>
            </div>
            <div class="tv" id="tvLin"><div class="lin"><svg width="990" height="660" viewBox="0 0 990 660"><path d="M 250 76 V 102"/><path d="M 250 172 V 198"/><path d="M 250 268 V 294"/><path d="M 250 364 V 390"/><path d="M 250 460 V 486"/><path d="M 440 521 H 485 V 425 H 530"/><path d="M 440 521 H 485 V 521 H 530"/><circle cx="250" cy="76" r="4"/><circle cx="250" cy="102" r="4"/><circle cx="250" cy="172" r="4"/><circle cx="250" cy="198" r="4"/><circle cx="250" cy="268" r="4"/><circle cx="250" cy="294" r="4"/><circle cx="250" cy="364" r="4"/><circle cx="250" cy="390" r="4"/><circle cx="250" cy="460" r="4"/><circle cx="250" cy="486" r="4"/><circle cx="440" cy="521" r="4"/><circle cx="530" cy="425" r="4"/><circle cx="440" cy="521" r="4"/><circle cx="530" cy="521" r="4"/></svg><div class="lnode src" style="left:60px;top:6px;"><div class="zone">source · commerce</div><div class="nm">order_lines.csv, the daily feed</div></div><div class="lnode bronze" style="left:60px;top:102px;"><div class="zone">bronze</div><div class="nm">bronze.commerce_order_lines</div></div><div class="lnode silver" style="left:60px;top:198px;"><div class="zone">silver_clean</div><div class="nm">silver_clean.order_lines</div></div><div class="lnode silver" style="left:60px;top:294px;"><div class="zone">silver_core</div><div class="nm">silver_core.order_lines</div></div><div class="lnode gold" style="left:60px;top:390px;"><div class="zone">gold</div><div class="nm">gold_marts.fact_order_lines</div></div><div class="lnode gold cur" style="left:60px;top:486px;"><div class="zone">gold · you are here</div><div class="nm">gold_marts.obt_order_lines</div></div><div class="lnode usef" style="left:530px;top:390px;"><div class="zone">consumer · monday_pack</div><div class="nm">the Monday trading pack</div></div><div class="lnode usef" style="left:530px;top:486px;"><div class="zone">consumer · finance_analyst</div><div class="nm">Finance</div></div></div></div>
            <div class="tv" id="tvCon">
              <div class="ccard"><div class="av">FI</div><div class="who"><div class="v">Finance</div><div class="k">head of finance · steward, owns the definitions of the measures</div></div><div class="meta"><div class="em">Finance team</div><div class="sl">signs the metric drafts</div></div></div>
              <div class="ccard"><div class="av">DE</div><div class="who"><div class="v">the data engineer</div><div class="k">owner · builds the table, answers for the data</div></div><div class="meta"><div class="em">data engineering team</div><div class="sl">a number that looks wrong goes here</div></div></div>
              <div class="ccard"><div class="av">DP</div><div class="who"><div class="v">Data Platform</div><div class="k">head of data platform · signs off a release</div></div><div class="meta"><div class="em">Data Platform team</div><div class="sl">scope and priorities</div></div></div>
              <div class="cconn"><button class="btn conn">Copy the read-only connection</button><pre class="conncode" hidden>duckdb.connect(<span class="s-str">&quot;data/warehouse/newvolt.duckdb&quot;</span>,
    read_only=<span class="s-num">True</span>)</pre></div>
            </div>
            </div>
          </div>
        </div>
      </section>
    </div>
  </div>
</div>
<script>  const st = document.getElementById('stage');
  function fit() { const s = Math.min(innerWidth / 1920, innerHeight / 1080); st.style.transform = 'translate(-50%,-50%) scale(' + s + ')'; }
  addEventListener('resize', fit); fit();

  const SLUGS = {"trading": "Trading", "customers": "Customers", "products": "Products", "delivery": "Delivery", "returns": "Returns", "stock-and-purchasing": "Stock and purchasing", "campaigns": "Campaigns", "daily-sales": "Daily sales"};
  const TV = { tvMeta: 'metadata', tvSem: 'semantic', tvLin: 'lineage', tvCon: 'contact' };
  const HOST = 'data-products.internal';

  function tabsOf(slug) {
    const v = document.getElementById('vProduct-' + slug);
    return v ? Array.from(v.querySelectorAll('.ptab:not(.off)')).map(function (t) { return t.dataset.pt; }) : [];
  }

  let current = { v: 'market', key: 'trading', pt: 'overview', tab: 'tvMeta' };
  function show(state) {
    const prev = current;
    current = Object.assign({}, current, state);
    document.querySelectorAll('.view').forEach(function (x) {
      const on = current.v === 'market' ? x.id === 'vMarket' : current.v === 'table' ? x.id === 'vTable' : x.id === 'vProduct-' + current.key;
      x.classList.toggle('on', on);
    });
    if (current.v === 'product') {
      const view = document.getElementById('vProduct-' + current.key);
      view.querySelectorAll('.ptab').forEach(function (t) { t.classList.toggle('on', t.dataset.pt === current.pt); });
      view.querySelectorAll('.pp').forEach(function (p) { p.classList.toggle('on', p.dataset.pp === current.pt); });
      if (prev.v !== 'product' || prev.key !== current.key || prev.pt !== current.pt) view.querySelector('.pscroll').scrollTop = 0;
    }
    document.querySelectorAll('.rtab').forEach(function (x) { x.classList.toggle('on', x.dataset.tv === current.tab); });
    document.querySelectorAll('.tv').forEach(function (x) { x.classList.toggle('on', x.id === current.tab); });
    if (current.v === 'table' && prev.tab !== current.tab) document.querySelector('#vTable .scroll').scrollTop = 0;
    let addr = HOST;
    if (current.v === 'product') addr += '/' + current.key + (current.pt === 'overview' ? '' : '/' + current.pt);
    if (current.v === 'table') addr += '/trading/obt_order_lines' + (current.tab === 'tvMeta' ? '' : '/' + TV[current.tab]);
    document.getElementById('addr').textContent = addr;
    document.getElementById('navBack').classList.toggle('off', current.v === 'market');
  }
  function hashOf(s) {
    if (s.v === 'product') return '#product/' + s.key + '/' + s.pt;
    if (s.v === 'table') return '#table/' + TV[s.tab];
    return '#market';
  }
  function push(state) { show(state); history.pushState(current, '', hashOf(current)); }
  function go(v, key) {
    if (v === 'product') push({ v: 'product', key: key || current.key, pt: 'overview' });
    else if (v === 'table') push({ v: 'table', tab: 'tvMeta' });
    else push({ v: 'market' });
  }

  // a short eased scroll inside a pane, the same in every browser
  function glide(box, to) {
    const from = box.scrollTop, dist = Math.min(to, box.scrollHeight - box.clientHeight) - from, t0 = performance.now();
    (function frame(now) {
      const k = Math.min(1, (now - t0) / 380), ease = 1 - Math.pow(1 - k, 3);
      box.scrollTop = from + dist * ease;
      if (k < 1) requestAnimationFrame(frame);
    })(t0);
  }

  // the starter queries: one is shown beside the list
  function pickQuery(view, n) {
    view.querySelectorAll('.qitem').forEach(function (x) { x.classList.toggle('on', x.dataset.q === String(n)); });
    view.querySelectorAll('.qd').forEach(function (x) { x.classList.toggle('on', x.dataset.qd === String(n)); });
  }

  function filterGroup(g) {
    document.getElementById('q').value = '';
    document.querySelectorAll('.fchip').forEach(function (c) { c.classList.toggle('on', c.dataset.group === g); });
    document.querySelectorAll('.pcard').forEach(function (c) { c.classList.toggle('hidden', g !== 'All' && c.dataset.groups.split('|').indexOf(g) < 0); });
  }
  function filterText(t) {
    t = t.trim().toLowerCase();
    document.querySelectorAll('.fchip').forEach(function (c) { c.classList.toggle('on', c.dataset.group === 'All'); });
    document.querySelectorAll('.pcard').forEach(function (c) { c.classList.toggle('hidden', !!t && c.dataset.s.indexOf(t) < 0); });
  }

  // one listener for every click: navigation, the filters, the tabs, the guide's steps, the connection line, the window's back and forward
  document.addEventListener('click', function (ev) {
    const nav = ev.target.closest('[data-go]');
    if (nav) { go(nav.dataset.go, nav.dataset.key); return; }
    const chip = ev.target.closest('.fchip');
    if (chip) { filterGroup(chip.dataset.group); return; }
    const ptab = ev.target.closest('.ptab');
    if (ptab) { if (!ptab.classList.contains('off') && ptab.dataset.pt !== current.pt) push({ pt: ptab.dataset.pt }); return; }
    const rtab = ev.target.closest('.rtab');
    if (rtab) { if (rtab.dataset.tv !== current.tab) push({ tab: rtab.dataset.tv }); return; }
    const ans = ev.target.closest('.ans[data-q]');
    if (ans) { pickQuery(ans.closest('.pview'), ans.dataset.q); push({ pt: 'queries' }); return; }
    const qi = ev.target.closest('.qitem');
    if (qi) { pickQuery(qi.closest('.pview'), qi.dataset.q); return; }
    const seg = ev.target.closest('.seg span');
    if (seg) {
      const pane = seg.closest('.pp');
      pane.querySelectorAll('.seg span').forEach(function (x) { x.classList.toggle('on', x === seg); });
      pane.querySelectorAll('.cv').forEach(function (x) { x.classList.toggle('on', x.dataset.cvp === seg.dataset.cv); });
      return;
    }
    const step = ev.target.closest('[data-jump]');
    if (step) {
      const target = document.getElementById(step.dataset.jump);
      const box = target.closest('.pscroll');
      glide(box, box.scrollTop + target.getBoundingClientRect().top - box.getBoundingClientRect().top - 8);
      return;
    }
    if (ev.target.closest('#navBack')) { history.back(); return; }
    if (ev.target.closest('#navFwd')) { history.forward(); return; }
    const conn = ev.target.closest('.conn');
    if (conn) {
      const code = conn.nextElementSibling;
      code.hidden = false;
      try { navigator.clipboard.writeText(code.textContent); } catch (err) { /* a file:// page may not reach the clipboard */ }
      conn.textContent = 'Copied'; conn.classList.add('sent');
    }
  });
  document.getElementById('q').addEventListener('input', function (ev) { filterText(ev.target.value); });

  function fromHash() {
    const h = decodeURIComponent(location.hash.slice(1)).split('/');
    if (h[0] === 'product' && SLUGS[h[1]]) {
      const pt = tabsOf(h[1]).indexOf(h[2]) >= 0 ? h[2] : 'overview';
      return { v: 'product', key: h[1], pt: pt };
    }
    if (h[0] === 'table') {
      const tab = Object.keys(TV).find(function (k) { return TV[k] === h[1]; }) || 'tvMeta';
      return { v: 'table', tab: tab };
    }
    return { v: 'market' };
  }
  addEventListener('popstate', function (ev) {
    show(ev.state || fromHash());
    if (!ev.state) history.replaceState(current, '', hashOf(current));
  });
  show(fromHash()); history.replaceState(current, '', hashOf(current));
</script>
</body>
</html>
slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 196kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 193kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 193kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 193kUpdated Claude CodeCodexVerifiedInstall