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
user
andpwd
are for your AWS IAM account; and the same as those you used to create the cluster withaws_db_redshift_create()
- id
(character) Cluster identifier. If you supply
id
, we'll fetchhost
,port
, anddbname
. Ifid
is not supplied. you have to supplyhost
,port
, anddbname
. Refer to this parameter definition inaws_db_redshift_create()
for more details.- engine
(character) The engine to use. optional if
user
,pwd
, andid
are supplied - otherwise required
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
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
if (FALSE) { # \dontrun{
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")
} # }