Dataset Query Parameters

Q&A
,
1

How can I create a dataset query parameter in the new version of QuickSight?

I have read this documentation: Optimize queries using dataset parameters in Amazon Quick Sight - Learn / Blogs - Amazon Quick Community, however I can not manage to do it.

image
image1915×732 21.5 KB

image
image1007×587 25 KB

2

Hello @01267ts, it looks like the issue you are facing is related to the dataset being ingested via SPICE. In order to take advantage of the dataset query parameters, you will need to pull in live data with direct query instead. That should resolve the error you are seeing!

3

image
image2539×882 76.6 KB

Thanks for the answer. However, it is still not working for me, I created an analysis from this dataset and created a parameter in the analysis called nodename. I changed also to Direct Query. It is not working. Do you know what is happening?

image
image2269×853 33.8 KB

4

Hello @01267ts

For troubleshooting purposes, could you please check the recently executed queries in Athena? You should be able to see there if anything in the query is unsupported by Athena, since your data source is Athena.

Thank you,

Shravya

5

Hello @01267ts, I am definitely curious what you find in Athena based on @shravya’s suggestion. Also, the formatting for the parameter is one $ after the first set of << and not one at the end. I am also curious, is the parameter a single value or multi value parameter? That changes how it can be implemented within the SQL statement.