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

问题描述

在尝试连接到Google Data Studio中的大查询表后，出现以下错误.有什么想法如何处理或意味着什么吗?

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.

无法识别的名称:_PARTITIONTIME，日期为[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屋！