Id 希望能够通过标准SQL访问BQ表元数据 - 即上次修改时间(构建一个警报系统,我们期望在一定时间内更新(插入(
使用legacySQL可以实现,但在标准SQL上看不到任何内容? 还是我错过了? 假设此类查询的成本为 0。
有没有更好的方法来通过堆栈驱动程序监控(即警报(来做到这一点?
干杯!
是的,它是免费的
#standardSQL
SELECT table_id,
DATE(TIMESTAMP_MILLIS(creation_time)) AS creation_date,
DATE(TIMESTAMP_MILLIS(last_modified_time)) AS last_modified_date,
row_count,
size_bytes,
CASE
WHEN type = 1 THEN 'table'
WHEN type = 2 THEN 'view'
WHEN type = 3 THEN 'external'
ELSE '?'
END AS type,
TIMESTAMP_MILLIS(creation_time) AS creation_time,
TIMESTAMP_MILLIS(last_modified_time) AS last_modified_time,
dataset_id,
project_id
FROM `yourProject.yourDataset.__TABLES__`