Hi, i have two datasources in athena. I want to use both the data sources to visualise, but dataset creation allows to have single datasource. How can i do so?

you can refer to the video demos to see how to join data cross data sources https://www.youtube.com/watch?v=rNuq4hZHzEw you can also refer to this blog post Joining across data sources on Amazon QuickSight | AWS Big Data Blog

Hi @Harsxh When you create the dataset initially you can select one table from a datasource. But once in the dataset editor you can add additional tables. [image] You need to join the two tables using the join operators. Is this what you wanted? Regards, Giri

Hi @Giri, like in my athena i have two data sources which have different tables. When i am creating a dataset it is asking me to select a datsource. Doing this i am not able to select other one. I want to join table from both of the data sources

You would be able to do the join in the Quick Sight dataset after adding both the tables into the dataset.

Both tables are in different data source, how can i do then. It i want to use both data source i would be needing to create two datasets. But then how would i join them

Hi, i tried this but for me data is coming from different account so can’t use spice , i have to use direct query. But while adding dataset i am getting only spice option

Hi @Harsxh Please refer this article and see if this helps. [image] QuickSight Dataset Joins: Explained Articles In Amazon QuickSight you can create a (child) dataset by joining existing (parent) datasets together. When joining datasets in this way, there are some key c…

Both data will be uploaded into spice right? :thinking: from referring to this below link [Cross Source Joins]

Use two datasets in quicksight

Q&A

Giridhar.Prabhu February 1, 2025, 9:40am 8

Hi @Harsxh

Please refer this article and see if this helps.

Regards,
Giri

Topic		Replies	Views
Best Practise for managing datasets Q&A developer , quick-sight , qls-community	4	219	March 27, 2025
How do I join 1 dataset to two different datasets Q&A quick-sight	3	1355	July 24, 2023
How to Merge two datasets(direct query mode) with same fields from 2 different datasources into a single dataset Q&A data-source , quick-sight , dataset , data-preparation	8	1091	August 17, 2023
Is it possible to use fields from two different datasets and put into one visual? Q&A database , quick-sight , dataset , data-connectors , Business-Intelligence-Engineer	6	3041	October 11, 2023
Create table from multiple dataset Q&A feature-request , quick-sight , calculations , Business-Intelligence-Engineer	2	218	October 4, 2023

Use two datasets in quicksight

Related topics