Trying to connect the data across two different data sources (table from mysql db and table from postgreSQL db) in QuickSight. Both are using SPICE.
Individually, each of them works fine, but when I combine them to create another dataset, the data doesn’t gets loaded at all and hence can’t see anything while doing analysis.
Hi @Anshuman_Nanda - Welcome to AWS QuickSight community and thanks for posting the question. What is the data volume for each source? If it is a huge volume, possibly the result set may take time. Please give some more details on each of the data set like volume and joining conditions.
Regards - Sanjeeb
Hi Sanjeeb,
For now the data volume is in bytes. Hardly 500 rows in each dataset. Even then its not getting loaded… The refresh show 0 records refreshed…
Hi @Anshuman_Nanda - Ok. To do more troubleshooting, please raise a ticket to AWS Customer support team so that they can see this issue by screenshare. To raise the request, please follow the link - Creating support cases and case management - AWS Support
Also can you share the data set screenshot where you have applied the cross join.
Regards - Sanjeeb
Hi Sanjeeb,
I am part of AWS team itself. If you are part of AWS support, can you please connect with me over Slack?
Thanks in advance.
Hi @Karthik_Tharmarajan @Asem - Can you please over here?
Regards - Sanjeeb
Thanks but I think @Karthik_Tharmarajan is in US timezone, it will be late night around 3:00 AM for him now… anyone in APAC timezone of INDIA timezone?
solved . Join did not work because of a blankspace .
Thank you @Koushik_Muthanna for the detail 
hi Sanjeeb,
I am encountering an issue when attempting to join data from a data source. Within the logicalTableMap, there is a JoinInstruction field. Could you please advise me on what value I should specify for this field? I am using Lambda functions in conjunction with a MySQL database.
