andrewtorrance's avatar
andrewtorrance
Cloud Apps
06-19-2023
Status:
New Idea

Notebooks / Elasticubes - support full set of SQL

When connecting a notebook to an Elasticube, there is no indication what subset of SQL is expected to work

Simple features like setting

Cell 1 = select * from some_table

Cell 2 = select * from Cell1

give errors suggesting the WITH syntax is not permitted, which is a bit of an issue given how heavily notebooks rely on it.

There also seems to be limitations using ORDER/LIMIT in subqueries (which is fairly essential if CTEs arent allowed)

Any real use of Notebooks on Elasticubes seems quite far away without finishing this feature

No CommentsBe the first to comment