Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Question

LookR in Alpha

  • 2 December 2015
  • 7 replies
  • 88 views
A
  • 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

law
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.

L

Hey Scott,

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


Thanks,

Lira

Rick_Saporta

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

Rick_Saporta

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

Rick_Saporta

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.

Rick_Saporta

psyched to see what comes next

M
Rank
Userlevel 2

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

Reply


Terms of Service