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.