snowflake

Connecting R and Snowflake with ADBC

Instructions

Prerequisites

1. Install R

2. Install dbc

3. Install R packages adbcdrivermanager, arrow, and tibble:

   install.packages(c("adbcdrivermanager", "arrow", "tibble"))

Connect to Snowflake

1. Install the Snowflake ADBC driver:

   dbc install snowflake

2. Customize the R script main.R

   • Change the connection arguments in adbc_database_init()
     • See Snowflake Driver Client Options for the full list of available options
   • If you changed the database and schema, also change the SQL SELECT statement in read_adbc()

3. Run the R script:

   Rscript main.R