sql: Execute SQL query against a dataset.

In datadotworld/dwapi-r: A Client for 'data.world' REST API

Description

Execute SQL query against a dataset.

Usage

sql(owner_id, dataset_id, query, query_params = list())

Arguments

owner_id	User name and unique identifier of the creator of a dataset or project
dataset_id	Dataset unique identifier
query	SQL query.
query_params	List of positional query parameters.

Value

Data frame with data from query results.

Examples

## Not run: 
  dwapi::sql("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)

datadotworld/dwapi-r documentation built on July 3, 2021, 3:40 a.m.