How to save to pre-existing Snowflake table from R using pool

Question

I am using pool to handle connections to my Snowflake warehouse. I have created a connection to my database and can read data in a pre-existing table with no issues e.g:

my_pool <- dbPool(odbc::odbc(),
               Driver       = "Snowflake",
               Server       = Sys.getenv('WH_URL'),
               UID          = Sys.getenv('WH_USER'),
               PWD          = Sys.getenv('WH_PW'),
               Warehouse    = Sys.getenv('WH_WH'),
               Database     = "MY_DB")

my_data<-tbl(my_pool, in_schema(sql("schema_name"), sql("table_name"))) %>% 
  collect() 

I would like to save back to a table (table_name) and I believe the best way to do this is with pool::dbWriteTable:

# Create some data to save to db
data<-data.frame("user_email" = "[email protected]", 
        "query_run" = "arrivals_departures", 
        "data_downloaded" = FALSE, 
        "created_at" = as.character(Sys.time()))

# Define where to save the data
table_id <- Id(database="MY_DB", schema="MY_SCHEMA", table="TABLE_NAME")

# Write to database 
pool::dbWriteTable(my_pool, table_id, data, append=TRUE)

However this returns the error:

Error in new_result(connection@ptr, statement, immediate) : nanodbc/nanodbc.cpp:1594: 00000: SQL compilation error: Object 'MY_DB.MY_SCHEMA.TABLE_NAME' already exists.

I have read/write/update permissions for this database for the user specified in my_pool.

I have explored the accepted answers here and here to create the above attempt and can't figure out what I'm doing wrong. It's probably something simple that I've forgotten to do - any thoughts?

---

EDIT: Wondering if my issue is anything to do with: https://github.com/r-dbi/odbc/issues/480