How to get SQL cells to execute after another cell (dataflow)

I have a dataloading process in one cell, and a SQL query in another. When I refresh the page the SQL cell is broken, because the data loading process has not occured. I tried adding /* ${dataloader} */ and suchlike to form a dataflow dependency, by the SQL cell inserted at ? into the query and chokes on the number of arguments passed to the prepared statements.

What’s the simplest way to form a dataflow dependency on a SQL cell?

OK in my case I was using a cell as a client so I could create a new client, which was really jsut the same reference to the first, but mix in the dataflow dependency there (see top cell). Now my notebook works correctly on page load!

2 Likes