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.
Best Answer
-
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