DetachHead
Ignore %sql cells
Description
basedpyright type checks %sql cells in jupyter notebooks, which leads to unnecessary errors
If you give me a hint where to do this in the source, I could do a PR, I do TypeScript once in a while
i'm not very familiar with jupyter notebooks. is this what you mean by %sql cells?
pylance seems to have the same issue: https://github.com/microsoft/pylance-release/issues/4969
interestingly, this other syntax with %%sql seems to work but %sql doesn't:
In databricks you're allowed to do cells like this:
%%sql is not the same in databricks, one should use %sql
could you provide a bit more info please? what exactly is the difference between % and %%? is databricks a separate thing to notebooks? a link to some relevant docs would probably also be helpful, thanks
Hi there Databricks seems to be a bit exotic here in that it uses %sql fot the whole cell, other implementations just use %%sql. But maybe we can just treat any cell as non-pyhthon cell that starts with %?
https://docs.databricks.com/aws/en/notebooks/notebooks-code#explore-sql-cell-results