Handling Schema Drift

Problem

A source application added two new columns to their table without notifying the data team, crashing your ETL pipeline. You need to configure the pipeline to handle this. Write a query that outputs definition with the value: "Schema drift occurs when source systems dynamically add, delete, or modify columns, requiring data pipelines to adapt without failing."

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