2024-11-22 - Join Validation¶
Problem¶
Being able to join two tables together is a necessity, but its often tricky to work out if the join is going to create issues - eg a one to many relationship that would explode out the grain of the target table
Solution¶
To check for fan joins we add an extra check when validating the users join and profile the join keys on each side of the join, this makes sure we dont have a many to many or one to many join condition. If this is detected, we show a warning to the user and they can decide whether to proceeed or not.
Leverage the Magic¶
Our trusty websocket validation endpoint to the rescue again
ADI¶
Now thats magical !
Last Refreshed¶
Doc Refreshed: 2024-11-29