구글 빅쿼리 INFORMATION_SCHEMA

SELECT *
FROM `MyDatabase`.INFORMATION_SCHEMA.TABLES;

SELECT
column_name,
COUNT(table_name) as No_times_occ
FROM`MyDatabase`.INFORMATION_SCHEMA.COLUMN;

SELECT
CONCAT(table_catalog,".",table_schema,".",table_name) AS table_path, table_name, column_name,data_type
FROM`MyDatabase`.INFORMATION_SCHEMA.COLUMNS`
WHERE 데이터 유형 = 'INT64'

SELECT
res.period_start,
SUM(jobs.period_slot_ms) / 1000 / 60 AS period_slot_minutes,
ANY_VALUE(res.slots_assigned) AS slot_assigned,
ANY_VALUE(res.slots_max_assigned) AS slots_max_assigned
FROM
`region-us`.INFORMATION_SCHEMA.JOBS_TIMELINE_BY_ORGANIZATION jobs
JOIN
`region-us`.INFORMATION_SCHEMA.RESERVATIONS_TIMELINE_BY_PROJECT res
ON TIMESTAMP_TRUNC(jobs.period_start, MINUTE) = res.period_start AND jobs.reservation_id = res.reservation_id
WHERE jobs.job_creation_time BETWEEN TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 1 DAY) AND CURRENT_TIMESTAMP()
GROUP BY period_start
ORDER BY period_start DESC