# Need help with complicate relationship data

**URL:** <https://forum.data-community.org/t/need-help-with-complicate-relationship-data/1003>\
**Category:** Data Vault 2.0\
**Tags:** link\
**Created:** [October 9, 2023, 8:08am UTC](https://forum.data-community.org/t/need-help-with-complicate-relationship-data/1003 "2023-10-09T08:08:05Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![sisill](https://avatars.discourse-cdn.com/v4/letter/s/898d66/32.png) [@sisill](https://forum.data-community.org/u/sisill)\
**Post date:** [October 9, 2023, 8:08am UTC](https://forum.data-community.org/t/need-help-with-complicate-relationship-data/1003/1 "2023-10-09T08:08:05Z")

</div>

Hi all  
I have this relationship: A hub; B hub and C hub. A is connected with B so we have A\_B\_link table and A\_B\_sat table connected to A\_B\_link.  
But C is depending on A-B combination. So if I must do again link table it must be A\_B\_C\_link and to conect A\_B\_C\_sat to it.

1. **Create Hub Tables:**

- **Hub A:** Represents the core entity A.
- **Hub B:** Represents the core entity B.
- **Hub C:** Represents the core entity C.

1. **Create Link Tables:**

- **A\_B\_Link:** This table captures the relationship between A and B.
- **A\_B\_C\_Link:** This table captures the relationship between A\_B and C.

1. **Create Satellite Tables:**

- **A\_B\_Sat:** This satellite table captures attributes related to the A\_B relationship.
- **A\_B\_C\_Sat:** This satellite table captures attributes related to the A\_B\_C relationship.

But like this I repeat A\_B relationship.  
So can I use link table Id in other link table? A\_B\_link ID to use in A\_B\_C\_link table?

---

<div class="post-metadata">

**Author:** ![alex.higgs](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.data-community.org/alex.higgs/32/434_2.png) [@alex.higgs](https://forum.data-community.org/u/alex.higgs)\
**Post date:** [October 9, 2023, 11:51pm UTC](https://forum.data-community.org/t/need-help-with-complicate-relationship-data/1003/2 "2023-10-09T23:51:33Z")

</div>

Sounds to me like you need two different Links.

A\_B and B\_C, you then use the transitive property of these to get to C from A via B in your downstream joins. Do not have links on links as you suggest.

As for the satellites, are you certain the attributes only make sense together and are part of the same unit of work?

If it’s simply that they are alongside each other downstream in the Presentation Later, then you join these together to do that later; they shouldn’t be modelled as a single satellite spanning multiple hubs/links.

---

<div class="post-metadata">

**Author:** ![sisill](https://avatars.discourse-cdn.com/v4/letter/s/898d66/32.png) [@sisill](https://forum.data-community.org/u/sisill)\
**Post date:** [October 10, 2023, 6:38am UTC](https://forum.data-community.org/t/need-help-with-complicate-relationship-data/1003/3 "2023-10-10T06:38:16Z")

</div>

> [@sisill](#):
>
> But C is depending on A-B combination.

As I wrote "But C is depending on A-B combination. " So there is no point to connect only B with C.  
You have for example 70 combinations between A and B. And for every combinations you can have different count of C.

---

<div class="post-metadata">

**Author:** ![Nat](https://avatars.discourse-cdn.com/v4/letter/n/8c91f0/32.png) [@Nat](https://forum.data-community.org/u/Nat)\
**Post date:** [October 10, 2023, 1:03pm UTC](https://forum.data-community.org/t/need-help-with-complicate-relationship-data/1003/4 "2023-10-10T13:03:05Z")

</div>

Is C really a distinct business entity if it depends on A and B?

A typical situation is where A and B are e.g. store and product, and C is a sales transaction. This would mean that there is a link C that links the store and the product at a particular time. It might be that there is also a hub C’ which is the sales header (as a transaction may have more than one item on it) which also forms part of the link. (plus link sats, eff sats etc)

Can you give an example of what A B and C really are?

---

<div class="post-metadata">

**Author:** ![patrickcuba](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.data-community.org/patrickcuba/32/19_2.png) [@patrickcuba](https://forum.data-community.org/u/patrickcuba)\
**Post date:** [October 10, 2023, 8:51pm UTC](https://forum.data-community.org/t/need-help-with-complicate-relationship-data/1003/5 "2023-10-10T20:51:13Z")

</div>

Like @alex.higgs suggests, 2 links appears to be correct.

You’re not repeating relationships, you are depicting two seperate and distinct units of work, why didn’t link A B not have that unit of work unless you explicitly modelled it separately, or maybe C is not a business entity — you used the word “dependent”, is it a dependent-child key?

---

<div class="post-metadata">

**Author:** ![sisill](https://avatars.discourse-cdn.com/v4/letter/s/898d66/32.png) [@sisill](https://forum.data-community.org/u/sisill)\
**Post date:** [October 11, 2023, 7:16am UTC](https://forum.data-community.org/t/need-help-with-complicate-relationship-data/1003/6 "2023-10-11T07:16:19Z")

</div>

For example:  
A- model car  
B- body type  
C - wheel  
A- shkoda oktavia  
B- kombi  
C - wheel15  
So you can have a lot of combinations from A and B and depend on the combination you can have different wheel 15,17,19…

---

<div class="post-metadata">

**Author:** ![patrickcuba](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.data-community.org/patrickcuba/32/19_2.png) [@patrickcuba](https://forum.data-community.org/u/patrickcuba)\
**Post date:** [October 11, 2023, 8:25pm UTC](https://forum.data-community.org/t/need-help-with-complicate-relationship-data/1003/7 "2023-10-11T20:25:32Z")

</div>

There is a breakdown on what you model as a hub vs simple attributes to a satellite; i’d suggest watching the first few minutes of [this](https://www.snowflake.com/webinar/zero-to-data-vault-on-snowflake-2023-04-27/)

---

<div class="post-metadata">

**Author:** ![RhysHanscombe](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.data-community.org/rhyshanscombe/32/394_2.png) [@RhysHanscombe](https://forum.data-community.org/u/RhysHanscombe)\
**Post date:** [December 1, 2025, 2:35pm UTC](https://forum.data-community.org/t/need-help-with-complicate-relationship-data/1003/8 "2025-12-01T14:35:06Z")

</div>

Closed on December 1, 2025, 2:35pm UTC


