-
How the Warehouse Cache Actually Works in Snowflake
A dashboard that ran in four seconds on Monday took nineteen seconds on Tuesday. Same query, same data, same warehouse size. I spent the better part of an hour convinced Snowflake was having a bad day, checking the status page, refreshing query history, muttering about “platform issues” in our team Slack — before I noticed…
-
Everyone Said SQL Was Dead. It’s Now the Most Valuable Skill in AI (2026)
In 2018, a wave of Medium posts declared SQL obsolete. NoSQL was the future. Python would handle everything. Data lakes would make relational thinking irrelevant. The hot take had a good run. Then AI happened — and SQL came back harder than ever. Today, SQL is the connective tissue of every serious AI data stack.…
-
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: Comparison Guide
I evaluated Prefect seriously. I ran it in a staging environment for six weeks, built three real flows, and had the internal conversation about migrating. Then we stayed with Airflow. That was eighteen months ago. Some of that decision was right. Some of it I would make differently today, especially now that Airflow 3.0 is…
-
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 use Claude Code like a fancy autocomplete: paste a bug, get a fix, repeat, never building on anything. This guide is for developers who already use Claude Code and want more from it. It covers CLAUDE.md setup, plan mode, slash commands, skills, path-specific rules, CI/CD integration, and the daily habits that build on…
-
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.
