MCKNIGHT CONSULTING GROUP BLOG
Snowflake’s Interoperable Stack versus Databricks’ Unity Catalog Lock In
Jake Dolezal and William McKnight TL;DR: Your data is stored as Apache Iceberg tables in AWS Glue. A Spark job enriches them overnight, Amazon Athena serves the ad-hoc questions, and the analytics team wants either Snowflake or Databricks to work on the same tables. Use the same data in place with no ETL, with any…
Read MoreSnowflake 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 MoreWindow Functions at Interactive Latency: Year-over-Year Sales on Snowflake and ClickHouse
William McKnight and Jake Dolezal TL;DR: It is the second week of December and the merchandising team, regional managers, and finance are all over the holiday dashboard. How is this December tracking against last December? Which customers are spending more than they did a year ago? What does the cumulative revenue curve look like? Is…
Read MoreMemory Management and Query Density: Designing Snowflake for Interactive Analytics
William McKnight and Jake Dolezal TL;DR: A team from another department asks, “Can we be given access to your dashboard?” It is a reasonable request with an uncomfortable answer. Currently, the dashboard works well. It is eight tiles, most of them a variation on “how many distinct customers, orders, sessions or trades in the last…
Read MoreAuto-Scaling for Spiky Workloads: Designing Snowflake for Interactive Analytics
William McKnight and Jake Dolezal TL;DR: It is a Friday evening and a flash sale goes viral, and the dashboard behind real-time inventory, fraud monitoring, and marketing attribution suddenly takes five times its normal query traffic. Twenty minutes later the sale cools off and traffic drifts back to normal. The questions that matter are as…
Read MoreCounting 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 MoreWhen Everyone Asks at Once: Designing Snowflake for Interactive Analytics
William McKnight and Jake Dolezal TL;DR: Picture stock trading activity at a brokerage on a busy morning. Every trade the firm handles is landing in one big table, continuously, all day with: None of the queries are complex. Most of them are basic – count the flagged trades, total the volume per account, rank the…
Read MoreStop 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 MoreThe 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 MoreThe 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