DB Connection SQL Cell not connected to other SQL Cells not linked in dataflow
As you can see in the picture attached from my notebook data flow the cell where I create my DB connection is not linked to the SQL cell below it. This is to be expected because these two cells don't share variables but at the same is wrong because these cells depend on each other for execution. I don't know what a good solution for this is at the moment.
I think I suggested in another post to have a DB connection tab on the left side menu, this wouldn't solve this particular issue but might be beneficial. @Myles Scolnick
10 Replies
Someone will reply to you shortly. In the meantime, this might help:
this does seem like a bug
does the full
ATTACH looks something like ATTACH 'dbname...' as db?It does yes, I actually saw in a different notebook that the db objects gets returned under the hood, I’ll dig some more later
What are your thoughts on having a db connection section in the data sources menu?
Yea happy to add something. What are you thinking exactly? Viewing active connection? Or a gui for creating connections?
What do you mean by “Viewing activity connects”?
Sorry on the phone, “viewing active connections”
I’m thinking of more of a GUI I guess, in functionality it would replace the ATTACH cell and also show status, and yeah show active connections
And also I would tidy up all the tables that are shown when attaching a db, currently you get lots of:
- db.schema1.a
- db.schema1.b
- db.schema2.a
Etc, I’d make those collapsible
I actually think this could be a nice first issue for me to look at if you’re open to it, perhaps two issues: nicer presentation of remote data sources and db connection mini gui
I might need more help on the 2nd but we’ll see
Yea we would really appreciate the contribution!
And we can pair on it to if needed.
First one sounds good to me. For the second one, the tricky part is making sure the notebook still contains the connection information, so when shared, they can connect to the db as well.
Maybe the GUI at first just creates the cell for you (similar to how the snippets panel creates cells for you). And then can be improved?
That sounds good to me! I'll let you know if I encounter issues, how do you usually go on about pairing?
We could pair live if you wanted or just pass PRs back and forth or just push to the same branch