bigrquery icon indicating copy to clipboard operation
bigrquery copied to clipboard

Rstudio ui connection

Open byapparov opened this issue 5 years ago • 10 comments

Closes #298

byapparov avatar May 09 '19 23:05 byapparov

Something is wrong with this PR — it's showing much more in the diff than I'd expect.

hadley avatar Jun 18 '19 13:06 hadley

Something is wrong with this PR — it's showing much more in the diff than I'd expect.

@byapparov Would you rebase this branch on master and force push this branch? That should make a smaller, cleaner diff.

jennybc avatar Jun 18 '19 20:06 jennybc

@hadley I have used this documentation to implement it: https://rstudio.github.io/rstudio-extensions/connections-contract.html

BigQuery objects need to be linked to this contract, which kind of makes sense.

Let me know if you know of a better way.

byapparov avatar Jun 18 '19 20:06 byapparov

@jennybc I don't think I see what you see. When I look at changes in GitHub, all seems relevant to this PR.

byapparov avatar Jun 18 '19 20:06 byapparov

Hmm, I was just providing instructions from a general point of view. If the diff looks correct and minimal to you, then so be it.

jennybc avatar Jun 18 '19 20:06 jennybc

np, I think it will help if you try to select data from BigQuery in Rstudio to see what this is doing.

e.g. you need to run dbConnect() which should bring list all the projects, datasets and tables from your Organisation in Connections panel.

devtools::install_github("byapparov/bigrquery", ref = "rstudio-ui-connection")
con <-  dbConnect(bigquery(), project = "your-project-name")

byapparov avatar Jun 19 '19 08:06 byapparov

I am also trying to get the snippet for connection work based on this: https://db.rstudio.com/advanced/snippets/ https://rstudio.github.io/rstudio-extensions/rstudio-connections.html#snippet-files

Do you think it would be useful to default project to what is set in env variable, e.g. BIGQUERY_PROJECT ?

byapparov avatar Jun 22 '19 13:06 byapparov

Just to say this somewhere @byapparov, there will be another update to bigrquery, at the very least, when I rework its request and response handling to use gargle. We needed to get v1.2.0 out, to get the auth transition rolling, but there will be more chances for your PRs to play out and hopefully be incorporated. We needed to switch the default oauth app, in order to use one from a verified GCP project, with a proper consent screen and privacy policy.

jennybc avatar Jul 02 '19 19:07 jennybc

No problems, it is good to see the package moving in all directions.

We can work with the fork for some time.

On the code reviews, I understand you are busy and my expectations are low. It feels like you would benefit from more maintainers to do reviews and approve.

I appreciate all the work that is done here, it's truly amazing )

byapparov avatar Jul 03 '19 16:07 byapparov

Thanks for the PR, it works fine.

meztez avatar Jan 28 '21 23:01 meztez

Closing in favour of #431

hadley avatar Nov 07 '23 22:11 hadley