Is there any component on Knime Server for reporting workflow metadata and data lineage?
Let’s say I have a data warehouse environment and all knime workflows are consuming data from DWH model. How can I report workflows using CUSTOMER table as a source from DWH model?
Or if I want to drop one column from CUSTOMER table, I need to be sure that nobody uses this column in any workflow.
Currently, we do not have a component that will provide a report with workflow metadata and lineage. However, you could write a workflow that reads the XML files with the workflow information and parse through the file using XPath to find the Customer table.
To prevent users to update a certain column on a table you could create a view on the database with the columns that the users can access and update or set column permissions.