CODEWITHSUNDEEP
google-bigquery
user1759859
user1759859

Reputation: 21

Can you build and run models and statistical functions in Google's BigQuery?

How can you develop or use statistical functions in Google's BigQuery? Can you run Java, PHP, R, etc on the Google platform, or does it mainly support only SQL type features?

Upvotes: 2

Views: 401

Answers (3)

Rohit
Rohit

Reputation: 3157

If Python is a choice, the Pandas library has a very simple connector for reading and writing into BigQuery. Look for Pandas.read_gbq.

Upvotes: 1

David M Smith
David M Smith

Reputation: 2332

I just started using R and was also interested in connecting to BigQuery from there as well. Unfortunately the BigQuery client for R referenced here has been taken down.

I did happen to find a link to the connector in the CRAN archive though I haven't started testing it yet.

Upvotes: 0

Jordan Tigani
Jordan Tigani

Reputation: 26617

Google BigQuery supports a very limited set of statistical functions (avg, variance, quantiles). If you want to use R, Java, etc, you need to extract the data first. There is an open source JDBC driver that you can use from Java, or you can use the BigQuery client libraries. As for R, there have been a couple of examples of people writing an R connector to perform BigQuery queries and manipulate the results as an R data frame but I don't know any details.

Upvotes: 1

Related Questions