📘 Introduction In this hands-on dbt tutorial, you’ll learn how to use Jinja variables inside your dbt models to make your SQL code more dynamic, flexible, and reusable. Instead of hardcoding values directly into your SQL logic, Jinja allows you to define variables that can be adjusted at runtime or...
📘 Introduction Streamlit makes it easy to build interactive apps — and its st.data_editor() widget lets users edit data directly inside your app. But what if a single cell needs multiple selections, like tags, skills, or categories? 🤔 That’s where st.column_config.MultiselectColumn comes in! It allows you to...
📘 Introduction In this hands-on dbt tutorial, you’ll learn step-by-step how to create a singular test to validate custom business rules using SQL. Unlike built-in generic tests (like unique or not_null), singular tests allow you to write fully customizable SQL logic to enforce strict data quality checks. ✅ Prerequisites ☑️ A...
📘 Introduction In this hands-on dbt tutorial, we’ll walk you step-by-step through how to set up data warehouse grants in dbt, ensuring the right users have access to the right layers and models. 📌 This is a must-know topic for the dbt Analytics Engineering Certification Exam, so mastering it now puts...
📘Introduction In this hands-on dbt tutorial, we’ll walk you step-by-step through how to make your SQL cleaner and more maintainable by using CTEs (Common Table Expressions) instead of deeply nested subqueries. ✅ Prerequisites ☑️ A dbt project set up ☑️ Source data loaded into your data warehouse ☑️ Source configurations defined in sources....
📘Introduction In this hands-on dbt tutorial, we’ll walk step by step through how to apply the Medallion Architecture to a real dataset using dbt. We’ll explore a sample dataset, visualize the dataflow, and move through all layers of the architecture: 1️⃣ 🛬 Landing Layer – Raw data ingestion 2️⃣ 🥉 Bronze...
📘 Introduction The OpenAI Agent Builder is a visual, no-code canvas for creating intelligent workflows powered by AI. It lets you design and connect nodes — modular building blocks that define how your agent processes inputs, performs reasoning, calls external tools, applies safety checks, and produces outputs. Each node has a specific...
📘 Introduction In this hands-on dbt tutorial, we’ll walk you step-by-step through how to create, use, and understand macros — one of dbt’s most powerful features for reusing logic and keeping your SQL clean, modular, and DRY (Don’t Repeat Yourself). By the end, you’ll be able to write...
📘 Introduction Welcome to this hands-on guide to OpenAI Agent Builder — a revolutionary no-code tool that lets you design and deploy multi-agent workflows using a drag-and-drop interface. In this post, we’ll walk you through how to access the Agent Builder and create your first agent workflow step-by-step. 💡 What is OpenAI...
