[Redshift] テーブルの最終DML時間取得

gistfile1.sql

SELECT
  MAX(endtime) + INTERVAL '9 hour' AS last_query_time
FROM
  stl_query r1
WHERE
  EXISTS (SELECT *
    FROM
      stl_querytext r2
    WHERE
      r1.userid = r2.userid
      AND r1.query = r2.query
      AND r1.xid = r2.xid
      AND r1.pid = r2.pid
      AND r2.text LIKE '%{table name}%')
;
-- クエリの内容を確認
SELECT *
FROM
  stl_querytext
WHERE
  text LIKE '%{table name}%'
ORDER BY
  1,2,3,4,5
;