I would like to create multiple datasets from one recipe, written with code. The multiple ouptuts should be diplayed in the flow.
The question stands both for SQL and Python recipe.
I currently only managed to create multiple tables with one SQL recipe but they are not showing up in the flow. Only available in database.
If you are creating a "sql script" recipe, then you should be able to specify multiple outputs either when creating the recipe initially or from the Inputs/Outputs tab of the recipe. Please refer to the attached screenshots.
The same concept should also apply to python recipes as well.