I created an external table by importing a Google Sheet link in BigQuery.
However, I accidentally deleted this table.

I tried to recover the table by checking the table creation and deletion logs according to the instructions on this link: https://derrickqin.com/how-to-restore-a-deleted-bigquery-dataset. However, I was unable to recover the table because I could not find any information about the table in INFORMATION_SCHEMA.TABLE_STORAGE_TIMELINE.

How can I check the creation and deletion logs of an external table? And could you please explain how to recover the table?

SELECT *
FROM
  [region].INFORMATION_SCHEMA.TABLE_STORAGE_TIMELINE
WHERE table_name like '%~%'
AND DELETED = true;