velociraptor icon indicating copy to clipboard operation
velociraptor copied to clipboard

Notebook functionality: Add object reference

Open mgreen27 opened this issue 4 years ago • 0 comments

The workflow of passing results from a cell to a new cell in notebook provides great capability for analysis.

Currently we can pass table results with:

SELECT * FROM source(
  notebook_id="N.xxx",
  notebook_cell_table=Y,
  notebook_cell_id="NC.ZZZ")

This requires a table to be generated in the referenced cell and can make notebook layout a bit clunky for heavy analysis. Workflow may be a summary output and calculations generated in the first cell whilst presentation and analysis in followup cells.

To enable this: An uplift of the capability would allow passing of an object from another cell and not require a table output. Something like:

Original cell: LET result_rows <= SELECT * FROM stuff

New cell to call object:

SELECT * FROM source(
  notebook_id="N.xxx",
  notebook_cell_object=result_rows,
  notebook_cell_id="NC.ZZZ")

mgreen27 avatar Mar 24 '21 02:03 mgreen27