Mike Driscoll

Mike Driscoll

@medriscoll.com

Founder @ RillData.com, building GenBI. Lover of fast, flexible, beautiful data tools. Lapsed computational biologist.

3.7K followers272 following162 posts

Mike Driscoll reposted

In data analytics, we're facing a paradox. AI agents can theoretically analyze anything, but without the right foundations, they're as likely to hallucinate a metric as to calculate it correctly. They can write SQL in seconds, but will it answer the right business question?

ssp.shData Modeling for the Agentic Era: Semantics, Speed, and StewardshipMaster the three pillars of agentic data modeling: Metrics SQL for semantics, sub-second analytics for speed, and AI guardrails for trusted insights.

DuckLake is a simpler, SQL-friendlier alternative to Iceberg. “There are no Avro or JSON files. There is no additional catalog server or additional API to integrate with. It’s all just SQL.“ That said, choose your catalog database — a single-point of failure — *very carefully*.

DuckDB@duckdb.org

Today we're launching DuckLake, an integrated data lake and catalog format powered by SQL. DuckLake unlocks next-generation data warehousing where compute is local, consistency central, and storage scales till infinity. ⁠ducklake is an open standard and we implemented it in the "ducklake" extension.

Mike Driscoll reposted

View full thread

Similarly, Toby and his team at Tobiko Data have built an powerful yet elegant transformation platform -- combining SQLMesh and SQL dialect transpilation (SQLGlot) to allow portability of pipelines between databases, warehouses, and lakehouses. techcrunch.com/2024/06/05/w...

techcrunch.comWith $21.8M in funding, Tobiko aims to build a modern data platform | TechCrunchTobiko aims to reimagine how teams work with data by offering a dbt-compatible data transformation platform.
View full thread

Why am I so excited to bring this crew together on stage? It's because real-time analytical databases like ClickHouse, Apache Pinot, and MotherDuck / DuckDB are reshaping data stacks the fastest-moving engineering teams on earth -- OpenAI, DoorDash, and @stackblitz.com.

The sub-second speed-at-scale of these real-time engines enable new kinds of applications: point-of-sale fraud detection, IoT monitoring, real-time context for AI agents -- these use cases just aren't supported by traditional data warehouses like Snowflake. www.rilldata.com/blog/scaling...

rilldata.comRill | Scaling Beyond Postgres: How to Choose a Real-Time Analytical DatabaseThis blog explores how real-time databases address critical analytical requirements. We highlight the differences between cloud data warehouses like Snowflake and BigQuery, legacy OLAP databases like ...
View full thread

At @rilldata.com, we've taken the step of shifting metric layers left from BI tools and pushing them into real-time analytical databases like ClickHouse and DuckDB -- to power insanely fast exploratory dashboards. (I'll be discussing at my Data Council in two weeks). docs.google.com/presentation...

docs.google.comDuckCon 6 - A SQL-Based Metrics Layer Powered by DuckDBINTRODUCING A SQL-BASED METRICS LAYER POWERED BY DUCKDB Mike Driscoll Co-Founder, CEO at Rill Data
View full thread

Now that SQL-on-data-lake frameworks are maturing (DuckDB SQL on Iceberg, Spark SQL on DeltaLake), and transpiling between SQL dialects is possible (thanks to SQLMesh and @tobikodata.com), it's possible to shift these SQL transformations left, out of the warehouse and onto object storage.

View full thread

Data validation is a great example: an eCommerce platform might validate that order prices contain no negative numbers after its loaded into the database. "Shifting left" means moving that validation to the ingestion or even the collection step in the pipeline, before it hits the database.

Transformation logic is another use case. "Shifting left" is in some ways a reaction to the "ELT" pattern (or anti-pattern, in my opinion) that big data warehouses like Snowflake were pushing -- whereby you extract, load, and only *then* transform data in the warehouse.

Data pipelines can be visualized as flowing data left to right, starting with raw sources, ingested and modeled into database tables, and eventually served out through user-facing applications and dashboards. "Shifting left" means taking logic that lives on the right side and moving it leftward.

Apache Pinot is one of the world’s fastest and most scalable real-time analytical databases, relied on by LinkedIn, Uber, and Stripe. It was awesome diving into the secrets behind its unique architecture with creator and @startreedata.bsky.social founder Kishore Gopalakrishna.

Rill Data@rilldata.com

The past few Data Talks on the Rocks interviews have been with the creators of real-time analytical databases. For our 7th round, we decided to chat with Kishore Gopalakrishna, CEO of @startreedata.bsky.social and creator of the wildly popular database #ApachePinot. www.rilldata.com/blog/kishore...

Like others, I jumped on the bandwagon to ridicule the DOGE analyst who "overheated her hard drive" by analyzing just 60k rows of data. I was wrong. The truth is even dumber. 🧵

View full thread

Cloud data centers have climate control, and more compute power than your MacBook Air! This set up could be done by competent data engineer in less time than it took to run her query. The DOGE tech wiz acknowledged this and wrote "it hasn't been a priority to get that done."

Like others, I jumped on the bandwagon to ridicule the DOGE analyst who "overheated her hard drive" by analyzing just 60k rows of data. I was wrong. The truth is even dumber. 🧵

