Hi; I see related questions on the topic of sharing database connections in public notebooks, and I understand why that can be complex/risky.
I don’t especially need a public version of a notebook to actually run queries. But I’d like to work on a notebook iteratively using bigquery, modifying my queries as I go, before publishing the results for broader consumption. That is: I’d like the public version to carry the results of the last run.
I can see a simple way to work around this (e.g., save the data from the query, then upload the same data back into the same notebook?), but that requires manual intervention and perhaps a couple of errors on the public page if I want to keep the queries in place for readers.
I’ve been using observable for ~24 hours, and I love it so far. Perhaps I’ve missed something obvious! Is there a no-brainer way of sharing the results of database queries in public notebooks without the errors?