knitsql: DBI/SQL knitr engine for R

Description Details

Description

Call library(knitsql) to automatically register a sql knitr engine. This allows you to create R Markdown code chunks that contain SQL queries.

Details

TODO: Improve these docs

Specify the connection either in R Markdown metadata, or by creating a DBI connection object in a prior R code chunk and pass it as the conn object.

Use the knitr chunk name to assign the results to a variable.

You can bind R variables to parameters in the SQL query by using ?varname.


jcheng5/knitsql documentation built on May 18, 2019, 10:22 p.m.