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().