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