Hello
I am trying to join two dataset in spice, and i keep getting the issue mentioned in the picture.
Can you please advice on what should be done?
Please note that I tried to filter one of the datasets before joining and it is still not working.
Thanks
Hi @khkr999 - What is your source of the data sets? If it is relational, can you use custom sql and restrict the data set? And also check the joining conditions, if there is a many to many relation (M:M), possibly cartesian joining happening. Please validate the granularity of the data sets as well.
Hi @David_Wong @Naveed - Please provide your advise as well on this context.
Regards - Sanjeeb
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.
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
@khkr999 ,
You are hitting the cross join limitation : Joining data - Amazon QuickSight [Search for : How large can joined data be? ]
From the blog : Joining across data sources on Amazon QuickSight | AWS Big Data Blog
" There is no size restriction on your largest source, as long as the post-join table can fit into your SPICE capacity per data set. The rest of the tables together need to be within 1 GB in size. For example, if you have 20 numeric columns in your smaller table, you can fit about 5 million rows until you exceed the 1 GB memory limit."
1/To avoid this error please make sure only one data source is more than 1GB.
2/Both are SQL queries (same datasource) : write a custom sql which includes both SQL queries and builds the final output. Load into SPICE.
Kind regards,
Koushik
Hello,
can you please tell me how to check the GB for each dataset.