Skip to content

timestamp_output_format is not supported yet. when running a query #7599

@djohnson-aperture

Description

@djohnson-aperture

Please make sure you have searched for information in the following guides.

Library Name

@google-cloud/bigquery

A screenshot that you have tested with "Try this API".

There's an identical issue that was resolved in the go library googleapis/google-cloud-go#13788.
I dug deep into the source with the debugger, and it seems that the library is attempting to use a feature that has not yet released in the api.
Here's the simplest query I could replicate in the api explorer. What's odd is that the explorer also suggests timestampOutputFormat as a valid option in the autocomplete. However, it doesn't seem to be released yet.
Image

Link to the code that reproduces this issue. A link to a public Github Repository or gist with a minimal reproduction.

https://gist.github.com/djohnson-aperture/1b16574011478dae9137aa1adca44210

A step-by-step description of how to reproduce the issue, based on the linked reproduction.

Any basic query using (new BigQuery()).query() seems to have the same issue.
(new BigQuery()).query('select 1;') is enough to trigger the error.

A clear and concise description of what the bug is, and what you expected to happen.

Any query throws a 400 error with the above mentioned error code.

A clear and concise description WHY you expect this behavior, i.e., was it a recent change, there is documentation that points to this behavior, etc. **

I just expect a basic query to work...

Metadata

Metadata

Assignees

No one assigned

    Labels

    api: bigqueryIssues related to the BigQuery API.priority: p2Moderately-important priority. Fix may not be included in next release.type: bugError or flaw in code with unintended results or allowing sub-optimal usage patterns.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions