Question: How to disable progress bar when creating connection?

[jhrcek]

I'm using duckdb R package 1.2.0.

When running long queries, I occasionally get progress bar display.
I'm running in an environment without proper terminal support and I'd like to disable rendering of progress bar.
I know it's possible to do it by explicitly running the statement SET enable_progress_bar = false;
But doing this every time gets annoying fast.
Is it possible to disable progress bar using connection options?

I tried using config parameter of ducdkb() function like this:

con <- DBI::dbConnect(
      duckdb::duckdb(
            dbdir =  "...", 
            read_only = TRUE,
            config = list( max_memory=Sys.getenv("DUCKDB_MAX_MEMORY", unset="16GB"),
                            temp_directory="/tmp/duckdb_temp",
                            enable_progress_bar="false")
     )
  )

But this gives me the following error:

rapi_startup: Failed to set configuration option: {"exception_type":"Invalid Input","exception_message":"Could not set option \"enable_progress_bar\" as a global option"}

Tried various values for enable_progress_bar ("f", "0", "FALSE", "False") but nothing seems to work..

[krlmlr]

Thanks. The option is set unconditionally, but progress display is only enabled in interactive sessions, and you can disable it by setting the "duckdb.progress_display" option. Updating NEWS.md .

[jhrcek]

Thank you, doing this before creating the connection works for me

options(duckdb.progress_display = FALSE)