Hello experts, first of all thanks again for this ...
# ui
d
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
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
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
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
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
🎉 that sounds great! I’ll DM you to work out details