Question

LookR in Alpha

  • 2 December 2015
  • 7 replies
  • 83 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

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.


Hey Scott,

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


Thanks,

Lira

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

Userlevel 2

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

Reply