🎯 What is Data Masking? Data masking is the process of obfuscating sensitive data while […]
dbt: Metrics Filter Dimensions: Practical Guide
🎯 The Problem In dbt’s semantic layer, you have complex metrics with multiple filter conditions: […]
dbt: Macro vs Valeurs en Dur : Pourquoi la Macro Gagne
🤔 La Question Légitime Pourquoi faire une macro quand on peut écrire directement : Au […]
dbt: Hybrid Slowly Changing Dimension (SCD) Type1 & Type 2
🧠What is a Hybrid SCD? A Hybrid SCD combines: ✅ Why use Hybrid SCD? […]
dbt: how to implement a metrics table to store test results
🎯 Why Create a Metrics Table for Test Results? By default, dbt test shows pass/fail […]
dbt: Enforcing Model Contracts in Incremental dbt Models Using Jinja Macros and Pre-Hooks
✅ Enforcing Model Contracts in Incremental dbt Models Using Jinja Macros and Pre-Hooks When using […]
dbt: how to implement query progress callbacks in a dbt adapter
🎯 Goal When executing long-running SQL queries, especially on large warehouses (e.g. Databricks, Trino, Presto, […]
dbt: how to implement partition merging with metadata preservation in a large fact table snapshot in dbt
✅ The Problem: Large Snapshots with Too Many Partitions In large dbt projects using snapshots […]
dbt: Handling Evolving Source Schemas in dbt with Dynamic Column Selection
When working with external data sources (like APIs, third-party tables, or partner feeds), the schema […]
dbt: Environment-Specific Contract Validation in dbt Using Custom Macros
Here’s a polished and professional English explanation with a concrete example, perfect for your website […]