db_query: Get data from a database query
In framework: Structured Data Science Project Scaffolding
db_query R Documentation
Get data from a database query
Description
Gets data from a database using a query and connection name. The connection
is created, used, and automatically closed.
Usage
db_query(query, connection_name, ...)
Arguments
query
SQL query to execute
connection_name
Name of the connection in config.yml
...
Additional arguments passed to DBI::dbGetQuery
Value
A data frame with the query results
Examples
if (FALSE) {
users <- db_query("SELECT * FROM users", "my_db")
}
framework documentation built on Feb. 18, 2026, 1:07 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
| db_query | R Documentation |
Get data from a database query
Description
Gets data from a database using a query and connection name. The connection is created, used, and automatically closed.
Usage
db_query(query, connection_name, ...)
Arguments
query |
SQL query to execute |
connection_name |
Name of the connection in config.yml |
... |
Additional arguments passed to DBI::dbGetQuery |
Value
A data frame with the query results
Examples
if (FALSE) {
users <- db_query("SELECT * FROM users", "my_db")
}
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.