How do we connect Azure Machine Learning Studio to Google BigQuery?

Question

We are trying to use Support Vector Machines to do predictions on our dataset but with just 70,000 rows and 7 features - we have tried an SVM on Google DataLabs but our data set is too big to calculate in any reasonable finite time on the DataLabs VM.

We would like to leverage an approach that scales statistical approaches across CPU cores like Revolution Analytics version of R on Azure Machine Learning Studio but our data is on Google BigQuery.

How do we connect an R script on Azure Machine Learning Studio to use our dataset on Google BigQuery?

Answer 1

You can pull the data from a "Execute Python script" module using a http request or google sdk for python (https://cloud.google.com/bigquery/exporting-data-from-bigquery). than add an "Execute R script" with your logic