CODEWITHSUNDEEP
google-bigquery
codninja0908
codninja0908

Reputation: 567

Fetch BQ metadata for multiple dated tables

I know the below query works for single table but is there a way to get metadata for multiple dated tables using wildcard. eg table1_20190102,

table1_20190103,

table1_20190104,

select table_id , row_count from <project_id>.<dataset_id>.__TABLES__ where table_id= 'table1_2019*'

Upvotes: 0

Views: 49

Answers (1)

Tamir Klein
Tamir Klein

Reputation: 3642

is there a way to get metadata for multiple dated

Yes, you can query __TABLES__ using LIKE as follow:

SELECT table_id , row_count FROM `project.dataset.__TABLES__`
WHERE table_id like 'table%'

Upvotes: 2

Related Questions