[bigquery]partitonテーブルの日別での作成時刻を取得するコード

2024-04-03 2024-04-03

SELECT

table_name,

partition_id,

total_rows,

last_modified_time

FROM

dataset.INFORMATION_SCHEMA.PARTITIONS

WHERE

table_name = '{テーブル名を指定}'

AND

SUBSTR(CAST(last_modified_time AS STRING), 1, 10) BETWEEN '2024-01-01' AND '2024-03-01'

SELECT table_name, partition_id, total_rows, last_modified_time FROM dataset.INFORMATION_SCHEMA.PARTITIONS WHERE table_name = '{テーブル名を指定}' AND SUBSTR(CAST(last_modified_time AS STRING), 1, 10) BETWEEN '2024-01-01' AND '2024-03-01'

SELECT
  table_name,
  partition_id,
  total_rows,
  last_modified_time
FROM
  dataset.INFORMATION_SCHEMA.PARTITIONS
WHERE
  table_name = '{テーブル名を指定}'
AND
  SUBSTR(CAST(last_modified_time AS STRING), 1, 10) BETWEEN '2024-01-01' AND '2024-03-01'

⇧指定したデータセット上のテーブルに関して、2024/1/1-3/1までのpartitonのテーブルの作成時刻を取得する