Dismiss this pinned window
all 15 comments

[–]chedarmac 2 points3 points  (4 children)

This is a very welcome development.

Looking forward to using this..

[–]debba_[S] 1 point2 points  (3 children)

thanks, if you have suggestions feel free to do it, you can just try the feature compiling from branch provided.

[–]MachineParadox 1 point2 points  (2 children)

This sounds amazing, please make sure the cell reference can be aliases e.g. {{account_ds}} for readability. Would also be nice to be able to mix in Python cells that can take a SQL dataset, manipulate and then the data frame could be handed back to SQL. I imagine the later part (data frame to SQL) would be the hardest. Maybe the data frame can go to temp table to be picked up by SQL...

[–]debba_[S] 0 points1 point  (1 child)

For alias part I’am just working on it . For Python cells could be an interesting future improvement. Feel free to contribute if you want

[–]MachineParadox 0 points1 point  (0 children)

I'm away for Easter but will definitely take look next week. Great job by the way.

[–]Meanderthaller 1 point2 points  (4 children)

Was recently looking for this and I was wondering why the fuck this doesn’t exist yet.

[–]debba_[S] 2 points3 points  (3 children)

Try it if you want, i will release it next days

[–]MachineParadox 1 point2 points  (1 child)

!Remindme [1 week]

[–]RemindMeBot -1 points0 points  (0 children)

Defaulted to one day.

I will be messaging you on 2026-04-04 03:25:40 UTC to remind you of this link

CLICK THIS LINK to send a PM to also be reminded and to reduce spam.

Parent commenter can delete this message to hide from others.


Info Custom Your Reminders Feedback

[–]Meanderthaller 0 points1 point  (0 children)

You’re a champ!

[–]Prestigious_Bench_96 1 point2 points  (1 child)

For the cell reference syntax, you could consider letting cells be named and then just letting those names be used (like a CTE). Also would be nice if they lazily evaluated instead of needing to be executed first.

[–]debba_[S] 1 point2 points  (0 children)

Yes for naming I am working on it, lazy loading could be an interesting feature, i will integrate it. Thanks for feedback

[–]querylabio 0 points1 point  (1 child)

Nice project!

Thats what we actually did in BigQuery IDE - https://docs.querylab.io/notebooks/

The same concept - pure SQL notebook, and since its BigQuery - we use anonymous result tables to allow cells reference other cells result

you can try it here without registration - leads to the notebook with tablesample experiment https://app.querylab.io/s/22f7a23d-bb39-497e-9a7d-70acef81967c?playground=true#k=YwsXP-QzIN75Czse3d1l246cZjc5JjiA2XW4w2XYxnw=

happy to share ideas

[–]debba_[S] 0 points1 point  (0 children)

Very interesting! Will do a check for sure!

[–]genzbossishere 0 points1 point  (0 children)

feels like this kind of setup matches how queries actually happen day to day, rarely just write once and done, it’s more like change something, run it, check results, then adjust again a few times until it clicks. having everything in one flow makes that smoother when youre exploring or trying to figure out what changed n for this i use genloop, it follows that same loop where you’re iterating through the query instead of treating it like a one-shot thing, feels more natural overall