Transform icons

The 15 transform icons in Data Engineering, described

Aggregateaggregate

Aggregate — roll many rows up into one number, a sum, an average or a count.

ELTelt

ELT — load the data first, then transform it inside the warehouse.

Enrichenrich

Enrich — the same rows with more information joined on to them.

ETLetl

ETL — extract data from a source, transform it, and load it where it will be used.

Filterfilter

A filter funnel that keeps only what matches — narrow a list, a query or a stream of results.

Join tablesjoin

Join tables — rows matched where their keys agree, merged into one result.

Mappingmapping

A mapping — each of these matched to one of those, a translation between sets.

Materialisematerialise

Materialise — a query's answer made into a solid, cached table.

Parserparser

A parser — text going in, a structured tree coming out the other side.

Schema evolutionschema-evolve

Schema evolution — a table grows a column without breaking what reads it.

Schema mapschema-map

A schema map — this field over there is that field over here, a translation between shapes.

Splittersplitter

A splitter — one stream fanned out into two so both branches receive it.

Transformtransform

Transform — data goes in one shape and comes out another, converted and reshaped.

Unionunion

Union — everything from both sets combined into one with duplicates kept once.

Upsertupsert

Upsert — update the row if it exists, insert it if it is new.

In code, each is one import — import { Aggregate } from "@iconmind/react/icons/aggregate" — and the same name in Vue, Svelte, Solid, Preact, React Native, Astro, Blade and Flutter.

Narrow it by tag