Saturday, August 4, 2018

ETL – extract, transform and load

Data extraction is where data is extracted from homogeneous or heterogeneous data sources; data transformation is where the data is transformed for storing in the proper format or structure for the purposes of querying and analysis; data loading where the data is loaded into the final target database, more specifically, an operational data store, data mart, or data warehouse. Source: https://en.wikipedia.org/wiki/Extract,_transform,_load

ETL is an important part of today's business intelligence (bi). It is the IT process from which data from disparate sources can be put in one place to programmatically analyze and discover business insights. Source: https://www.webopedia.com/TERM/E/ETL.html

AWS Glue is a fully managed extract, transform, and load (ETL) service that you can use to catalog your data, clean it, enrich it, and move it reliably between data stores.

More from AWS: Data Transformation (ETL/ELT)

No comments:

Post a Comment