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.