New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

Show execution plan for SQL script queries

Solved!
antonstam
Level 3
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
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
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
A banner prompting to get Dataiku DSS