Skip to content

Error when using bqr_query to create views #66

@lynuhs

Description

@lynuhs

I'm getting an error when creating a view with bqr_query(), though it still creates the view.

bqr_query(
projectId = projectId,
datasetId = datasetId,
query = "CREATE VIEW 'project_id.dataset_id.view_name' AS SELECT date, sum(volume) as vaolume FROM 'project_id.dataset_id.table_id' GROUP BY date",
useLegacySql = FALSE
)

Error in matrix(unlist(unlist(x$rows)), ncol = length(schema$name), byrow = TRUE) :
'data' must be of a vector type, was 'NULL'

Error : API Data failed to parse. Wrote diagnostic object to 'gar_parse_error.rds', use googleAuthR::gar_debug_parse('gar_parse_error.rds') to debug the data_parse_function.

error
1 SQL Error
message:
1 API Data failed to parse. \n Wrote diagnostic object to 'gar_parse_error.rds', use googleAuthR::gar_debug_parse('gar_parse_error.rds') to \n debug the data_parse_function.

Warning message:
In bqr_query("project_id", "dataset_id", "CREATE VIEW 'project_id.dataset_id.view_name' AS SELECT date, sum(volume) as volume FROM 'project_id.dataset_id.table_id' GROUP BY date", :
API Data failed to parse.
Wrote diagnostic object to 'gar_parse_error.rds', use googleAuthR::gar_debug_parse('gar_parse_error.rds') to
debug the data_parse_function.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions