Solution to R bigquery: Exceeded rate limits when returning large amounts of data

[StephenMcDaniel]

After reading this discussion, " R bigrquery returns the following error: Exceeded rate limits", I found that these options worked for me:

  page_size = 1000000,
  max_connections = 3L,

Like this:

con1 <- dbConnect(
  bigrquery::bigquery(),
  project = "pjname",
  dataset = "ds_name",
  billing = "bill_name",
  page_size = 1000000,
  max_connections = 3L,
)

[ganapap1]

Hi
insert this code in your server-side and see
options(shiny.maxRequestSize=30*1024^2) #would increase the limit to 30MB.
hope it helps