dwapi (version 0.1.3.1)

sql: Execute SQL query against a dataset.

Description

Execute SQL query against a dataset.

Usage

sql(dataset, query, query_params = list())

Arguments

dataset

Dataset URL or path.

query

SQL query.

query_params

List of positional query parameters.

Value

Data frame with data from query results.

Examples

# NOT RUN {
  dwapi::sql(dataset="user/dataset",
    query="SELECT *
           FROM TableName
           LIMIT 10")

  dwapi::sql(dataset="user/dataset",
    query="SELECT *
           FROM TableName where `field1` = ? AND `field2` > ?
           LIMIT 10",
    queryParameters = list("value", 5.0))
# }