Description Usage Arguments Details Value
Read SQL scripts from a directory into R for use against a database.
1 | read_scripts(base_path, sqlvars, prefix, pattern)
|
base_path |
the directory holding the sql files |
sqlvars |
a list containing all variables you wish to set within your queries |
prefix |
a prefix from your SQL filenames if you want to remove before creating the data frames |
pattern |
a suffix to include in the data frame names |
Just place all scripts in the same directory with a .sql extension, and provide the directory path. It's also possible to set any variables in your query with the format of $variable.
sql.list returns a list of SQL queries with the future filename as the name
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.