I’m fairly new to Athena and Quicksight, I’m trying to connect Athena to Quicksight and while creating the dataset I would like to perform a join operation. Can join operation be performed on Athena using Quicksight ? And if not what will be the best way to join the data.
Hi @hsurolia - Welcome to AWS Quick Sight community and thanks for posting the question. Yes, you can bring the data sets from Athena and do the join operation in Quick Sight. If all data sets are from Athena, you can also write a custom sql and run the custom sql by connecting athena from quicksight.
Regards - Sanjeeb
Hello @Sanjeeb2022 Thanks for the reply. One question about the custom sql, if I write a custom sql then a) will the sql run on the source and data will be pulled into quicksight or b) The data will be pulled into quicksight and then the custom sql will run on quicksight.
Thanks - Harshvardhan
Hi @hsurolia - The custom sql will execute in source and the result set will be pulled to Quick Sight.
Regards - Sanjeeb