bigQueryR | R Interface with Google BigQuery | GCP library

by cloudyr R Version: v0.5.0 License: Non-SPDX

X-Ray Key Features Code Snippets(1)Community Discussions(3)Vulnerabilities Install Support

kandi X-RAY | bigQueryR Summary

bigQueryR is a R library typically used in Cloud, GCP applications. bigQueryR has no bugs, it has no vulnerabilities and it has low support. However bigQueryR has a Non-SPDX License. You can download it from GitHub.

This is a package for interacting with BigQuery from within R. See the bigQueryR website for examples, details and tutorials.

Support

Quality

Security

License

Reuse

Support

bigQueryR has a low active ecosystem.

It has 38 star(s) with 13 fork(s). There are 5 watchers for this library.

It had no major release in the last 12 months.

There are 10 open issues and 45 have been closed. On average issues are closed in 100 days. There are 1 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of bigQueryR is v0.5.0

Quality

bigQueryR has no bugs reported.

Security

bigQueryR has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

License

bigQueryR has a Non-SPDX License.

Non-SPDX licenses can be open source with a non SPDX compliant license, or non open source licenses, and you need to review them closely before use.

Reuse

bigQueryR releases are available to install and integrate.

Installation instructions, examples and code snippets are available.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of bigQueryR

Get all kandi verified functions for this library.

bigQueryR Key Features

No Key Features are available at this moment for bigQueryR.

bigQueryR Examples and Code Snippets

bigQueryR,Installation

Lines of Code : 6

License : Non-SPDX (NOASSERTION)

Copy

# latest stable version
install.packages("bigQueryR", repos = c(getOption("repos"), "http://cloudyr.github.io/drat"))

if(!require("ghit")){
    install.packages("ghit")
}
ghit::install_github("cloudyr/bigQueryR")

Community Discussions

Trending Discussions on bigQueryR

How to authenticate with service account and bigrquery package?

Connecting to BigQuery in RShiny

How to list more than 50 tables with bigQueryR::bqr_list_tables?

QUESTION

How to authenticate with service account and bigrquery package?

Asked 2019-Sep-09 at 17:41

I have been able to authenticate using the json file associated with a service account using googleAuth and bigQueryR.

...

ANSWER

Answered 2017-Mar-02 at 11:05

You can use the function set_service_token()in bigrquery to authenticate with the same service JSON you use in bigQueryR

Source https://stackoverflow.com/questions/42410147

QUESTION

Connecting to BigQuery in RShiny

Asked 2019-Aug-14 at 14:59

I've tried two methods to connect my Shiny app to a BigQuery table as its source data:

Hadley's bigrquery, and
Mark Edmondson's BigQueryR

They're both failing the same way, so it's clearly a DFU error.

In each case, when I execute the appropriate command to establish the authorized connection (gar_auth_service(json_file = /path/,scope = 'https://www.googleapis.com/auth/bigquery' and bq_auth(path = /path/, respectively), I get this:

This site can’t be reached localhost refused to connect. Try:

Checking the connection Checking the proxy and the firewall ERR_CONNECTION_REFUSED

This error comes after what appears to be a normal Google login process in the browser. The error page is hosted at localhost:1410, if that's any help.

In the Console, I have:

Created a VM instance (Ubuntu 19)
Successfully installed R, RStudio, and Shiny
Successfully logged in to RStudio in my GCP instance (from the browser, obviously, using the Externa IP I reserved in GCP)

I've also already created a BigQuery table in the same project, and successfully connected to it from an R script on my local machine.

I'm trying to get that same R script to run grom my Google Compute Engine instance.

Have I provided enough details to ask for help? If not, let me know what else I should provide. I'm walking through teaching myself GCP right now, and I'm quite the novice.

Thanks!

...

ANSWER

Answered 2019-Aug-14 at 14:59

To bypass this issue, try connecting to your Ubuntu 19 instance using Chrome Remote Desktop on your Compute Engine instance as documented here.

Chrome Remote Desktop allows you to remotely access applications with a graphical user interface from a local computer instead of using the External IP. For this approach, you don't need to open firewall ports, and you use your Google Account for authentication and authorization. I've tried and I was able to connect both Shiny Server and to the RStudio.

Source https://stackoverflow.com/questions/57434106

QUESTION

How to list more than 50 tables with bigQueryR::bqr_list_tables?

Asked 2017-Mar-02 at 02:27

I am using the package bigQueryR, and in particular the function bqr_list_tables to get a list of all tables in a dataset in Google Big Query.

My issue is I only get 50 tables when I would ideally like to get them all so I can regex out the ones I want programmatically.

bqr_list_tables only takes two arguments, the datasetId and projectId. Is there any way to accomplish this restricting myself to this package?

I'm using version ‘0.2.0’ of bigQueryR

Edit:

...

ANSWER

Answered 2017-Mar-02 at 02:27

Instead of installing the latest github version, I just directly used the following code from the repo https://github.com/cloudyr/bigQueryR/blob/master/R/tables.R, no issues and works as prescribed.

Source https://stackoverflow.com/questions/42404295

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install bigQueryR

This package is on CRAN, but to install the latest development version you can install from the cloudyr drat repository:.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: