DEV Community

Discussion on: 8 New SQL Tools That Will Change How You Work in 2020

Collapse
 
elseagle profile image
Oluwasogo Oluwafemi

Nice article! On the Dataform section has a mistake "ELT" instead of "ETL"

Collapse
 
mike_seekwell profile image
Mike

that's probably on purpose, see here blog.panoply.io/etl-vs-elt-the-dif...

Collapse
 
realtrevorfaux profile image
Trevor Fox

Good catch Oluwasogo! It was intentional. The article Mike mentions below shows the difference. The main difference with DBT and Dataform and previous ETL solutions is that they are built to manage the "Transformation" part of the pipeline after the data is in a data warehouse rather than before the data is loaded, thus ELT.