Writings

Discover how to supercharge your dbt models using Jinja loops! This guide explores practical loop patterns for clean and DRY SQL transformations.

Struggling with "maximum recursion depth exceeded" in dbt macros? This article explains why it happens—usually due to missing or misused variables—and shows simple, beginner-friendly steps to fix it, ensuring your dbt projects run smoothly and error-free.

Learn how to standardise logging in dbt macros for clear, consistent CLI output. This guide shows you how to create a reusable logging macro, making debugging and tracking macro activity in your dbt projects easier and more efficient.

Automate PII tagging in your dbt project using OpenAI! Streamline data governance, ensure compliance, and save time by leveraging AI to detect and flag sensitive information in your data models. Integrate this workflow into CI/CD for robust, scalable data protection.

dbt Exposures let you document and track how your data models are used in dashboards, reports, and applications. By defining exposures, you gain complete data lineage, improve change management, and enhance documentation for all downstream data consumers.

Learn how to run dbt pipelines with Apache Airflow and Docker. This guide covers setup, code examples, and best practices to help you automate, schedule, and scale your data workflows efficiently—perfect for data engineers seeking robust pipeline orchestration.