Extract, Load, Transform (ELT)


Extract, load, transform (ELT) is the process that occurs when moving data from source systems to data lakes, which holds data in preparation for transformation.

  • is a more modern method that is used when preparing data for data lakes
  • transformations to the data happening after the data is loaded, not before
  • allows data to be moved into data storage systems faster
  • Data lakes and data lakehouses often use the ELT process
    • are meant to store data and then transform it into what we need
  • ideal for data lakes because they typically hold more real-time data that is updated minute by minute
  • meant to increase data availability and improve processing times