Submit your innovative use case or inspiring success story to the 2023 Dataiku Frontrunner Awards! LET'S GO

SQL Notebook multiple result sets

sylvyr3
Level 3
SQL Notebook multiple result sets

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.

0 Kudos
1 Reply
SarinaS
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

 

0 Kudos