Hello All,
I am using redshift direct query mode for dataset. Using this dataset I have created dashboard. As I know quicksight generates query for every visual. Is there any table where I can see this query . As I am facing data issue for that visual . I wanted to check what query quicksight has generated for that visual.
Hi @Rohit_Nikam,
To analyze the queries that QuickSight is generating, you should be looking at the query history of the data source that you connect to, i.e., in your case Redshift. One simple way is to use the Query and Database Monitoring capability within the AWS Management Console.
At the beginning of the query you’ll also see some meta information that QuickSight adds in form of a comment, e.g., the entity (dashboard or analysis), sheet, and visual ID.
Did this answer your question? If so, please help the community out by marking this answer as “Solution”!
Hi @Thomas ,
I have checked in Query and Database Monitoring but there I am not getting complete query
Hi @Rohit_Nikam
QuickSight doesn’t expose the underlying language it uses to define each visual or KPI.
SPICE datasets run entirely in memory, after ingestion no SQL is sent to your database at runtime, only the ingestion query is logged.
For Direct Query datasets, the SQL statements that are fired can be captured in your source engine’s query logs.
Custom SQL used in a dataset is retrievable using list datasets with ListDataSets, call DescribeDataSet, read the CustomSql field, and save it to S3 for cataloging.