Joins: Automatic Identification of Relationship Direction
Please add:
- Automatic identification of relationship direction within a Join tile.
- An option to amend this relationship direction (where appropriate) within the Join tile. E.G A drop-down with 1-2-1,1-2-Many, Many-2-1, Many-2-Many (inc warning) e.t.c
- A visible representation of this relationship direction with ERD arrows e.g:
https://us.v-cdn.net/6032830/uploads/BQNB1E93W27W/image.png
This would ensure:
- Users consider relationship context when joining tables together - especially those new to data modelling/ETL work.
- Users to reduce test ETLs / tiles because the automatic ientification would suface issues.
Visual Example (Power BI):
https://us.v-cdn.net/6032830/uploads/L3TRUBS6KFJ4/image.png
Context:
+ The GUI can get cluttered quickly with multiple tests for multiple joins.
+ Users with less experience tend to forget about relationship direction since it's not a visible quality. They then face cardinality problems and question the join type (left, right, inner, etc) when actually the problem is the invisible changes to the shape of their tables during the ETL and the assumptions made when joining.
