Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Connect Ideas

Share your Connect product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Lineage at Column Level

Connect currently provides lineage for a datasource at the table level but we would like to be able to have this at a more granular level i.e. the column level so if a specific column changes in the table (e.g. data type change), we are notified of the change and able to identify quickly assets that will be affected.

 

@SeanAdams @revathi

6 Comments
VojtechT
Alteryx
Alteryx
Status changed to: Under Review

Hi @Kosi ,

 

we are currently investigating options how to achieve this goal. It is clear that we cannot get the columns using the current approach, i.e. parsing the workflow definition, but need to get on a lower level. 

This will probably have a significant impact on the whole lineage-making process and the results can be expected in rather long- than short-term.

Aum
8 - Asteroid

We can benefit from this too.

monodera
Alteryx Alumni (Retired)

My customers also want Lineage at Column Level .

SeanAdams
17 - Castor
17 - Castor

This may also need @AdamR_AYX  and his team to contribute - since this would be much easier if the engine had a unique field ID internally (similar to the way that compilers have a symbolic variable table that gives a unique memory address to each declared variable)

 

Field traceability, if done at the engine level, would also allow for optimisation hints like "you've never used this field in an output - may be worth eliminating early in the flow" - again, similar to the hints you get in code IDEs.

VojtechT
Alteryx
Alteryx
Status changed to: Under Review

Hi @Kosi ,

 

I definitely agree with you. Unfortunately this improvement is not much about Connect being able to show such information as about retrieving the information. We are looking for ways how to get it straight from engine, but I cannot promise anything at this point. 

 

bigdata
6 - Meteoroid

I got the same request from my business partners for column level lineage. For Connect to evolve as a competing data lineage, this is a critical feature to include.