Soon as I add the 4th table, I start to get this error, but when I remove the table, the rest of the data works fine.
1 Like
Hi,
We used many tables in dataset but no issue.
In your case you can check the field/column mapping and data type of a table which create issue.
In my experience, if you are using the database at the backend. Simple create view of your query and create dataset. It will simply upload your data and you can use the features of SQL too .
Regards,
Naveed Ali
2 Likes
Hi @Clayton_Barton - The 4th table is from a different data source? Please confirm, if all data sources are not same data source , i believe you should use SPICE or make the 4th data source in SPICE and then do the join.
Also if possible, you can also follow @Naveed approach to have a view at DB layer and use the view for reporting.
Regards - Sanjeeb
1 Like
@Clayton_Barton - You should ideally be able to mix data from multiple sources within a dataset without any issue. So, I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!
Regards,
Arun Santhosh
2 Likes
Thanks @ArunSanthosh - Can we do a join with different data sources without SPICE. Although I will do a POC, just checking with you on this Quickly. If yes, How QuickSight is processing this operation? Any details will really appreciated?
Regards - Sanjeeb
1 Like
Hi @Sanjeeb2022 - Different data sources are handled in SPICE. When you bring in a different data source and define the join, QuickSight will automatically change the query mode to SPICE.
Regards,
Arun Santhosh