Google Data Studio 无法探索 Big Query 时间分区表 [英] Google Data Studio can't explore Big Query time partitioned table

问题描述

在连接到 Google Data Studio 后尝试在其中探索 Big Query 表时，我收到以下错误.任何想法如何处理它或它意味着什么?

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?

查询返回错误.

无法识别的名称:_PARTITIONTIME at [1:167] 错误 ID:a6e0a88c

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

推荐答案

在您的 Data Studio 编辑器中，单击资源 --> 管理添加的数据源，然后转到编辑连接.

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

可以选择使用 _PARTITIONTIME 作为时间维度.我怀疑 Data Studio 已经选择了这个魔法字段并尝试将它用作时间数据类型，但存在一些不兼容问题.我认为这个字段真的是元数据，所以不应该使用.Data Studio 真的应该忽略它，不要试图太聪明地查找您的字段并推断它们的用法 &从他们的名字中输入(虽然，大多数情况下这是有帮助的).

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 ).

取消选中该选项，点击返回带有Done 的报告即可解决问题.

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

这篇关于Google Data Studio 无法探索 Big Query 时间分区表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！