1 Install necessary libraries:

install.packages(c("RJDBC", "DBI", "dplyr"))

2 Load dplyr.snowflakedb

library(DBI)
library(dplyr)
library(RJDBC)
library(nycflights13)
library(dplyr.snowflakedb)
options(dplyr.jdbc.classpath = "C:/Users/snowflake_jdbc.jar")

3 Connect to your snowflakedb

my_db <- src_snowflakedb(user = "<user>", password = "<password>", account = "<account>", 
    opts = list(warehouse = "warehouse", db = "database", schema = "public"))