Integrations

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