Hi everyone,
I am working on setting up a custom SQL query for a data source, but I can figure out how to set up variables for my query:
Is this possible?
Thanks in advance!
Eli
Hello Eli and thank you for your question!
The best way to set up a variable would be to create a parameter and to insert this into the query.
Please refer to the following links to gather further info on:
- Creating a parameter Creating dataset parameters in Amazon QuickSight - Amazon QuickSight
- Inserting a parameter into a custom SQL query: Insert dataset parameters into custom SQL - Amazon QuickSight
I hope this helps!
1 Like
Hi @eyagel ,
Did above steps work for you? Using dataset parameters you can pass selected parameter values to Custom SQL at runtime. I am marking this as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!
Hi @Neeraj, thanks for checking in.
What @mzerilli suggested did not solve my problem, I need a variable to run my SQL query and not to be able to customize my query based on a parameter the user changes.
I need a variable to hold a value so I can sum it.
@eyagel ,
QuickSight supports only select statements currently. Any custom SQL that you use to create a data set should also be a select query.
I need a variable to run my SQL query and not to be able to customize my query based on a parameter the user changes.
I need a variable to hold a value so I can sum it.
Execute the custom sql in the backend database and persist it as a table. Then bring the final table to QuickSight for visualisation. Otherwise elaborate more on your use-case and provide us a few examples as to what’s the requirement, we can then provide further guidance if possibilities exist.
Kind regards,
Koushik