Solved

Enable MDA Joins


Userlevel 7
Badge +3
I raised this issue to support, but figured I'd come to the community as well in case I get a quicker response.



I want to enable an MDA table to use joins, but do not seem to have the capability on a particular table.



This document https://support.gainsight.com/Product_Documentation/Data_Management_and_Integrations/Managing_Data_I... says "Note: Currently, we support creation of lookup relation only on MDA objects for which joins are allowed."

But it does not tell me how to enable joins on an MDA table where Allow Joins is set to false.  I cannot seem to find this explained anywhere else either.  Hopefully I have just overlooked it.



See attached image.  Support Health Scorecard table shows Joins Allowed = true, but Predictive Health Scorecard shows Joins Allowed = false.  Any guidance?



icon

Best answer by steve_davis 27 May 2016, 22:40

View original

7 replies

Hello Jeff, even though your application has been migrated to Redshift data store, some object reside in Redshift and some in MongoDB. Primarily all objects having large number of records have been migrated to reside in Redshift from MongoDB data store for query performance. 



Currently, we allow joins on those objects which are residing in Redshift, hence the "Joins allowed" property is true for them and those object which are still in MongoDB are non-joinable as MongoDB do not support joins.

 
Userlevel 7
Badge +3
can I get this table migrated to Redshift?
Not a trivial task as the business logic & query depends on the object location. Quick solution that I can think of is to create a custom object via Data Management that has all the fields you need from this object and schedule a rule to populate this custom object. That custom object would allow joins.



I would discuss with team and post it if any better solution is there.
Userlevel 7
Badge +3
This was a custom created object. Created several months ago. Was there a point in time when new MDA objects started getting created in Redshift?
Jeff,



Ajit and I would to setup a call with you and answer your questions on this. Going to send you an email. In addition to this, we would also like to discuss about our additional Joins options that we are going to introduce as part of Bionic Rules.



  
Userlevel 5
Badge +2
Pretty sure we migrated this table over to Redshift to solve this issue. Is this correct, Jeff?
Userlevel 7
Badge +3
Yes that's correct

Reply