SQL Notebook multiple result sets
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 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:
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