Standard SQL in bigrquery

0
votes

I'm trying to use R's bigrquery package to get some data from BigQuery into an R session. However, my query is written in BigQuery's Standard SQL rather than its legacy SQL dialect. How do I tell the package to run the query using Standard rather than legacy SQL?

1
rgoogle-bigquery

1 Answers

3
votes

See example below

insert_query_job <- function(query, project, destination_table = NULL,
    default_dataset = NULL,
    create_disposition = "CREATE_IF_NEEDED",
    write_disposition = "WRITE_EMPTY",
    useLegacySql = FALSE)