4
votes

When trying to explore a Big Query Table in Google Data Studio after having connected to it I get the following error. Any Ideas how to handle that or what it means?

The query returned an error.

Unrecognized name: _PARTITIONTIME at [1:167] Error ID: a6e0a88c

1

1 Answers

5
votes

In your Data Studio editor, click resources --> manage added data sources then go to edit connection.

There is an option to use _PARTITIONTIME as the time dimension. I suspect Data Studio has picked up this magic field and tried to use it as a time datatype and there is some incompatibility going on. I think this field is really metadata so shouldn't be used. Data Studio should really ignore it and not try to be too clever in finding your fields and inferring their usage & type from their names ( Although, mostly that is helpful ).

Unticking that option, clicking back to the report with Done will let you resolve the issue.

Click Resource then Manage added data sources

Click edit connection

Untick Use _PARTITIONTIME as time dimension