View full thread

But it doesn't absolve her, or her team, from ridicule. The DOGE tech wiz kids shouldn't be toting federal databases around on USB-attached external hard drives in "hot, humid hotel rooms" (her literal words): that's what database servers were invented for.

Like others, I jumped on the bandwagon to ridicule the DOGE analyst who "overheated her hard drive" by analyzing just 60k rows of data. I was wrong. The truth is even dumber. 🧵

What actually overheated was an USB external hard drive, with several terabytes of contract data, that she was reading into her MacBook Air and then filtering to find contracts matching her criteria. (High-speed reads on NVMe drives can heat up to 175 °F before thermal throttling kicks in).

Mike Driscoll reposted

Just published: Ever had to «Scale beyond Postgres»? You may have started with a simple ETL pipeline and crunched critical business logic into useful dashboards, but speed and scale didn't grow with data at some point, and it's the concurrent user. ✨ Below are some highlights from the article.

rilldata.comRill | Scaling Beyond Postgres: How to Choose a Real-Time Analytical DatabaseThis blog explores how real-time databases address critical analytical requirements. We highlight the differences between cloud data warehouses like Snowflake and BigQuery, legacy OLAP databases like ...

I'm collaborating with @ssp.sh on a brief history of pivot tables. We'll be tracing their lineage and evolution across Visicalc, Lotus, Excel, PowerPivot, Qlik, and PowerBI. Any sites, videos, products (dead or alive) that you would recommend we should mention or dig into?

Real-time user experiences make applications magical. Google, WhatsApp, and ChatGPT would all fail if you added just 10 seconds to every search, message, or prompt interaction. We are surrounded by fast user experiences and yet most of us tolerate business dashboards that take minutes to load.

Rill Data@rilldata.com

"If we think about the core offering of Rill, we focus on combining large scale data transformation, a very fast OLAP data engine, and ultimately delivering value through an interactive, *fast*, flexible dashboard. That is really the face of Rill and that was historically the face of Metamarkets.”

Mike Driscoll reposted

It took 5 minutes to create this dashboard with @rilldata.com's AI auto-generate features. Impressive @medriscoll.com!

Burak@buremba.bsky.social

Spotify is one of the few companies that lets you download your raw event logs. The dump is extensive, with around 200 event types; my dump is over 300MB. 🤯 Just enable the technical log information in the export, and here is what you get: www.spotify.com/uk/account/p...

I’ve often said working in data engineering is like working in the post office. Queues get backed up, deliveries are lost, yet the stream never stops. It’s a thankless, mostly invisible job until something goes wrong, & then it’s complaints. I hoped the analogies stopped there, but sadly maybe not.

Mike Driscoll reposted

I had the pleasure of talking with @medriscoll.com on his podcast. I love this long-form discussion, especially on a snowy day like this :) Talked about: > My journey (DE ↠ Author) > Bluesky🦋, DuckDB, S3, data modeling & declarative stacks > What do you call data people? 🎙️ youtu.be/xW_HGb46xMk

Snowflake’s pricing is a riddle wrapped in a mystery inside an enigma.

Burak@buremba.bsky.social

Also their pricing page is a huge PDF file which makes it pretty hard to understand/estimate the cost. I hated it so much that I spent a day turning it into a web app: snowflake-cost-calculator.universql.com

Nice review of the latest CSV parsing & querying capabilities of @duckdb.org. Parquet is obviously better than CSV because of its stronger types, efficient compression, and support for predicate pushdown. But given CSV is *everywhere*, these improvements are welcome. duckdb.org/2024/12/05/c...

duckdb.orgCSV Files: Dethroning Parquet as the Ultimate Storage File Format — or Not?Data analytics primarily uses two types of storage format files: human-readable text files like CSV and performance-driven binary files like Parquet. This blog post compares these two formats in an ul...

Amazon S3 continues to unleash waves of disruption for data infrastructure. S3 Tables, their managed Iceberg offering, is the latest. What began as commoditization of storage now moves up the stack to swallow cloud warehouses whole. With S3 Tables, what sane person would do ELT in Snowflake?

In 2003, Jeff Bezos banned Powerpoint from Amazon meetings, insisting managers craft memos, not fancy bullet points. Today, too many dashboards are Powerpoint decks but for data: overly styled visuals better conveyed by a table of metrics. (Ironically, QuickSight dashboards are among the worst).

Mike Driscoll reposted

As an engineer, if I've built something once, the chance to do it again is a gift. That's my theory for 🦋 (and the AT protocol) is succeeding technically. In an existing company, rewrites rarely happen - long-term benefit cannot outweigh short-term cost.

ICYMI I recently interviewed the creator of @clickhouse.com, Alexey Milovidov. We dove deep into what ClickHouse is so fast, why AI companies love it (hint: its had a vector data type since 2012), rewriting Zookeeper (yikes), and how math informs database design. www.rilldata.com/blog/rill-cl...

rilldata.comRill | Data Talks on the Rocks 4 - Alexey Milovidov, ClickHouseA video interview with Alexey Milovidov, co-founder and CTO of ClickHouse, that dives deep into AI, ClickHouse’s architecture, different database categories, and pain points in the market that ClickHo...