0

I am trying to upload the data into Google Big Query using Bigrquery package in R - I was able to successfully run the script before, but today it failed with no changes within a script.

Please see the script below:

library(bigrquery)
df = mtcars
    bq_auth(email = "my@email.com")
    job <- insert_upload_job("project-id", "dataset", "table name", df)

When I run the script, it shows that it is working, but the upload takes an infinite amount of time. When I stop the upload process, I am getting below message:

Error in curl::curl_fetch_memory(url, handle = handle) : 
  Operation was aborted by an application callback

Surprisingly, I was able to run the above script successfully before, and it is only today that it failed (I haven't changed anything). Please help.

Thanks!

Phil
  • 7,287
  • 3
  • 36
  • 66
Kirill Konovalov
  • 59
  • 1
  • 12

1 Answers1

1

insert_upload_job is a deprecated function. They suggest changing it to using one of the api_perform functions.

Try this:

bq_tbl <- bq_table("project-id", "dataset", "table name")

bq_table_create(bq_tbl)

job <- bq_table_upload(bq_tbl,values=df,quiet = FALSE)
Randall Helms
  • 849
  • 5
  • 15