Hello, could we view `foreign key` in datahub?
# feature-requestsm
mysterious-monkey-71931
09/30/2021, 3:31 PMHello, could we view
foreign keyb
big-carpet-38439
09/30/2021, 5:51 PMComing soon! @green-football-43791
g
green-football-43791
09/30/2021, 6:01 PMCorrect!
green-football-43791
09/30/2021, 6:02 PMMore details here:
green-football-43791
09/30/2021, 6:02 PMgreen-football-43791
09/30/2021, 6:03 PMWhat sources are you interested in extracting foreign keys from?
m
mammoth-bear-12532
10/01/2021, 6:21 AM
@mysterious-monkey-71931: this should be available for sql sources starting with pypi
acryl_datahub==0.8.15.1😀 1
plus1 1
m
mysterious-monkey-71931
10/01/2021, 7:16 AMThanks everyone 🥰
m
mammoth-bear-12532
10/01/2021, 2:13 PM
@mysterious-monkey-71931: which source db did you try this with?
m
mysterious-monkey-71931
10/01/2021, 2:24 PM@mammoth-bear-12532 Currently we only have hive source.
But I'm have a plan to add MySQL & PostgreSQL in near future.
mysterious-monkey-71931
10/01/2021, 2:26 PMHive don't have the concept of PK & FK. But it has partition columns & bucketed columns.
Is that feature work with this kind of columns?
m
mammoth-bear-12532
10/01/2021, 2:29 PM
This particular feature focuses just on highlighting where primary keys exist and if there are foreign key constraints specified
mammoth-bear-12532
10/01/2021, 2:30 PM
for partition-keys / bucketed-columns etc.. we would need some additional work in the “connector” + UI to show it.
4 Views