go - 如何通过查询/ cli / go获取表的到期日期？(How to get table expiration date via query / cli / go?)

Question

I can't find a way to extract table expiration date that is not via the console ( https://console.cloud.google.com/ ).

(我找不到不是通过控制台（ https://console.cloud.google.com/ ）提取表到期日期的方法。)

We maintain thousands of tables in BQ and we want to enforce the use of table expiration date - so the only way is to collect the data automatically.

(我们在BQ中维护着数千个表，并且我们想强制使用表到期日期-因此，唯一的方法是自动收集数据。)

is this possible via query/cli/go/python/perl/whatever?

(通过query / cli / go / python / perl / whatever可以吗？)

  ask by EldadT translate from so

Answer 1

this can be done via querying the INFORMATION_SCHEMA.TABLE_OPTIONS:

(这可以通过查询INFORMATION_SCHEMA.TABLE_OPTIONS来完成：)

SELECT * FROM `my_project.my_dataset.INFORMATION_SCHEMA.TABLE_OPTIONS`
where option_name='expiration_timestamp'

the value will be in the option_name column.

(该值将在option_name列中。)