Connect to DB in R and query

PHOTO EMBED

Mon May 30 2022 12:30:42 GMT+0000 (Coordinated Universal Time)

Saved by @Treenose #r #sql

library(DBI)
connection <- dbConnect(RMySQL::MySQL(),
                 dbname = "name",
                 host = "adress.amazonaws.com",
                 port = number,
                 user = "id",
                 password = "pw")
info <- dbGetQuery(connection, "SELECT column1 FROM database WHERE argument = something")

info
content_copyCOPY

Worked on Datacamp tutorial: https://campus.datacamp.com/courses/intermediate-importing-data-in-r/importing-data-from-databases-part-2?ex=8