I have read a few issues on github relating to write speed, but I have not found a workaround for the problem.
I currently have a 2.5MB file I would like to write to Azure. Below is an example of the code I am using.
The problem is the the write time is close to 40mins! What can I do to speed up the write speed?
# connect to Azure
con_azure <- DBI::dbConnect(odbc::odbc(), Driver = "SQL Server Native Client 11.0",
Server = "name-server.database.windows.net",
Database = "work_dw", UID = "user", PWD = "pass")
# write to data to table
my_file #2.5MB
tictoc::tic()
DBI::dbWriteTable(con_azure, DBI::Id(schema = "my_dev", name = "new_table"), my_file)
tictoc::toc()
# 2305.56 sec elapsed