Query text specifies use_legacy_sql:false, while API options specify:true

Question

I'm using standardSQL with bigrquery:

library(bigrquery)
project <- "</project-name>"


sql <- "
#standardSQL
SELECT
</sql-query>;"


result <- query_exec(sql, project = project, useLegacySql = FALSE)

When I run the R script I get the following error:

 "Error: Query text specifies use_legacy_sql:false, while API options specify:true"

Any ideas what might be going on here?

Answer 1

I think it's use_legacy_sql = FALSE (note the underscores, not camelcase)

See here.

Answer 2

You just need to uncheck of "use legacy sql" at the "hide options". Here is the screenshot: