Matillion Roadmap and Ideas

Welcome to the Matillion Roadmap

Last updated: 05/19/2025
Check out our recently delivered features here

The Roadmap has evolved - see here

This post was merged with Transform Pipelines bring through all columns (Schema Evolution)

Go to parent post

SELECT * in Join/Detect Changes

In case of Join/Detect Changes, we always need to map the columns.

It is understood that there are sometimes overlaps and the explicit mapping functionality is useful there.

So, besides the ability to explicitly map a column, if the tool could also have the ability to add prefixes like left. and right. or source. and target. or master. and compare. to indicate and distinguish by itself when ‘*’ is mentioned, that would be great.