aws_db_rds_con {sixtyfour} | R Documentation |
Get a database connection to Amazon RDS
Description
Supports: MariaDB, MySQL, and Postgres
Usage
aws_db_rds_con(
user = NULL,
pwd = NULL,
id = NULL,
host = NULL,
port = NULL,
dbname = NULL,
engine = NULL,
...
)
Arguments
user , pwd , host , port , dbname , ... |
named parameters passed on to
DBI::dbConnect. Note that
the |
id |
(character) Cluster identifier. If you supply |
engine |
(character) The engine to use. optional if |
Details
RDS supports many databases, but we only provide support for MariaDB, MySQL, and Postgres
If the engine
you've chosen for your RDS instance is not supported
with this function, you can likely connect to it on your own
Value
an S4 object that inherits from DBIConnection
See Also
Other database:
aws_db_cluster_status()
,
aws_db_instance_status()
,
aws_db_rds_create()
,
aws_db_rds_list()
,
aws_db_redshift_con()
,
aws_db_redshift_create()
Examples
## Not run:
con_rds <- aws_db_rds_con("<define all params here>")
con_rds
library(DBI)
library(RMariaDB)
dbListTables(con_rds)
dbWriteTable(con_rds, "mtcars", mtcars)
dbListTables(con_rds)
dbReadTable(con_rds, "mtcars")
library(dplyr)
tbl(con_rds, "mtcars")
## End(Not run)