-
dbt MCP Server: Complete Setup Guide
Connect dbt to Claude Desktop or Claude Code via MCP. Query models, metrics, lineage, and run dbt commands through conversation.
-
MCP Protocol Fundamentals: What Data Engineers Need to Know
Learn MCP architecture, core primitives, and the security model. Essential foundation for connecting AI assistants to your data infrastructure.
-
Understanding the terminal: A complete guide for Claude Code beginners
Learn essential terminal commands and how Claude Code uses them. A practical guide for beginners who want to understand what's happening behind the scenes.
-
GA4 + dbt: A Production-Ready Project Template
A complete dbt project template for GA4 BigQuery exports with incremental processing, sessionized event tables, testing patterns, and documentation.
-
GA4 User Stitching: Handling Anonymous to Known Users
Build identity resolution pipelines in BigQuery to stitch anonymous GA4 users to authenticated identities across devices and sessions, with production dbt patterns.
-
Building Session Tables from GA4 Event Data
Learn to sessionize GA4 BigQuery exports by building enriched event tables with session identity, attribution, and sequence position using window functions.
-
Unnesting GA4 Events: Patterns for Every Use Case
Production-ready SQL patterns for extracting GA4 data from nested arrays in BigQuery, covering e-commerce, engagement events, and dbt model templates.
-
GA4 BigQuery Export: The Complete Schema Reference
A practical field guide to GA4's BigQuery export schema covering nested structures, traffic source fields, critical gotchas, and efficient query patterns.
-
10 BigQuery SQL Patterns Every Analytics Engineer Should Know
Production-ready BigQuery patterns for partitioning, materialized views, HLL sketches, nested data, window functions, dbt incrementals, and attribution.
-
On-Demand vs. Editions Pricing: When to Switch
A practical guide to choosing between BigQuery On-Demand and Editions pricing models, with SQL queries to analyze your workload and calculate breakeven points.
-
BigQuery Slots and Reservations Explained
Learn how BigQuery slots work, understand the reservation hierarchy, compare Editions pricing tiers, and optimize slot usage for your dbt workflows.
-
Partitioning vs. Clustering: The Decision Framework
A practical decision framework for choosing between BigQuery partitioning and clustering based on query patterns, table sizes, and dbt incremental strategies.
-
BigQuery Architecture for Analytics Engineers: The Complete Guide
Learn BigQuery's resource hierarchy, regional constraints, multi-environment patterns, and IAM configuration to design scalable analytics systems.
-
dbt-expectations: The Package Every Project Needs
Learn how dbt-expectations adds 50+ data quality tests to your dbt project: pattern matching, freshness checks, statistical validation, and more.
-
Unit Testing vs. Data Testing: When to Use Each
A decision framework for choosing between dbt unit tests, data tests, dbt-expectations, Elementary, and dbt-audit-helper based on what you're testing.
-
Unit Testing dbt Models: Real-World Examples and Patterns
Copy-paste patterns for unit testing incremental models, snapshots, window functions, GA4 sessionization, and attribution models in dbt with BigQuery.
-
Unit Testing in dbt 1.8+: Complete Implementation Guide
Learn to implement dbt unit tests from scratch. Covers YAML syntax, BigQuery-specific workarounds for STRUCTs and ARRAYs, mocking dependencies, and CI/CD integration.
-
dbt Testing Strategy: A Framework for Every Project
A practical framework for dbt testing that scales from first projects to enterprise pipelines, covering data tests, unit tests, contracts, and packages.
-
BigQuery Cost Optimization: The 80/20 Guide
Cut BigQuery costs by focusing on partitioning, clustering, and column selection. Includes dbt configs, INFORMATION_SCHEMA queries, and governance guardrails.
-
Your First GA4 dbt Models: From Raw Events to Sessions
Build event-level GA4 dbt models that preserve granularity. Learn the session key trap, nested event_params extraction, and a three-layer pattern for flexible analytics.
-
Base, Intermediate, Marts: When to Use Each Layer
Learn when to use base, intermediate, and mart layers in dbt. Clear rules for where joins, business logic, and aggregations belong in your transformation project.
-
dbt Project Structure: The Definitive Guide
A complete guide to dbt project structure: three-layer architecture, entity naming, table materialization, and marketing analytics examples.
-
Connecting Claude Code to Your Data Warehouse (And Why You Might Not Need MCP)
Cloudflare and Anthropic discovered LLMs write better code than tool calls. For BigQuery users, that means CLI might beat MCP. Here's the evidence for it.
-
Advanced Claude Code Workflows: Testing, Documentation, and Debugging for Analytics Engineers
Three production-ready workflows for testing, documentation, and debugging that turn Claude Code into an integrated part of your analytics engineering process.
-
Automating the Boring Parts: Hooks and Custom Commands for Analytics Engineers
Learn how to use Claude Code hooks and custom slash commands to automate dbt workflows — from auto-formatting SQL to blocking dangerous production commands.
-
Claude Code - Skills vs. Commands
Skills activate automatically only 20% of the time. For repeatable data workflows like dbt audits and lineage docs, commands give you the consistency you need.
-
How to set up CLAUDE.md for your dbt project (and actually make it useful)
Learn how to configure CLAUDE.md for dbt projects. Practical tips for naming conventions, BigQuery gotchas, and keeping it minimal.
-
How I Use Claude Code for dbt Development
Practical guide to using Claude Code with dbt. From base model generation to refactoring: what actually works in day-to-day analytics engineering.
-
Claude Code for Data People: What It Is and Why You Should Care
70% of analytics engineers use AI for coding. Meet Claude Code, the agentic tool that reads your dbt codebase and writes code based on your patterns.
-
Your First Hour with Claude Code as an Analytics Engineer
Install and master Claude Code in one hour. Practical guide for analytics engineers: setup, authentication, first dbt models, and essential tips to get started.
-
n8n RSS to Notion
Transform your RSS feeds into an automated knowledge base with n8n and ChatGPT. No more manual cleanup: fetch and organize articles in Notion effortlessly.
-
Deploying dbt core on Google Cloud Function
Let's look at how to deploy dbt Core on a Google Cloud Function.
-
How to Pass the dbt Certification
Here is my experience passing the dbt developer certification.
-
dbt core vs dbt cloud
Let's look at the differences between dbt Core and dbt Cloud.
-
Loading Data Made Simple: A Hands-on Guide to dlt
Learn how to build data pipelines with dlt (data load tool). From basic API extraction to incremental loading: a practical tutorial using the GitHub API.
Adrienne Vermorel
Articles
Tools & Platforms
Topics
Format