ETL vs ELT on AWS: What's the Difference?
Channel: Ashleigh Faith
Date: 20/10/2020

Extract Transform and Load (ETL) vs Extract Load Transform (ELT) on Amazon Web Service (AWS). ELT is a relatively new architecture while ETL is pretty standard. Check out this new video to see how the ETL and ELT architectures compare using AWS microservices. 

This is just one example, if you have an example to share for ETL or ELT architectures, please leave in the comments below!  

Stay in touch:
LinkedIn: https://www.linkedin.com/in/ashleighnfaith/
Direct Message: isadatathing-at-gmail.com

Copy of architecture in the video: https://drive.google.com/file/d/1GRwuBnpH_OkkMFQbl-AgBDWpA7FHMvw6/view?usp=sharing

ETL Tools: https://www.predictiveanalyticstoday.com/top-free-extract-transform-load-etl-software/

AWS resources:
1. Redshift: https://panoply.io/data-warehouse-guide/redshift-etl/
2. ETL and ELT AWS: https://aws.amazon.com/blogs/big-data/etl-and-elt-
3. Step functions: https://aws.amazon.com/blogs/big-data/orchestrating-an-etl-process-using-aws-step-functions-for-amazon-redshift/
design-patterns-for-lake-house-architecture-using-amazon-redshift-part-1/
4. Glue: https://aws.amazon.com/glue/?whats-new-cards.sort-by=item.additionalFields.postDateTime&whats-new-cards.sort-order=desc
5. Neptune: https://aws.amazon.com/neptune/
6. Lake Formation: https://aws.amazon.com/lake-formation/?whats-new-cards.sort-by=item.additionalFields.postDateTime&whats-new-cards.sort-order=desc
7. Lambda: https://docs.aws.amazon.com/lambda/latest/dg/welcome.html
8. Jenkins: https://www.jenkins.io/
9. ETL vs ELT in general from vendors: https://www.xplenty.com/blog/etl-vs-elt/
10. AI @ Amazon: https://www.linkedin.com/posts/greg-coquillo_etl-vs-elt-ugcPost-6919320680811421696-NGaz?utm_source=linkedin_share&utm_medium=member_desktop_web