Inner Join of Large Datasets in Quicksight

[harshmjh]

I want to inner join 2 datasets in quicksight , one having a size of 820 GB and other having around 160 GB . However i am getting error in quicksight saying secondary table must be less than 1 GB.

Any alternate approach to this if possible without modifying datapipeline or the respective tables ?

[Brett]

Hi @harshmjh and welcome to the Quick Suite Community!
Please review the previous thread attached below; and more specifically, Koushik’s response/solution, it is correct that any secondary dataset being joined cannot be larger than 1 GB:

Joining dataset is not allowed due to capacity[High Priority]

Hi @khkr999 - We need to understand the granularity of the data or else joining of the data sets will never get any result. Did you try to put filters at data sets and create custom data sets and then do the join… It is not a good approach but you can give a try. I will suggest to understand the data granularity first, that is very much important. Regards - Sanjeeb

[Xclipse]

Hi @harshmjh

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

[Xclipse]

Hi @harshmjh

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!