How to validate data schemas in ELT: step by step
How to validate data schemas in ELT to ensure compatibility and avoid errors: practical example, change detection and s…
4 min
29 Jul 2026
How to partition Delta tables in ELT for fast queries
How to partition Delta tables in ELT to reduce query latency. Practical guide with SQL examples, compaction, optimizati…
4 min
17 Jul 2026
How to Backfill Data in ELT: Step by Step
Learn how to backfill data in ELT with the idempotent delete-insert pattern: a defined window, batched runs and duplica…
5 min
13 Jul 2026
How to flatten nested JSON in ELT: step by step
Learn to flatten nested JSON in ELT with SQL Server's OPENJSON function: load the raw JSON and turn it into relational …
4 min
08 Jul 2026
How to do an idempotent upsert in ELT with MERGE
Learn to build idempotent ELT loads with the MERGE statement: a practical SQL upsert example to update and insert data …
4 min
08 Jul 2026
How to audit data loads in ELT: step by step
Learn how to audit data loads in ELT using audit columns and a SQL log table. Track the source, row count and status of…
4 min
05 Jul 2026
How to test data quality in ELT: step by step
Learn to test data quality in ELT with simple SQL queries: nulls, duplicates, integrity and freshness, catching errors …
5 min
05 Jul 2026
How to implement SCD Type 2 in ELT: step by step
Learn how to implement an SCD Type 2 dimension in ELT with SQL and store the full history of changes, with practical st…
5 min
04 Jul 2026
How to Remove Duplicates in ELT: Step by Step
Learn how to remove duplicates in ELT in the transformation layer with ROW_NUMBER() and QUALIFY. Practical SQL example …
4 min
04 Jul 2026
Medallion Architecture in ELT: Bronze, Silver, Gold
Learn to structure an ELT pipeline with the Medallion architecture: the bronze, silver and gold layers, with SQL exampl…
4 min
04 Jul 2026
How to Build Incremental Loads in ELT: Step by Step
Learn how to build an incremental load in ELT using the watermark pattern and a SQL MERGE. Step-by-step guide for faste…
4 min
04 Jul 2026
ETL vs ELT: differences and how to do ELT in practice
ETL vs ELT: understand the difference and learn to do ELT in a modern data warehouse, loading raw and transforming with…
2 min
05 Sep 2023