如何获取BigQuery中Parquet文件的“最后修改”信息

huangapple go评论69阅读模式
英文:

How to get 'Last modified' information of parquert files in BigQuery

问题

我刚刚开始使用BigQuery和Looker。为了能够知道外部表中的信息何时更新,我需要访问parquet文件的'Last modified'属性。我已经有_FILE_NAME信息,但不能使用外部表的元数据,因为它不反映信息何时更新。

我需要访问的信息如下:
在此输入图像描述

**我已经有_FILE_NAME信息,但不能使用外部表的元数据,因为它不反映信息何时更新。

英文:

I've just started to use BigQuery and Looker. So as to be able to know when the information in a external table was updated, I would need to have access to the atribute 'Last modified' from the parquet files.
I have already the _FILE_NAME information and I can't use the metadata from the External table since it doesn't reflect when the information is updated.

This would the info i need to access to:
enter image description here

**I have already the _FILE_NAME information and I can't use the metadata from the External table since it doesn't reflect when the information is updated.

答案1

得分: 0

这在BigQuery外部表中是不可能的。

英文:

This isn't possible through BigQuery external tables

huangapple
  • 本文由 发表于 2023年7月18日 16:24:34
  • 转载请务必保留本文链接:https://go.coder-hub.com/76710824.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定