Hello experts, first of all thanks again for this amazing product! Totally love it and I think it is literally the best Data Catalog out there 😄
I have a question regarding foreign keys. Is there a way to use the search to identify all foreign keys that have a constraint to a specific column? I can see in the UI that a table has a Foreign Key but I can not see this constraint in the other table that provides the data for the foreign key. Maybe you also have other suggestions to showcase this information? Thanks a lot !
b
big-carpet-38439
07/06/2022, 3:39 PM
Hi Mike! Thank you for the kind words. We sure are glad to have someone like you in the community 🙂
So to understand better, what you are looking for is a way to link the foreign key source table into the "join" table, so you can see bidirectional relationships - is that right?
d
dazzling-appointment-34954
07/07/2022, 5:21 AM
exactly, sorry if I was not clear enough. I already had a look into the search (the foreign key aspect is not searchable). Is there any way to figure out from the source table which tables are pointing to that table as a foreign key relation?
l
little-megabyte-1074
07/07/2022, 8:10 PM
Hi @dazzling-appointment-34954! I’m going to be doing a bit of discovery about how folks would like to leverage primary/foreign key relationships from our UI & would love to learn a bit more about your use cases! Would you be up for a quick 15-20min Zoom chat within the next week?
d
dazzling-appointment-34954
07/07/2022, 8:39 PM
Hey Maggie, I am very happy to jump on a Zoom call. I will be on vacation next week though but I am back the week from 18th of July. Does this work for you?
We would also need to find a good time as I am living in Germany (+8 hours or so). Nevertheless we are currently PoC-ing Datahub for a big swiss client and they have a specific use-case, so I´d love to provide detailed information.
l
little-megabyte-1074
07/07/2022, 8:40 PM
🎉 that sounds great! I’ll DM you to work out details