I'm running this code:
project_id <- "projectid"
sql_string <- "SELECT * FROM mydb"
i_data <- query_exec(sql_string, project = project_id, useLegacySql = FALSE, destination_table = "projectid:myotherdb", allowLargeResults=TRUE, max_pages = Inf)
..on a pretty massive gcloud VM on windows (12core, 64gb mem).
It gets the db from googles bigquery db (about 50db data)
The issue is I get this error after 38% (only run it once as it took me about 8h to get this far) :
"Error encountered during execution. Retrying may solve the problem"
Any help appreciated!