SCD Type 1 (Overwrite)

Problem

You are syncing user profiles to the warehouse. When a user changes their country from "USA" to "UK", you want to overwrite the old value directly, keeping no history. Write a query that outputs behavior with the value: "SCD Type 1 updates columns directly, overwriting historical data, useful when tracking history is not required."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution