Quicksight query Procedure in custom SQL

Question & Answer
, ,
1

Hi,

We have a temp table in sql server that gets ingested dynamically. Will get that temp table situated in a stored procedure. Can the procedure be executed in Quicksight just as ’ EXEC Schema.Procedure’ under data preparation view?

2

Hi @NeerajIyer

QuickSight supports only select statements currently. Any custom SQL that you use to create a data set should also be a select query.
We have a product feature request in place to support stored procedures, however, we do not have an ETA on when it would be generally available.

1 Like