Question

LookR in Alpha

  • 2 December 2015
  • 7 replies
  • 84 views

  • Anonymous
  • 0 replies

Hey Scott,



While I haven’t played with the looker api too much, I am curious about this project.



Is the purpose simply to pull data into R via the looker api or to be able to construct models in R and let our Looker users user/interact with these models?



Thanks


Rick


7 replies

Userlevel 2

For those interested in some example code, here is some simple sample code.

Userlevel 2

sdhoover I tried your LookR package a month or so ago. I found it worked as promised. It is a little bit difficult though from thinking of querying in SQL terminology to the syntax to query the Looker model though.

Lira,



Check out Hadley & Co.'s Packages



Also, a good reference, though now a bit dated, is the R Import Export Manual



The R community on Stackoverflow is very active and could help you in this regard as well.



-Rick

Scott, I think having the ability to expose through Looker our work and models done in R would be amazing. This way, our business users can go to one single place, as opposed to getting reports from Looker and model outputs from, say, a Shiny dashboard.



Thanks!


Rick

Hey Scott, Truthfully, it would be the latter which we are after. We already have several ways of getting data from R to the database.

psyched to see what comes next



Hey Scott,


Would you recommend some good dictionaries for writing raw SQL queries from the R console?



Thanks,


Lira

Reply