Hi,
I am attempting to capture database views in EDG. In particular, I want to be able to capture derived columns and how those columns are derived. e.g. view column A is the sum of table 1 column B and table 2 column C.
Looking at Database View, I see view input column and view output column. There are no descriptions so I can only infer that these property shapes are used to define the columns of the view (output) and what columns are referenced to create the view (input)? Correct?
However, what I need is column to column(s) mapping. Digging deeper by looking at Database Column, I see inferred Referenc-ed/ing Columns. It is not clear if I am to use edg:parentColumn and edg:childColumn properties to establish the relationships between columns that are transformed to become a column in a view nor how I would do this. (see screenshot below)
Do you have any examples? It would be great if the example graphs for EDG could be expanded to include examples that fully populate all EDG classes and property shapes across all asset collections. The ontological structure is not always intuitive at takes considerable time to discover how to do things.
Thanks in advance for your help,
Tim