could able to understand that we can use only select statement in the quicksight, is there is a way or workaround to execute stored procedure in the quicksight
Hi @Narendran - Welcome to AWS QuickSight Community and thanks for posting the question. I do not think QuickSight support stored procedure. However if your source database support materialized view, QuickSight can get the data from Views.
Tagging @Jesse and @Max for their expert advise as well.
Regards - Sanjeeb
@Sanjeeb2022 is correct and his workaround would be the way to go about it.
There are no abilities to use stored procedures currently in quicksight.
I can mark this as a feature request.