Snowflake Postgres Delivers More Headroom for High-Throughput Workloads vs. Databricks Lakebase

William McKnight and Jake Dolezal TL;DR: Executive Overview This benchmark report evaluates the transactional throughput and scalability of Snowflake Postgres (configured on HIGHMEM_4XL compute) against Databricks Lakebase (configured on 64 CU compute) under simulated enterprise operational load using the HammerDB TPROC-C workload, an OLTP workload derived from the TPC-C specification. The quantitative findings demonstrate a…

Read More

Counting Distincts and High Cardinality Aggregations: Designing Snowflake for Interactive Analytics

William McKnight and Jake Dolezal TL;DR: When an analytics dashboard shows a broken tile instead of a number, someone in the business makes a worse decision or no decision at all. High-cardinality queries, like counting unique sessions or visitors, are one of the most common reasons interactive dashboards fail under load. This post tests whether…

Read More

Stop the Token Bleed: Benchmarking the Benefits of Governed Metadata for Enterprise AI

Informatica, a Salesforce company, provides the governed metadata foundation critical to stopping “token bleed”—the soaring costs, latency, and context bloat caused by feeding raw, uncurated enterprise data into LLMs. Jake Dolezal and William McKnight McKnight Consulting GroupAugust 2026 In brief Our methodology compares token consumption and accuracy for identical AI requests across 15 million objects…

Read More

The Architect’s Blueprint: The 5 Pillars of Enterprise Data Strategy

In the enterprise world, there is often a massive disconnect between the technical realities of data engineering and the bottom-line expectations of the C-suite. Bridging that gap isn’t just about understanding the technology; it’s about translating complex infrastructure into real-world business value. Over years of analyzing benchmark reports and steering enterprise projects, I’ve found that…

Read More

The Architect’s Blueprint: Data Architecture Strategies for Sustainable Business ROI

Data architecture is ultimately about driving real business outcomes, not just implementing new technology. In over 17 years of consulting at McKnight Consulting Group, we have helped hundreds of enterprises navigate their most complex data challenges. The biggest successes always come when we align technical data strategies with clear business goals. Here are three real-world challenges…

Read More