Hi, I have two tables related to foreign keys in m...
# ingestion
r
Hi, I have two tables related to foreign keys in mysql, I imported them to datahub but their relationship is not shown on the page Actually there is foreign key data inside the metadata_aspect_v2 table in datahub database I put the process I executed in the log.txt file, please check @loud-island-88694 @little-megabyte-1074
g
Hey @rhythmic-sundown-12093 - I found the issue. The foreign key referenced
" role_id"
but should reference
"role_id"
as the source field. I'm going to add a patch to the UI that removes leading or trailing whitespace. I'll also look into why the source added the leading whitespace to begin with.
As a temporary workaround, if you remove that whitespace character in mysql the key will appear.
here's the UI fix
and here's the ingestion source fix
r
Thanks, Seems like a very minor problem that is easy to fix
g
Yup!