Economics & organization
Why modern data stacks haven't replaced SIEMs.
The technical argument for storing security data in an open lakehouse (better compression, lower cost per terabyte, query engines you can swap) has been settled for a few years now. And yet the SIEM is still there in most enterprise security operations centers, still ingesting, still billed by the gigabyte. The interesting question isn't whether the modern stack is technically better, because it usually is. The interesting question is why being better hasn't been enough, and the honest answer is that the barrier was never really technical.
Reading time: about 12 minutes. Evidence tier: B (practitioner experience and published migration case studies), with several figures flagged as my own directional estimates rather than measured results. Where a number is mine, I say so.
The gap to explain
Technical merit is not the constraint.
I want to set the cost argument aside deliberately, because it's well-trodden ground and I've made it at length elsewhere. The cost optimization paradox walks through why ingest-priced security data gets expensive in a particular way; the cost-to-serve at retention scale essay shows the index paying twice as data ages; and the write-endurance piece covers the storage-economics angle. If you want the dollars-and-terabytes case, those carry it. This essay is about something the cost math can't explain on its own, which is that even when the numbers clearly favor the move, the move mostly doesn't happen.
The case studies that get cited in these conversations are real. Huntress, running roughly three million endpoints, moved off Elasticsearch to ClickHouse and cut its bill by more than 90%; the dollar figures and the sourcing live on the Huntress teardown. The open table format underneath has corporate stewardship from Netflix, Apple, AWS, Snowflake and Databricks, so this isn't a fragile science project anymore. The technology is there. The reliability is there. And still, in most security organizations I've worked with, the SIEM stays.
So the explanation has to live somewhere other than the technology, and I think it lives in four organizational barriers that a benchmark never measures. None of them is irrational. Taken together they describe a security team weighing the risk of a transition against the risk of staying put, and frequently deciding, correctly given what they're accountable for, that staying put is the safer bet this quarter.
Barrier one
Risk aversion, and who carries the blame.
The line I've heard, in some form, from more than one security leader is that you can get fired for choosing the wrong vendor but you don't get fired for choosing Splunk. It's a glib formulation of a serious calculation. A security team's downside from a platform decision is asymmetric: a smooth migration earns a line item in next year's budget review, while a botched one that drops detections during a breach window is a career event. When the penalty for being wrong is that lopsided, the rational move is to minimize the chance of being visibly, personally wrong, and a name-brand commercial SIEM with a support contract and an SLA is the answer that minimizes it.
The objection that open-source security infrastructure now has serious corporate backing is true and doesn't actually resolve the fear, because the fear isn't really about whether Apache Iceberg is maintained. It's about who you call at 2 a.m. when ingestion stalls during an incident. "Open source" and "no one to call when it breaks" get collapsed into the same thing in a lot of security orgs, and the answer to that worry is an accountable operator, not a GitHub stars count. This is the same accountability gap I've written about under the repatriation case, where an open architecture is only buyable when someone owns the pager.
Behavioral economics has a name for the underlying pull. Samuelson and Zeckhauser's 1988 work on status-quo bias showed that decision-makers prefer the familiar option even when an alternative is objectively better, and the effect strengthens exactly when the stakes and the ambiguity are both high, which describes a SIEM migration precisely. I'll come back to that bias as its own barrier, but it's worth flagging here that the risk aversion isn't a personality flaw in security leaders. It's the predictable output of an incentive structure that punishes visible error far more than it rewards quiet efficiency.
Barrier two
The skills gap is really a timeline mismatch.
The second barrier gets described as a skills gap, and there is a genuine retraining problem in moving analysts from a proprietary search language to SQL against open tables. But framing it as a skills problem understates it, because the harder issue is that the three clocks involved run at different speeds. The technical payback on a platform migration tends to arrive over a year or more. Genuine team proficiency on the new tools takes the better part of a year to build. And management's patience for a transition that is visibly costing effort without yet showing results runs out a good deal sooner than either.
That ordering is the trap. A team can be doing everything right and still hit a stretch where the new stack isn't yet faster for them and the old one is being neglected, and that's exactly when an impatient stakeholder asks why detections feel slower than they did six months ago. The honest answer is that the team is mid-climb, but mid-climb is hard to defend in a status meeting.
What makes this worse for security specifically is that you can't pause operations to retrain. The SOC runs 24/7 whether or not the platform is in flux, so the team is learning a new query model while still carrying the full alert load on the old one. That double-duty period is where a lot of migrations quietly stall, not because the destination was wrong but because nobody budgeted for the friction of running two worlds at once.
Barrier three
The migration itself is the cost.
The third barrier is the one buyers underestimate most, which is the sheer surface area of what has to be rebuilt to move off a mature SIEM. A SIEM that's been in place for years isn't just a data store; it's an accumulation of correlation rules, dashboards, scheduled reports, compliance attestations, and analyst muscle memory, all of which assume the SIEM's specific schema and query language. Moving the data is the easy part. Moving everything that was built on top of the data is where the project lives or dies.
From the migrations I've seen and the architects I've interviewed, a mid-sized enterprise typically carries somewhere in the range of fifty to a couple hundred correlation rules and a few dozen dashboards, with the larger and more regulated organizations sitting at the top of that band. I want to be clear that those are my directional estimates rather than a measured census, since they scale with organization size and regulatory load, and a compliance-heavy shop in finance or healthcare can run well above the range. Whatever the exact count, every one of those rules has to be re-expressed against the new query model, re-tuned for false positives, and re-validated before anyone trusts it in production. That's detection-engineering work, not a data-pipeline task, and it's slow because getting a detection subtly wrong is worse than not having it.
Underneath the rules sits a legal question most architecture conversations skip, which is evidence preservation. Security logs are sometimes the record of record in a legal or regulatory matter, and a schema transformation that normalizes fields into OCSF is, from a chain-of-custody standpoint, a transformation of evidence. Some organizations resolve this by keeping the raw originals alongside the normalized copies, which protects the legal position but reintroduces the duplication the migration was supposed to eliminate. Others get legal counsel to sign off on a normalized-only approach. Either way it's a gate that has nothing to do with whether the new engine is faster, and it can hold a migration for a quarter while the lawyers and the architects reconcile.
The practical consequence of all this rebuild surface is that the migration cost is front-loaded and the savings are back-loaded, which is the worst possible shape for a project that has to survive quarterly scrutiny. The team pays the full rebuild bill up front, in detection-engineering hours and legal review and dual operation, and only starts collecting the cost savings once the old system can be switched off, and the old system can't be switched off until every rule has been ported and trusted. I worked through one version of that port problem in detail in migrating 800 detection rules, and the lesson there generalizes: the rules, not the bytes, are the migration.
Barrier four
Known problems feel safer than unknown ones.
The fourth barrier is the quietest, because it doesn't show up in any budget line. A team that has run the same SIEM for years has internalized its failure modes. They know which queries are slow and have learned to work around them, they know the dashboards that lie and the ones they trust, and they know who to escalate to when a particular ingest path falls over. Those known problems feel manageable precisely because they're known, even when an outside observer would call the platform objectively worse than the alternative. Familiar pain is legible; unfamiliar pain is frightening, and a migration trades the first kind for the second.
This is where the sunk-cost reasoning compounds the status-quo bias. Years of investment, a roster of certified analysts, and a body of institutional knowledge about the current system all weigh on the side of staying, and prospect theory explains why they weigh so heavily: Kahneman and Tversky's work shows that a potential loss looms larger psychologically than an equivalent gain, so the risk of the migration going wrong feels bigger than the cost savings it would unlock, even when the expected values say otherwise. A pure total-cost-of-ownership spreadsheet doesn't move a team across that gap, because the gap isn't arithmetic.
I want to resist the temptation to treat this as the irrational barrier, the one where the team is finally just being stubborn. It isn't. A team that deeply understands its current system's weaknesses genuinely is better-positioned to keep the lights on than a team that has just inherited a new system's unknown ones, at least for some transition window. The bias toward the known is a real and temporary operational advantage, and pretending otherwise is how migration pitches lose credibility with the people who'd actually have to run the result.
The rational actor
The team defending the SIEM is not the laggard in the story.
Stack the four barriers and a picture emerges that's different from the one the modern-data-stack pitch usually paints. The security team that keeps the SIEM isn't behind the curve or resistant to good engineering. It's a group of people optimizing a real objective function under real constraints, where the objective is keeping detections reliable through a transition that, done badly, exposes the organization during the exact window when it's most distracted. Read that way, the persistence of the SIEM stops being a puzzle about ignorance and becomes a straightforward consequence of how the risk is distributed.
This reframing matters because it changes what a credible migration argument has to do. If you believe the security team is simply uninformed, you sell harder on the cost savings and the benchmark numbers, and you lose, because you're answering a question they didn't ask. If you accept that they're rational actors managing legitimate operational risk, you stop arguing about whether the destination is better and start de-risking the journey, which is the only thing that was ever actually in dispute. The whole manageability thesis sits here: a security data architecture wins adoption not by topping a performance chart but by being something a real team can move to without betting the SOC on the transition going smoothly.
What actually moves it
Forcing functions and fallbacks.
If the barriers are organizational, the things that overcome them are organizational too, and in practice they fall into a few recognizable shapes. The most common is a forcing function that takes the decision out of the team's hands. A budget shock, where the SIEM renewal lands at a number nobody will approve, converts an optional migration into a required one; Huntress's move off Elasticsearch followed exactly that pattern of costs reaching a level that forced the question. A compliance deadline can do the same, as can an executive mandate that simply decides the direction and removes the career-risk asymmetry from the team carrying it out, because once leadership owns the choice the individual architect is no longer the one who gets fired for it.
The greenfield case is the cleanest of all, because there's nothing to migrate. A new organization, a new business unit, or a security team standing up a function for the first time can adopt an open stack from inception and never pay the rebuild cost, which is why so many of the convincing modern-stack stories come from teams that never had a legacy SIEM to defend in the first place. The barriers I've described are barriers to migration specifically; they mostly evaporate when there's no incumbent.
For everyone else, the large majority with an entrenched SIEM, the move that addresses the most barriers at once is running both systems in parallel for a transition period rather than attempting a cutover. Parallel operation directly answers the risk aversion, because the old system stays live as a fallback the entire time; it answers the timeline mismatch, because analysts keep their familiar tools while the new stack is built up beside them and skills transfer gradually instead of overnight; and it lets the rule-rebuild happen incrementally, one detection at a time, validated against the incumbent's output before anyone trusts it alone. The cost of parallel running is that you're paying for two systems during the overlap, which is real and which is why the forcing function usually has to come first, but it converts a terrifying one-shot bet into a sequence of reversible steps, and reversibility is what a rational, risk-averse team needs before it will move at all.
None of this requires solving all four barriers simultaneously, which is the mistake most migration plans make. The workable path starts narrow, with one high-volume, low-detection data source where the cost savings are obvious and the detection risk is low, often something like DNS or proxy logs, and proves the model there before expanding. Validate the savings, validate the workflow fit, let the team build confidence on a corner of the problem where being wrong is cheap, and then widen. The barriers don't fall to a better argument; they fall to a smaller, reversible first step that makes the next one easier to take.
Why now is at least different
The barriers are eroding, slowly and unevenly.
I don't want to claim the SIEM's days are numbered, because I've watched that prediction fail enough times to be wary of it. But several of the specific barriers are genuinely lower than they were a few years ago, and it's worth being precise about which ones and why. The risk-aversion barrier softens when commercial backing shows up behind the open standards: a managed Iceberg service from a hyperscaler gives a risk-averse buyer the support contract and the someone-to-call that the bare open-source project couldn't, which addresses the fear directly rather than dismissing it.
The skills barrier narrows for a simpler reason, which is that SQL is more widely known than any proprietary SIEM query language, so a stack built on SQL against open tables is starting from a larger pool of existing skill than the one it replaces. The migration barrier is the one where the tooling has improved most: rule translation that used to be entirely manual now has machine assistance, and the normalization target itself has stabilized, with OCSF mature enough to plan against rather than chase. None of that makes the rebuild free, but it lowers the height of the wall.
The status-quo barrier is the stickiest and will be the last to fall, because it's psychological rather than technical and no amount of tooling touches it directly. What erodes it is accumulated proof, since every credible production migration that runs clean for a year makes the next team's leap feel a little less like a leap, until at some point the known pain of the old system stops feeling safer than the increasingly-well-understood pain of the new one. That's a slow process, and it's why I'd describe the current moment as the barriers eroding rather than falling. The teams that haven't moved still mostly have good reasons, and the right response to a good reason is to lower the barrier it names, not to argue that the reason was never valid.
Conclusion
Organizational change outweighs technical merit.
The modern data stack has won the technical argument for security data and is still losing the adoption argument in most enterprises, and the reconciliation of those two facts is that adoption was never decided on technical merit. It's decided on risk, timeline, rebuild cost, and the very human preference for a problem you understand over one you don't. The teams that keep the SIEM are doing something defensible inside their constraints, and a migration argument that treats them as laggards is arguing with the wrong premise.
What that means for anyone trying to make the case is that the work, with the destination mostly settled, is lowering each of the four barriers to getting there: giving the risk-averse buyer an accountable operator, giving the team a parallel path that keeps their fallback live, breaking the rule-rebuild into reversible increments, and accumulating the production proof that slowly drains the status-quo bias of its force. The cost case, which I've made at length elsewhere, is necessary and nowhere near sufficient.
The honest summary is that this is a story about organizations, not about engines. The benchmark was always going to be won by the open stack eventually. Whether and when a given security team adopts it turns on whether the transition can be made manageable enough that a rational person, accountable for keeping the detections running, is willing to take the first reversible step.
Sources & evidence
- Huntress migration off Elasticsearch to ClickHouse (a reported >90% cost reduction: $70K to $5K a month, ~93% by arithmetic, across ~3M endpoints): see the Huntress teardown for the dollar figures and primary sources. Evidence tier B (published vendor case study and conference talk).
- Status-quo bias: Samuelson & Zeckhauser, "Status Quo Bias in Decision Making" (1988). Loss aversion / prospect theory: Kahneman & Tversky, and Kahneman, Thinking, Fast and Slow (2011). Evidence tier A (peer-reviewed foundational research).
- Migration timeline windows (12–18mo payback / 6–12mo proficiency / 3–6mo patience) and rule-and-dashboard counts (≈50–200 rules, ≈20–50 dashboards): directional estimates from my own practitioner interviews and migration experience, not measured results, and sensitive to organization size and regulatory load. Evidence tier B, flagged as author-modeled.
- The "10–50× pipeline rework" multiplier and the ≈10–20 TB/day Elasticsearch query-latency figure are author-modeled estimates with validation still owed; not asserted here as measured. Treated as directional only.
- Cost mechanics are covered separately in the cost optimization paradox, cost-to-serve at retention scale, and the write-endurance essay. This essay deliberately does not re-derive them.