Get help from the marimo community

Updated 2 months ago

SQL cells outputting data frames fail to work in dependency tree

Hello!

Problem: Following a kernel reset and full auto run, my SQL cells (not python cells) outputting a dataframe fail to work causing downstream execution issues.


  • Even though my DF output cells were referenced by downstream cells, meaning they should have run in-order, some downstream cells didn't find the dataframe.
  • To resolve this, I had to do an if not None statement before the downstream cells ran.
  • This required that I convert other SQL cells to python cells, which is not ideal
Ideally, I could create DFs with SQL cells and the downstream dependent cells would execute at the right time.
A
1 comment
SQL cells should be reactive -- a dataframe defined in it should trigger execution of downstream cells. This is a bug if it's not working. Can you share a small notebook where you see the behavior not working if it's not too much trouble?
Add a reply
Sign up and join the conversation on Discord