英文:
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
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论