빅쿼리 메타정보 조회 쿼리 예시

2022-05-05

.

Data_Engineering_TIL(20220505)

SELECT * FROM test_dataset.INFORMATION_SCHEMA.TABLES
where table_name like 'mytest_%'
order by table_name;

SELECT * FROM `myproject.test_dataset.__TABLES_SUMMARY__`
where table_id like 'testtable_20%'