Description Usage Arguments Details Value Examples
This function assumes that you have set the environment
variables LOOKER_URL
, LOOKER_ID
, and
LOOKER_SECRET
.
1 |
model |
character. The |
view |
character. The |
fields |
character. The |
filters |
list or character. Either a named list, or a character
vector using colons as separators
each vector describing one of the |
limit |
numeric. The |
The function will not allow the query to proceed unless you specify a model, a view, and at least one field.
a simple string containing the SQL query.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | ## 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)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.