Right now to show relation between column, we have to create Primary Key and than it automatically create Foreign Key in the related table.
This is good for OLTP Table Design.
For Big Data Workloads that don't support Enforced Relationship, but only virtual relation the above restriction are too strict.
Also the names of column can be different in both the tables.
Please relax the current criteria for Relationship or allow creation of Virtual Relationship between tables with multiple columns involved
Customer support service by UserEcho