roost
roost2mo 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.
1 Reply
Akshay
Akshay2mo ago
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?