Technical GlossaryData Engineering and AI Infrastructure

Pushdown Transformation

An approach in which transformations are executed inside the engine or platform where the data already resides rather than in a separate layer.

Pushdown transformation is an important approach in modern ELT architectures because it improves performance and scalability. Instead of moving data unnecessarily between systems, transformation queries are executed directly inside the warehouse, lakehouse, or database. This reduces network overhead and makes better use of the platform’s native compute power. It becomes especially valuable when working with large volumes of data and architecting for efficiency.