get_sql: Get underlying sql for a Looker query.

In avantcredit/looker3: looker3 (http://github.com/abelcastilloavant/avant-looker3)

Description

This function assumes that you have set the environment variables LOOKER_URL, LOOKER_ID, and LOOKER_SECRET.

Usage

get_sql(model, view, fields, filters = list(), limit = 1000)

Arguments

model	character. The model parameter of the query.
view	character. The view parameter of the query.
fields	character. The fields parameter of the query.
filters	list or character. Either a named list, or a character vector using colons as separators each vector describing one of the filters of the query.
limit	numeric. The limit parameter of the query.

Details

The function will not allow the query to proceed unless you specify a model, a view, and at least one field.

Value

a simple string containing the SQL query.

Examples

## Not run: 
  query <- get_sql(model = "thelook",
                view = "orders",
                fields = c("orders.count", "orders.created_month")
                filters = list("orders.created_month" = "90 days", "orders.status" = "complete")
  )

  query <- get_sql(model = "thelook",
                view = "orders",
                fields = c("orders.count", "orders.created_month")
                filters = c("orders.created_month: 90 days", "orders.status: complete")
  )

## End(Not run)

avantcredit/looker3 documentation built on May 11, 2019, 4:06 p.m.