@rbh Welcome to RStudio Community!
In general, you can define an environment variable in R using the pattern Sys.setenv("varname" = "value"), e.g. the code below defines a new environment variable named EXAMPLE:
Sys.getenv("EXAMPLE")
## [1] ""
Sys.setenv("EXAMPLE" = 3)
Sys.getenv("EXAMPLE")
## [1] "3"
Thus for the vroom error, I'd recommend trying to double the default buffer size by running the following prior to trying to read the file:
Sys.setenv("VROOM_CONNECTION_SIZE" = 131072 * 2)
And if you find yourself having to do this often, you can set this environment variable by default by creating the file .Renviron in your home directory with the following contents:
VROOM_CONNECTION_SIZE=262144
I don't actually know what a reasonable buffer size is for vroom, so you might need to experiment with different values.