How can I get Table Name from BigQuery in python

Question

I would like to get only table names from BigQuery by using wildcard in Python.
What I want to do is something like this:

from google.cloud import bigquery
bigquery_client = bigquery.Client()
table_names = bigquery_client.get_something().something('db_name.table_prefix_*')

Can I do something like this?
If I can, What should I do?

SANN3 · Accepted Answer · 2020-04-23 16:11:37Z

4

Table metadata details available in the INFORMATION_SCHEMA. You can run the following query and get the table names using Python SDK.

Query:

SELECT table_name FROM YOUR_DATASET.INFORMATION_SCHEMA.TABLES where table_name like 'table_prefix_%'

Reference:

https://cloud.google.com/bigquery/docs/information-schema-tables

https://cloud.google.com/bigquery/docs/running-queries#python

answered Apr 23, 2020 at 16:11

SANN3

10.2k7 gold badges68 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

masaya Over a year ago

Thanks. you save my day!

masaya · Accepted Answer · 2020-04-23 18:37:18Z

2

I did as SANN3 taught me, like a following:

query = '''select table_name from my_dataset_name.INFORMATION_SCHEMA.TABLES where table_name like 'table_prefix_%' '''
table_names = bigquery_client.query(query).result().to_dataframe()
print(table_names)

then I got table_names :-)

answered Apr 23, 2020 at 18:37

masaya

4902 gold badges11 silver badges19 bronze badges

Collectives™ on Stack Overflow

How can I get Table Name from BigQuery in python

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related