Show execution plan for SQL script queries

Options
antonstam
antonstam Partner, Registered Posts: 25 Partner

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

  • ATsao
    ATsao Dataiker Alumni, Registered Posts: 139 ✭✭✭✭✭✭✭✭
    Answer ✓
    Options

    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

Setup Info
    Tags
      Help me…