sql: Execute SQL query against a dataset.

In dwapi: A Client for 'data.world' REST API

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))

## End(Not run)

dwapi documentation built on May 1, 2019, 11:18 p.m.