Skip to content
therohityadav.com
BlogAbout

© 2026 Rohit Yadav

Writing

Blog

Thoughts on Data, AI, and building products.

All writing (10)

01
Oct 30, 2026·7 min read

Building Data Agents on Databricks: From Generated SQL to Governed Tools

A few months ago, I was building a data investigation agent. The architecture felt straightforward: build an internal application, connect it to an LLM, and give it access to Databricks through a service princi…

AI ArchitectureApplied AIData Engineering
02
Jun 21, 2026·4 min read

The Two Gaps Behind Almost Every Bad AI Output

An LLM rarely disappoints because it cannot think. It disappoints because of what we forgot to place in front of it. The model is only ever as good as the world we hand it, and when the output arrives malformed…

Applied AI
03
Jun 11, 2026·5 min read

The AI Bubble and the Railroad

Every few decades, the world convinces itself that a new technology will change everything. And the curious part is that the world is usually right. The railways changed everything. The internet changed everyth…

Opinion
04
Jun 4, 2026·5 min read

The Case Against Giving Your AI Agents Job Titles

When an agent fails, we blame its intelligence. The real constraint is quieter: not whether it can reason, but whether it has the room to.

AI Architecture
05
Jun 4, 2026·6 min read

Building Support Agent without a vector database

I built Support Agent on a thousand support tickets without a vector database. At this scale, brute-force cosine similarity in numpy is faster, simpler, and exact. Here is why the absence is a feature.

AI Architecture
06
May 30, 2026·6 min read

When one write becomes two: the transactional outbox pattern

Place an order, then publish the event. Two lines of code, one silent data-corruption bug. How the transactional outbox pattern closes the gap between what your database commits and what the rest of the system…

Backend EngineeringDistributed Systems
07
May 22, 2026·6 min read

SQLAlchemy and Alembic

You launch with three columns. Six months later, the schema has been altered a dozen times by three different engineers across four environments, and nobody can describe with confidence what the production data…

Backend Engineering
08
May 6, 2026·11 min read

Monitoring a DLT Pipeline with Datadog on Databricks Free Edition

Why the built-in Datadog integration falls short on serverless, and how custom DLT hooks plus Terraform-managed monitor fill the gap.

Data Engineering
09
May 3, 2026·9 min read

What I Learned Building a Smart Grid Pipeline on Databricks Free Edition

I built a smart grid meter pipeline on Databricks Free Edition with medallion architecture, DQX validation, SCD modeling, and Terraform IaC. Here is what worked, what broke, and what I learned.

Data Engineering
10
Apr 12, 2026·4 min read

Why You Need an AI Harness?

Think the LLM is the final product? Think again. Raw models are powerful but unpredictable. Like a horse without a harness. Learn why a well-engineered AI harness is the secret to turning non-deterministic mode…

AI Architecture