DataWithBaraa/claude-code-data-engineering-skills / skills/data-product
data-product
VerifiedUse 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.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 1.8 KB |
| references/data-products.html | other | 240.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">‹</div><div class="navb" id="navFwd" title="forward">›</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'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'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'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'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'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">"data/warehouse/newvolt.duckdb"</span>, read_only=<span class="s-num">True</span>)
con.sql(<span class="s-str">"SELECT count(*) FROM gold_marts.obt_order_lines"</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 <> <span class="s-str">'unknown'</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">'guest'</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 >= <span class="s-str">'2026-01'</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">'2026-08'</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">'2026-08'</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'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">'2026-08'</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">'2026-08'</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">'2026-08'</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">'2026-08'</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 <> <span class="s-str">'unknown'</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">'guest'</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">'2026-08'</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">'SO372035'</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'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' 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'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 "with shipping"; 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">'2026-08'</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">'2026-08'</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 "with shipping"</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'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'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'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'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'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">"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></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">"Sum the measures freely: cancelled orders are out, so a plain sum gives Finance's trading number. Count orders and customers with count(DISTINCT ...), never by adding counts."</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">"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></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">"Open it read-only, between runs. See knowledge/connections.md."</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">"the data engineer"</span>, <span class="yk">role</span>: owner, <span class="yk">description</span>: <span class="yst">"Builds the table, answers for the data."</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">"Owns the definitions of the measures, signs them."</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">"Rebuilt by every run that succeeds. When the gold tasks are skipped, consumers read the gold of the last run that built it."</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">"The data of day D is in the table by 07:00 UTC on D+1, when D's delivery passed its gates."</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">"Every order since <span class="nw">2022-01-01</span>. Nothing is rolled off."</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">"07:00"</span>, <span class="yk">description</span>: <span class="yst">"UTC, for the Monday trading pack."</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">"one order line of an order that was not cancelled"</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">"monday_pack, finance analysts, commercial analysts, marketing analysts"</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">"One row per order line of an order that was not cancelled, with the day, the customer and the product beside it."</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">"One row per line."</span>, <span class="yk">query</span>: <span class="yst">"SELECT count(*) - count(DISTINCT line_id) FROM gold_marts.obt_order_lines"</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">"No line of a cancelled order."</span>, <span class="yk">query</span>: <span class="yst">"SELECT count(*) FROM gold_marts.obt_order_lines JOIN silver_core.orders USING (order_id) WHERE is_cancelled"</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">"The net revenue equals the fact's, for orders that were not cancelled."</span>, <span class="yk">query</span>: <span class="yst">"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)"</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">"Every line has a cost from the day it was ordered."</span>, <span class="yk">query</span>: <span class="yst">"SELECT count(*) FROM gold_marts.obt_order_lines WHERE standard_cost_eur IS NULL"</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">"The order line number, like SO372035-01. The key."</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">"The order the line belongs to. Several lines share one order."</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">"The day the order was placed, the UTC day of the checkout."</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">"The month the order was placed, like 2026-08."</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">"The year the order was placed."</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">"The shop account that ordered, or unknown for a guest checkout. An account is not always one person."</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">"Finance's customer type at placement: guest, new or returning. Set at checkout, never recalculated."</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">"The country of the customer's account, as an ISO 3166-1 alpha-2 code. Missing for a guest. Not where the order was sent."</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">"Where the account was created: web or app. Missing for a guest."</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">"True when the account belongs to a business account. Missing for a guest."</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">"The product on the line, one physical variant."</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">"The name of the product. It does not always say the colour."</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">"The brand: Kaivo, Kova, Nodo, Ondia, Pavo or Visna."</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">"The category: Phones and Tablets, Computers, Monitors, Accessories or Audio."</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">"The country the order ships to, as an ISO 3166-1 alpha-2 code. The market of the sale."</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">"Where the order was placed: web, app or marketplace."</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">"The last touch that brought the checkout, as the shop recorded it. Always marketplace on a marketplace order."</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">"The campaign window the order fell in, if any. It does not prove an offer was used."</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">"The ordered units on the line."</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">"DECIMAL(18,2)"</span>, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">"Quantity times list price, before any discount, in euros without VAT."</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">"DECIMAL(18,2)"</span>, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">"The whole discount on the line, in euros without VAT."</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">"DECIMAL(18,2)"</span>, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">"What the line is worth after the discount, in euros without VAT. Net revenue: no shipping, no refunds."</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">"DECIMAL(18,2)"</span>, <span class="yk">required</span>: <span class="yb">true</span>, <span class="yk">description</span>: <span class="yst">"Quantity times the standard cost valid on the order day, in euros."</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">"data/warehouse/newvolt.duckdb"</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">"data/warehouse/newvolt.duckdb"</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">"data/warehouse/newvolt.duckdb"</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">"data/warehouse/newvolt.duckdb"</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">"data/warehouse/newvolt.duckdb"</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">"data/warehouse/newvolt.duckdb"</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">"data/warehouse/newvolt.duckdb"</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">"data/warehouse/newvolt.duckdb"</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'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'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 <> 'unknown')</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'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">"data/warehouse/newvolt.duckdb"</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>
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| 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: 196k | Updated | Claude CodeCodex | Verified | Install |
| 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: 193k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 193k | Updated | Claude CodeCodex | Verified | Install |
| 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: 193k | Updated | Claude CodeCodex | Verified | Install |