Hello,
I have three tables that I am looking to add to a dataset. However, the relationships of the tables is as follows:
Table A → Table B → Table C
I am finding that Quicksight forces me to make one table as primary and the other tables I join simply link to table A. So it becomes
Table A → Table B
Table A → Table C
Am I missing something? Is it possible to write a join manually in SQL or do I have to use the UI when creating a dataset?
Hi @anandds,
There are a few different ways you can do this.
You should be able to join A to B and B to C like this:
QuickSight also allows you to join datasets, so another option is to join A to B first, and then join the resulting dataset with C.
If you want to write your own query, choose “Use custom SQL” when creating your dataset.
Hi David,
I am glad to hear we can do this, but I am unable to find a way to join the way you have shown. Where do I need to click to be able to join the way you have shown in the picture?
Anand
Hi @anandds
Click on Edit dataset and then “Add data” and then select dataset or data source from where you want to add the other datasets. Screen shots are attached for your reference.
You missed the point. How do I add one more source, say source_test_2, to have a join between source_test and source_test_2. Right now when I do it, the join is between source and source_test_2 and I have no option to change it. David has done it correctly, but he did not tell me how.
I figured it out. I use the handle on top of the table box and move it around. Thank you for responding to my question.
Great so you were able to join multiple tables in QS?
Yes. I was able to do join multiple tables.
