I’m having an issue in Amazon QuickSuite and wanted to check whether this is a known limitation.
I uploaded an Excel file and joined it with a Custom SQL dataset that uses dataset parameters. The join itself seems to work, but I can’t save the dataset afterward.
My guess is that this happens because the Excel file is handled in SPICE, while Custom SQL with dataset parameters is only supported in Direct Query. So once the Excel file is involved, the joined dataset may no longer support the parameterized SQL.
Has anyone seen this before? If so, is there any workaround, or is the only practical solution to move the Excel data into a database and do the join there?
Yes it is a known limitation. QuickSuite doesn’t support dataset parameters using SPICE. I have faced this too. You are right that you need to move your excel file into database and do a join.
May be you can upload the Excel file to Amazon S3 and create a table for it in Amazon Athena. Then you can join your main database with this one. This allows you to use Direct Query and Parameters.
It’s very helpful to know this is a known limitation and that dataset parameters are not supported with SPICE. Your explanation matches what I was seeing.
About uploading the Excel file to S3 and creating an Athena table sounds like a good approach, especially since I need to build many similar joined datasets/dashboards.
I’ll try this setup next.Thanks again for your advice!