Show execution plan for SQL script queries

Solved!
antonstam
Level 3
Show execution plan for SQL script queries

I'd like to see the execution plan for some script recipes I've written. I can retrieve the execution plan for SQL query recipes, but SQL scripts do not offer this functionality. Is there a workaround to see the execution plan?

I've already tried SET SHOWPLAN_TEXT ON in a SQL notebook, but that doesn't seem to make a difference for the results returned. I've looked at the backend log for the execution plans for query recipes: they mention a call to a get-execution-plan API which I could perhaps talk to if I know how to access it.

I could paste the script into SSMS, but I'd like to know if it's possible from Dataiku as well.

0 Kudos
1 Solution
ATsao
Dataiker

Hi,

Unfortunately, this is not possible through Dataiku right now. As you've alluded to, we would recommend copying the script to SSMS as a potential alternative/workaround for now. 

Thanks,
Andrew

View solution in original post

0 Kudos
1 Reply
ATsao
Dataiker

Hi,

Unfortunately, this is not possible through Dataiku right now. As you've alluded to, we would recommend copying the script to SSMS as a potential alternative/workaround for now. 

Thanks,
Andrew

0 Kudos