How to get the entire SQL query from QID in Synapse.

Copper Contributor

Hello,

I have QID of a query that ran for a long time. The SQL query is quite large and the table SYS.DM_PDW_EXEC_REQUESTS does not contain the entire sql for me to generate the explain plans. 

 

How can I get the entire SQL query using the QID in Synapse? 

 

Thanks!!

0 Replies