Combine SPICE datasets

[David_Wong]

Hi @Reena,

You’re hitting the same limitation that was discussed in these 2 topics:

Join tables releases error, due to exceed join memory, need to increase size of join

Hello All, could some one help on this please, this is very weird, how come join limit only 1GB? now we can’t reduce of join, or else if we remove it will breaks whole dashboard, how to increase join size to 10 GB, please error: QuickSight ran out of join memory while processing your request. To join between data sources, the smaller source tables combined can’t exceed the join memory limit of (1GB). The largest one, “accounts_users”, doesn’t count toward the memory limit. To…

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

Both of the dataset are coming from SQL queries, the issue is i dont want to make any changes on the query itself because it will affect other dashboards. I want to create a new dataset which contains both both dataset and use them to create a combined view.

To confirm it, add a filter to your 2nd dataset to reduce it to less than 1 GB and then try your join again.