Hi All , I was exploring the datahub relationships...
# ingestions
some-cricket-23089
05/11/2021, 1:58 PMHi All , I was exploring the datahub relationships, So my as is if i have mysql database and table are normalized in. So can we manage the relationship between the these table. Like table " A" has a foreign key which is a primary key in table "B". So any way i can manage this relationship between Table "A" and "B"
g
green-football-43791
05/11/2021, 2:29 PMHey Rahul- Datahub does have a way to store foreign key relationships on the modeling side, here:
https://github.com/linkedin/datahub/blob/master/metadata-models/src/main/pegasus/com/linkedin/schema/SchemaMetadata.pdl#L56
green-football-43791
05/11/2021, 2:29 PMHowever, this property is not currently being propagated to the UI
s
some-cricket-23089
05/11/2021, 2:34 PM@green-football-43791 So can't we see any relational diagram of the related table "A" and "B"
some-cricket-23089
05/11/2021, 2:35 PM?
some-cricket-23089
05/11/2021, 2:36 PM@green-football-43791 Also as these foreignKeySpec is not being propagated , so for now we can consider this as just persisting into database but not using anywhere. Right ?
g
green-football-43791
05/11/2021, 2:37 PMCorrect- we intend to add them into the React UI, but for now, they are just persisted in the database.
s
some-cricket-23089
05/11/2021, 2:38 PM@green-football-43791 Can we use the Lineages to view such type of related tables as well, what you suggest for now ?
m
mammoth-bear-12532
05/11/2021, 2:47 PM
@some-cricket-23089 what you’re looking for would most likely be similar to an ER model diagram. Lineage seems more related to derivation.
mammoth-bear-12532
05/11/2021, 2:47 PM
For now, the simplest solution would be to enhance the existing schema view to support navigating to the related tables
mammoth-bear-12532
10/01/2021, 6:22 AM
@some-cricket-23089 primary and foreign keys should be available for sql sources starting with pypi
acryl_datahub==0.8.15.10.8.15s
some-cricket-23089
10/01/2021, 6:29 AM@mammoth-bear-12532 Sure will try it and let you know
some-cricket-23089
10/01/2021, 6:29 AMThanks for updating the same