Yellowfin metadata tables structure - Details & Document

Harish shared this question 10 months ago
Answered

Hi Team,


I would like to know details about Yellowfin metadata tables structure & relationships. It would be great if I have document regarding the relationship between tables & relevant details.

Comments (7)

photo
1

Hi Harish,

There is a new ERD that is a work-in-progress at the moment, but I'm attaching it anyway ("yellowfin_config_model.pdf) because it may help you with what you are trying to do.

There is also an old ERD from the early days of Yellowfin that I am attaching here ("ERD Diagram.pdf"), and because it is old there are many current tables missing from it, but I'm attaching it just for the sake of completeness.

And if you can't find what you are looking for in either of those documents then don't forget that you can always ask for help from the friendly staff here at Support.


regards,

David

photo
1

Hi Dave,

Thanks Dave !

I would like to get details of data lineage in various stages.

Yellowfin Report Layer (including Custom Columns, Filters, Other details ) To Yellowfin Presentation Layer to Yellowfin View Layer (Physical & Virtual Tables)


It would be great If I get the SQL query for above mentioned stages. It will help us to identify impacted reports based on columns.

photo
2

Hi Harish,

I'm sorry but we don't have such documentation. Are you thinking of adding indexes?

regards,

David

photo
1

Hello Dave !

Actually I'm looking for data lineage part i.e My report column map to which YF View column & that YF column map to which Physical table column.

Ex: Report ColumnName -> YF View (Presentation Table) ->Physical Table coulm.

How can I get these details using Yellowfin metadata or any other way?

photo
1

Hi Harish,

you can get that metadata from the following query:


SELECT rft.columnName AS 'column name in source', rft.shortDescription AS 'column name in view', rf.ColumnHeading AS 'column name in report'
FROM reportHeader rh
INNER JOIN reportField rf ON rh.reportId = rf.reportid
INNER JOIN reportFieldTemplate rft ON rf.fieldTemplateId = rft.fieldTemplateId
WHERE rh.reportName = 'insert report name here'

I hope that helps you with your data lineage work.

regards,

David

photo
1

Good ! Thank you Dave.

photo
1

Hi Harish,

great, thanks for letting me know!

And if there is ever anything else like that you wish to know....just drop us another Question.

regards,

David