What is ETL / ELT?
ETL (Extract, Transform, Load) and ELT are patterns for moving data from source systems into a warehouse or lake. ETL transforms data before loading; ELT loads first and transforms inside the warehouse using its compute.
These pipelines are the plumbing of analytics and AI. ELT has become common with cloud warehouses that can transform data cheaply at scale, while ETL still suits cases needing cleansing or compliance before data lands.