SELECT s.schema_name, j.latest_creation_timeFROM `region-asia-northeast1`.INFORMATION_SCHEMA.SCHEMATA AS s LEFT JOIN ( SELECT referenced_table.dataset_id AS dataset_id, MAX(creation_time) AS latest_creation_time FROM `region-asia-northeast1`.INFORMATION_SCHEMA.JOBS_BY_PROJECT, UNNEST(referenced_tables) AS referenced_table WHERE referenced_table.table_id != '__TABLES__' GROUP BY referenced_table.da
![Bigqueryã¨Lookerstudioã®ç£è¦ã¾ã¨ã](https://cdn-ak-scissors.b.st-hatena.com/image/square/27f4d5615b7eba8beaca98146b2039568c30a339/height=288;version=1;width=512/https%3A%2F%2Fres.cloudinary.com%2Fzenn%2Fimage%2Fupload%2Fs--uqUHz9bE--%2Fc_fit%252Cg_north_west%252Cl_text%3Anotosansjp-medium.otf_55%3ABigquery%2525E3%252581%2525A8Lookerstudio%2525E3%252581%2525AE%2525E7%25259B%2525A3%2525E8%2525A6%252596%2525E3%252581%2525BE%2525E3%252581%2525A8%2525E3%252582%252581%252Cw_1010%252Cx_90%252Cy_100%2Fg_south_west%252Cl_text%3Anotosansjp-medium.otf_37%3Akiwamizamurai%252Cx_203%252Cy_121%2Fg_south_west%252Ch_90%252Cl_fetch%3AaHR0cHM6Ly9saDMuZ29vZ2xldXNlcmNvbnRlbnQuY29tL2EvQUVkRlRwNmlfQml4aE1xOXZXUzBiSk5VZ1ZYb2ZDNkVva0toRGNkZXJzSjg9czk2LWM%3D%252Cr_max%252Cw_90%252Cx_87%252Cy_95%2Fv1627283836%2Fdefault%2Fog-base-w1200-v2.png)
{{#tags}}- {{label}}
{{/tags}}