Pushing processing to Snowflake


Can I push the processing into Snowflake using Rstudio Server?
I have been looking for information on what level of support there is for this.

What is your experience?

Thanks NordicLight

Where does the data live? If the data lives in snowflake originally, then yes, absolutely. If the data doesn't live in snowflake orginally, then still yes, but some extra steps would be required and there might be better options.

Use DBI and odbc packages to connect to the database. Then you can use dbGetQuery(con, 'query') to write a custom query and return the results, or you can load the dbplyr package, connect to a specific table using tbl() and do data transformations using regular old dplyr functions and once you're done transforming the data bring it into R using collect().

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.