SQL Notebook multiple result sets

sylvyr3
sylvyr3 Registered Posts: 21 ✭✭✭✭

Is there a way to retrieve multiple results sets from a SQL query in a SQL notebook?

I'm calling a stored procedure that returns multiple results but I'm only seeing the first result set.

Answers

  • Sarina
    Sarina Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 317 Dataiker

    Hi @sylvyr3
    ,

    If you want to see multiple SQL results, you would need to create a new query for each new output you want to see:

    Screen Shot 2023-04-04 at 5.58.02 PM.png

    Each query within a notebook can output a different result. Indeed it is the case that an individual query can only output one result output.

    Thanks,
    Sarina

Setup Info
    Tags
      Help me…