reata / sqllineage

SQL Lineage Analysis Tool powered by Python
MIT License
1.34k stars 241 forks source link

Keep Column Transformations Raw Expression #343

Open RajDadi opened 1 year ago

reata commented 1 year ago

ISNULL and CASE in SELECT clause are definitely extracted in column lineage. Do you mean retain the raw expression?

As for where clause, as well as join clause, group by, order by, these are not analyzed for the moment but definitely in the future plan.

RajDadi commented 1 year ago

Yes retain the raw expression

Also, will it work for MERGE Statement in Sqlserver

reata commented 1 year ago

Yes retain the raw expression

Also, will it work for MERGE Statement in Sqlserver

Will plan in future release.

Merge statement support is coming in v1.4.0, see #166 for details. Expect the release before end of the week.

reata commented 1 year ago

For where clause, please refer to #276 for future update. We'll narrow down this scope of this issue to Keep Column Transformations Raw Expression

Nelliguns commented 9 months ago

Hi, are there any updates on this? I'm looking for a solution to get source columns their table and database as well as any transformation logic. If this isn't in the works as of yet could you maybe point me in the right direction of where I could implement it?

reata commented 9 months ago

Hi, are there any updates on this? I'm looking for a solution to get source columns their table and database as well as any transformation logic. If this isn't in the works as of yet could you maybe point me in the right direction of where I could implement it?

Unfortunately it's not coming in near term. We still have some foundational work to do (refactor on graph modeling, refine column lineage with metadata) before getting to this.