# Connect Datasets without joining

**URL:** <https://community.amazonquick.com/t/connect-datasets-without-joining/34608>\
**Category:** Q&A\
**Tags:** data-source, Business-Intelligence-Engineer, dataset, quick-sight\
**Created:** [September 3, 2024, 12:53pm UTC](https://community.amazonquick.com/t/connect-datasets-without-joining/34608 "2024-09-03T12:53:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![JuliaFee](https://avatars.discourse-cdn.com/v4/letter/j/b3f665/32.png) [@JuliaFee](https://community.amazonquick.com/u/JuliaFee)\
**Post date:** [September 3, 2024, 12:53pm UTC](https://community.amazonquick.com/t/connect-datasets-without-joining/34608/1 "2024-09-03T12:53:28Z")

</div>

I would like to connect data from different datasets.  
Most of our datasets come as S3.  
If I join the datasets, the join contains all the columns of both datasets. If I do not need all of these columns, i have to exclude the fields I do not want to see.  
Is there any other option than to joining and excluding, such as querying?

---

<div class="post-metadata">

**Author:** ![awsvig](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/awsvig/32/32522_2.png) [@awsvig](https://community.amazonquick.com/u/awsvig)\
**Post date:** [September 3, 2024, 1:20pm UTC](https://community.amazonquick.com/t/connect-datasets-without-joining/34608/2 "2024-09-03T13:20:04Z")

</div>

Hi @JuliaFee – Did you explore using [Athena as a datasource](https://docs.aws.amazon.com/quicksight/latest/user/create-a-data-set-athena.html) in quicksight? Using Athena you can customize your query to specify the data you want to use in quicksight.