INFORMATION_SCHEMA

2023-02-27 최대 1 분 소요

BigQuery INFORMATION_SCHEMA 소개

BigQuery INFORMATION_SCHEMA 뷰는 읽기 전용이며 BigQuery 객체에 대한 메타데이터 정보를 제공하는 시스템 정의 뷰입니다.

INFORMATION_SCHEMA 뷰	리소스 유형
INFORMATION_SCHEMA.SCHEMATA	데이터 세트
INFORMATION_SCHEMA.SCHEMATA_OPTIONS	데이터 세트 옵션
INFORMATION_SCHEMA.JOBS_BY_*	작업
INFORMATION_SCHEMA.JOBS_TIMELINE_BY_*	작업 타임라인
INFORMATION_SCHEMA.OBJECT_PRIVILEGES	액세스 제어
INFORMATION_SCHEMA.RESERVATION*	예약
INFORMATION_SCHEMA.CAPACITY_COMMITMENT*	예약 용량 약정
INFORMATION_SCHEMA.ASSIGNMENT*	예약 할당
INFORMATION_SCHEMA.ROUTINES	루틴
INFORMATION_SCHEMA.ROUTINE_OPTIONS	루틴 옵션
INFORMATION_SCHEMA.PARAMETERS	루틴 매개변수
INFORMATION_SCHEMA.STREAMING_TIMELINE_BY_*	스트리밍 데이터
INFORMATION_SCHEMA.TABLE*	테이블
INFORMATION_SCHEMA.COLUMN*	테이블 열
INFORMATION_SCHEMA.PARTITIONS	테이블 파티션
INFORMATION_SCHEMA.TABLE_SNAPSHOTS	테이블 스냅샷
INFORMATION_SCHEMA.VIEWS	뷰
INFORMATION_SCHEMA.SESSIONS_BY_*	세션
TABLE META DATA	메타데이터

#standardSQL
SELECT *, TIMESTAMP_MILLIS(last_modified_time) last_modified_timestamp
FROM `dataset.__TABLES__` where table_id like 'table_name%'

project_id	dataset_id	table_id	creation_time	last_modified_time	row_count	size_bytes	type	last_modified_timestamp
your_project_id	your_dataset_id	your_table_id	1675647106802	1675647127420	4330	336088	1	2023-02-06 01:32:07.420000 UTC
your_project_id	your_dataset_id	your_table_id	1675647051287	1675647102301	5812	451295	1	2023-02-06 01:31:42.301000 UTC
your_project_id	your_dataset_id	your_table_id	1675647025282	1675647048880	4953	384616	1	2023-02-06 01:30:48.880000 UTC
your_project_id	your_dataset_id	your_table_id	1675647751604	1675647769644	4518	350798	1	2023-02-06 01:42:49.644000 UTC
your_project_id	your_dataset_id	your_table_id	1675647731291	1675647749110	4525	351292	1	2023-02-06 01:42:29.110000 UTC
your_project_id	your_dataset_id	your_table_id	1675647709909	1675647728649	4942	383588	1	2023-02-06 01:42:08.649000 UTC