Suppress parsing message when running query

[davisderodes]

Hi!

I'm having trouble with suppressing the:

Parsing [========================================================================================] ETA:  0s

message (even though it's not actually a message) that comes from querying something using dplyr::collect() and connecting to a bigquery table.

I've tried all of the knitr options and using invisible, but they all are not working.

Is there a way I can silence this message earlier instead of trying to get .Rmd to ignore the message?

[davisderodes]

options("dplyr.show_progress" = FALSE)

Also did not work

[cderv]

@davisderodes

I've tried all of the knitr options

messages option is usually the way to hide messages in the resulting document but it works if the underlying code in indeed using messages for that.

@davisderodes

connecting to a bigquery table.

I believe you are using bigrquery package for that.

GitHub - r-dbi/bigrquery: An interface to Google's BigQuery from R.

I understand from the code that it should be quiet in non interactive session. Does it show in the output document when you render() or in notebook mode in IDE under the chunk ?

I think the progressbar is done using progress package, and it should not show in R Markdown document. I tried this

---
title: "test"
output: 
  html_document: default
---

```{r}
library(progress)
pb <- progress_bar$new(total = 100, clear = FALSE)
for (i in 1:100) {
  pb$tick()
  Sys.sleep(1 / 100)
}
```

This may come from somewhere else and without more information, I don't really know.

Hope it helps

[davisderodes]

Thank you so much for responding!

Yes, using bigrquery^

That's the strange thing. The "parsing" doesn't show up in the IDE under the chunk. It doesn't even show up in the R console when I run the function. It also doesn't show up when I click knit in the IDE. It only shows up when I use the render() function.

I'm working on trying to get a reprex together. I'll comment if I can get there.

[cderv]

@davisderodes

It only shows up when I use the render() function.

When you use the render() function in the main session, you are considered in interactive mode. So it could come from this.

If you really don't want the progress bar at all, you could try setting

options(progress_enabled=FALSE)

from the doc of progress if this is indeed the one used ?progress::progress_bar

This should deactivate it completely

[davisderodes]

Some heroes wear capes. Others help folks on RSudioCommunity. Thank you so much!

[cderv]

thank you !

If your question's been answered (even by you!), would you mind choosing a solution? It helps other people see which questions still need help, or find solutions if they have similar problems. Here’s how to do it:

FAQ: How do I mark a solution?

If your question has been answered, don't forget to mark the solution! How do I mark a solution? Find the reply you want to mark as the solution and look for the row of small gray icons at the bottom of that reply. Click the one that looks like a box with a checkmark in it: [image] Hovering over the mark solution button shows the label, "Select if this reply solves the problem". If you don't see the mark solution button, try clicking the three dots button ( ••• ) to expand the full set of options. When a solution is chosen, the icon turns green and the hover label changes to: "Unselect if this reply no longer solves the problem". Success! [solution_reply_author] …