yuya-maemichi-synspective · October 16, 2023 05:15 · yuya-maemichi-synspective · Oct 16, 2023
diff --git a/nonempty-tables.sql b/nonempty-tables.sql
 SELECT
  *
 FROM
  `region-asia-northeast1`.INFORMATION_SCHEMA.TABLE_STORAGE
 WHERE
  total_rows > 0
  -- OR total_logical_bytes > 0
  -- OR total_physical_bytes > 0
 ORDER BY
  storage_last_modified_time desc
	SELECT
	*
	FROM
	`region-asia-northeast1`.INFORMATION_SCHEMA.TABLE_STORAGE
	WHERE
	total_rows > 0
	-- OR total_logical_bytes > 0
	-- OR total_physical_bytes > 0
	ORDER BY
	storage_last_modified_time desc