db_query
Get data from a database query
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
| Argument | Description |
|---|---|
query
|
SQL query to execute |
connection_name
|
Name of the connection in config.yml |
...
|
Additional arguments passed to DBI::dbGetQuery |
Returns
A data frame with the query results
Examples
users <- db_query("SELECT * FROM users", "my_db")Source: R/queries.R