Discover how to supercharge your dbt models using Jinja loops! This guide explores practical loop patterns for clean and DRY SQL transformations.
Hi đź‘‹ from dbt Engineer
I'm Sanjay, and here on a mission to build a thriving community of passionate data professionals who are deeply invested in mastering analytics engineering. We're proudly 2000+ members strong!
Featured
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.
If people don’t trust the work of the analytics engineering team, then all the effort you put in doesn’t matter. One of the best ways is by using test-driven development (TDD).
Unlock the power of Analytics Engineering to transform your data into actionable insights.
Explore the pros and cons of dbt monorepo vs multi-repo setups. Learn when to use each for scalable, collaborative analytics engineering workflows.
Follow a real-world journey from ETL to ELT. Learn how a modern data team overcame bottlenecks and scaled fast using cloud warehouses and dbt.
Analytics Engineers bridge the gap between raw data and business insight. This guide breaks down what they do, the tools they use (like dbt and SQL), and why they're essential to modern data teams. If you're building trusted data models, this is where you start.
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.
If people don’t trust the work of the analytics engineering team, then all the effort you put in doesn’t matter. One of the best ways is by using test-driven development (TDD).
Unlock the power of Analytics Engineering to transform your data into actionable insights.
Explore the pros and cons of dbt monorepo vs multi-repo setups. Learn when to use each for scalable, collaborative analytics engineering workflows.
Follow a real-world journey from ETL to ELT. Learn how a modern data team overcame bottlenecks and scaled fast using cloud warehouses and dbt.
Analytics Engineers bridge the gap between raw data and business insight. This guide breaks down what they do, the tools they use (like dbt and SQL), and why they're essential to modern data teams. If you're building trusted data models, this is where you start.
Latest
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.
Recommendations
Unpacking developer trends one at a time.
Subscribe to my Newsletter
Join 2000+ data engineers and developers discovering the latest in dbt and analytics engineering.