Show execution plan for SQL script queries

Highlighted
antonstam
Level 2
Show execution plan for SQL script queries
Jump to solution

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

Accepted Solutions
Highlighted
ATsao Dataiker
Dataiker
Re: Show execution plan for SQL script queries
Jump to solution

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
Highlighted
ATsao Dataiker
Dataiker
Re: Show execution plan for SQL script queries
Jump to solution

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