As a Data Engineer, I collect, extract and transform raw data in order to provide clean, reliable and usable data.
📘 Introduction The dbt Analytics Engineering Certification Exam can be challenging—but with the right preparation strategy, you can pass with confidence. This guide brings together the best official resources and practical tutorials to help you stay focused, study smarter, and succeed. 📋1️⃣ Read the official dbt Study Guide Begin with...
📘 Introduction dbt gives you the power to transform raw data into clean, trusted models. But writing SQL is just the starting point. To truly get value from dbt, you need practices that keep your code organized, your models reliable, and your team moving fast. Whether you're a beginner...
📘Introduction Once you've created models in dbt, you can reference them using the ref() function. This is fundamental to how dbt builds dependencies and orchestrates model execution. In this hands-on tutorial, we’ll show you how to use the ref()function within a sample project. 📌 This is a...
📘Introduction In this step-by-step tutorial, we’ll walk you through how to install and use packages in dbt to supercharge your data transformations with reusable macros, models, and integrations. 📌 This is a must-know topic for the dbt Analytics Engineering Certification Exam, so mastering it now puts you one step closer...
📘Introduction If you're new to dbt (data build tool) and want to transform raw data into clean, analytics-ready tables using Python, you're in the right place. In this step-by-step tutorial, we’ll walk you through how to build your first Python model in dbt, step by...
📘Introduction If you're new to dbt (data build tool) and want to transform raw data into clean, analytics-ready tables — you're in the right place. In this step-by-step tutorial, we’ll walk you through how to build your first SQL model in dbt, step by step. 📌 This...
📘Introduction FastAPI is a modern, high-performance web framework for building APIs with Python. In real-world applications, you'll often need to connect to a relational database like PostgreSQL to store and retrieve data. But building that connection securely and cleanly—especially across development, staging, and production environments—requires a...
Introduction In the age of data-driven decision making, having a powerful data architecture is crucial. The Medallion Architecture is a proven data architecture pattern that helps in organizing data across different layers of refinement. When combined with dbt (data build tool), it becomes a powerful and scalable way to manage...
Introduction Keeping the data fresh in your data warehouse is crucial. In dbt (data build tool), source freshness checks help ensure that the data coming from your sources is up-to-date and trustworthy, enabling teams to confidently build reliable models downstream. This is where defining source freshness in the sources.yml...