Docs
Browse Docs
Glossary

ETL

Extract, transform, load: taking data out of a source system, cleaning and reshaping it, and then writing the result into a destination.

The transform step is where most cleaning happens. If only the transformed result is kept, a mistake in that step cannot be undone without extracting the data again.

See also

  • ELTExtract, load, transform: copying data from its source into a destination system as it is, and cleaning and reshaping it there afterward.
  • TransformationAny step that turns data from one form into another: converting a type, splitting a column, combining tables, or calculating a new field.
  • BatchA set of records processed together as one unit, such as a day of orders loaded overnight or one uploaded file.

Karg checks for many of these when it profiles a file, applies the fixes it is confident about, and sets the rest aside for your review. See how it works, or have our team clean your data for you.