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 |