Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
Extract, load, transform
open-in-new
<h2 id="benefits">Benefits</h2> <p>Some of the benefits of an ELT process include speed and the ability to handle both structured and unstructured data.<a class="footnote-ref" id="fnref:5" href="#fn:5"><sup>5</sup></a> </p> <h2 id="cloud-data-lake-components">Cloud data lake components</h2> <h3>Common storage options</h3> <ul><li>AWS <ul><li><a href="/facts/Amazon_S3/bqAXYCxq">Simple Storage Service</a> (S3)</li> <li><a href="/facts/Amazon_RDS/AjlHuAuv">Amazon RDS</a></li></ul></li> <li>Azure <ul><li>Azure Blob Storage</li></ul></li> <li>GCP <ul><li><a href="/facts/Google_Cloud_Storage/UkHqfH2l">Google Storage</a> (GCS)</li></ul></li></ul> <h3>Querying</h3> <ul><li>AWS <ul><li>Redshift Spectrum</li> <li>Athena</li> <li>EMR (Presto)</li></ul></li> <li>Azure <ul><li><a href="/facts/Azure_Data_Lake/wvgb81f1">Azure Data Lake</a></li></ul></li> <li>GCP <ul><li>BigQuery</li></ul></li></ul> <h2 id="external-links">External links</h2> <ul><li>Dull, Tamara, <a href="https://www.smartdatacollective.com/data-lake-debate-pro-s-first/">"The Data Lake Debate: Pro is Up First"</a>, <i>smartdatacollective.com</i>, March 20, 2015.</li> <li><a href="https://www.astera.com/type/blog/elt-extract-load-and-transform/">ELT: Extract, Load, and Transform A Complete Guide</a> | Astera Software</li></ul> <h2 id="references">References</h2> <ol> <li id="fn:1"><p>"What is ELT (Extract, Load, Transform)? | IBM". www.ibm.com. October 2021. Retrieved 2024-01-30. <a href="https://www.ibm.com/topics/elt" target="_blank">https://www.ibm.com/topics/elt</a> <a href="#fnref:1" class="footnote-back-ref">↩</a></p></li> <li id="fn:2"><p>Abdullahi, Aminu (2023-06-30). "ETL vs ELT: What Are the Main Differences and Which Is Better?". TechRepublic. Retrieved 2024-01-30. <a href="https://www.techrepublic.com/article/etl-vs-elt/" target="_blank">https://www.techrepublic.com/article/etl-vs-elt/</a> <a href="#fnref:2" class="footnote-back-ref">↩</a></p></li> <li id="fn:3"><p>Using Redshift Spectrum to load data pipelines[usurped] Published by deductive.com on January 17, 2018, retrieved on April 3, 2019. <a href="https://web.archive.org/web/20210118172247/https://deductive.com/blogs/using-amazon-redshift-spectrum-data-pipelines/" target="_blank">https://web.archive.org/web/20210118172247/https://deductive.com/blogs/using-amazon-redshift-spectrum-data-pipelines/</a> <a href="#fnref:3" class="footnote-back-ref">↩</a></p></li> <li id="fn:4"><p>"What is ELT (Extract, Load, Transform)? | dbt Developer Hub". docs.getdbt.com. 2024-01-30. Retrieved 2024-01-30. <a href="https://docs.getdbt.com/terms/elt" target="_blank">https://docs.getdbt.com/terms/elt</a> <a href="#fnref:4" class="footnote-back-ref">↩</a></p></li> <li id="fn:5"><p>Mishra, Tanya (2023-09-02). "ETL vs ELT: Meaning, Major Differences & Examples". Analytics Insight. Retrieved 2024-01-30. <a href="https://www.analyticsinsight.net/etl-vs-elt-meaning-major-differences-examples/" target="_blank">https://www.analyticsinsight.net/etl-vs-elt-meaning-major-differences-examples/</a> <a href="#fnref:5" class="footnote-back-ref">↩</a></p></li> </ol>