{CodeRoyale}
All challenges
Multiple ChoiceIntermediate 45s

ETL vs ELT for schema drift

Source schemas change often with new optional columns. Which approach best absorbs schema drift with least rework?
Options
  1. 1A strict ETL layer that fails the pipeline whenever it encounters any new column
  2. 2Manual schema edits performed by hand in every pipeline for each upstream change
  3. 3ELT loading raw semi-structured data first, then modeling downstream with schema-on-read
  4. 4Disabling schema evolution entirely so upstream changes are rejected at ingest
data-pipelineeltschema-drift

Think you can answer under pressure?

Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.

Play this in a 3-minute battle