-
The Hidden Architecture Behind Snowflake Time Travel: Why It’s Not Really a Backup Feature
TL;DR → Time Travel is not a backup — it’s a versioned metadata pointer to immutable micro-partitions you already paid to store→ Snowflake never overwrites data in place. Every UPDATE or DELETE creates new micro-partitions and marks old ones as expired→ Standard edition gives you 1 day. Enterprise gives up to 90 days — but…
-
Snowflake CoCo Desktop — What It Is, How It Works, and Whether It’s Worth It
Snowflake just announced a lot at Summit 2026. Most of it was the usual conference noise. CoCo Desktop isn’t. I’ve been following Cortex Code — now officially rebranded as CoCo — since it first shipped in Snowsight. The Summit 2026 announcement on June 2 changed the scope significantly. A native desktop IDE, Cloud Agents that…
-
Airflow vs Prefect: 2026 Comparison Guide
I evaluated Prefect seriously. Ran it in a staging environment for six weeks. Built three real flows. Had the internal conversation about migrating. And then stayed with Airflow. That was eighteen months ago. Some of that decision was right. Some of it I’d make differently today — especially now that Airflow 3.0 is out and…
-
Delta Lake vs Apache Iceberg — Why I Chose Iceberg for Our Data Lakehouse
TL;DR→ Delta Lake is easier to start with, especially if you’re already on Databricks→ Iceberg wins on engine flexibility — works natively with Spark, Flink, Trino, Snowflake, and more without custom connectors→ Delta Lake’s vendor coupling with Databricks is a real cost if you’re multi-cloud or multi-engine→ Iceberg’s partition evolution lets you change partition schemes…
-
The Problem with Data Engineering Certifications That Nobody Talks About
I passed the SnowPro Gen AI certification not too long ago. Within the same week I was back at my desk staring at a broken pipeline that no multiple-choice question had ever prepared me for. The cert looked great on my profile. It fixed exactly nothing about the actual problem in front of me. I’m…
-
The Problem with Zero-Copy Cloning in Snowflake That Nobody Talks About
Every time I demo Snowflake to someone new, zero-copy cloning gets the biggest reaction. You type one line. You get an instant copy of a table — or an entire database — with no data duplication, no storage cost at the moment of creation. It feels like magic. And it is genuinely impressive engineering. I’m…
-
Claude Code Power User Guide: Stop Using It Like Autocomplete
Most developers are using Claude Code like a fancy autocomplete. Paste a bug, get a fix, repeat — never building on anything. This guide covers everything that separates that from actually using it: CLAUDE.md setup, plan mode, path-specific rules, CI/CD integration, and the workflow habits that compound over time. TL;DR I want to tell you…
-
How to Query Snowflake in DuckDB (And Cut Your Bill While Doing It)
Three practical methods to query Snowflake data in DuckDB — via Iceberg tables, ADBC, or a hybrid architecture — with real cost breakdowns showing 70–90% savings on BI and dev workloads.
-
The Problem with dbt Tests Nobody Talks About — They Pass and You Still Ship Bad Data
I’ve been running dbt in production for a while now. And I’ll be honest — there was a phase where I genuinely believed that if my dbt tests were green, I was good. Green means clean, right? Wrong. This is the quiet failure mode that nobody in the dbt community writes about loudly enough. Your…
-
It’s Not AI You Should Worry About—It’s Automation
I still remember the afternoon I burned four hours debugging a production pipeline — convinced the problem was in the model logic — only to find the real culprit was a manual data prep step where someone had quietly introduced a column name inconsistency. No alerts. No schema validation. Just silent failure downstream. That incident…
