README.md

In carljv/dwDBI: A DBI backend for data.world datasets

dwDBI: A DBI interface for data.world datasets

Intro

The dwDBI package provides:

1. A light DBI wrapper around the data.world API package. The benefit of this is that you can write SQL queries in RMarkdown chunks and evaluate them.
2. Contracts that let you browse data.world datasets with the RStudio Connections panel.

Querying data.world dataset in RMarkdown Notebooks

First import the package.

library('dwDBI')

Make sure that you've configured your data.world API key.

dwapi::configure('YOUR API KEY HERE')

To run a SQL query, connect to a data.world dataset with the dw_connect() function.

sql101_conn <- dw_connect('ryantuck/sql-101-training')

In RStudio, you can write and run SQL code chunks by specifying a connection option.

# ```{sql, connection=sql101_conn}
#     ... your query here ...
#```

Running the SQL code chunk returns a data frame.

select *
from customers
order by `last`

| id| first | last | |----:|:----------|:----------| | 14| Margaret | Atwood | | 2| Jane | Austen | | 12| Charlotte | Brontë | | 20| Emily | Brontë | | 0| Ernest | Hemingway | | 17| Victor | Hugo | | 10| Franz | Kafka | | 8| Jack | Kerouac | | 16| Harper | Lee | | 6| Vladimir | Nabokov |

RStudio Connections

You can also explore the tables in data.world datasets in the RStudio Connections pane. Just use the "New Connection" button in the pane, select the "Data.World" connection type, and enter the name of the dataset you want to view.

carljv/dwDBI documentation built on May 4, 2019, 7:36 a.m.