How to query bigQuery view definition?

Question

Is there a way to query/search all of my bigQuery views definition? Not via API but on the BigQuery query UI?

Thanks

I don't think so. BigQuery doesn't expose metadata through views, which is how most other databases handle this. — Gordon Linoff
– Gordon Linoff, Commented Nov 11, 2018 at 13:04
Submit the form linked in issuetracker.google.com/issues/35906063#comment9 to get (alpha) access to INFORMATION_SCHEMA views. — Elliott Brossard
– Elliott Brossard, Commented Nov 11, 2018 at 13:59

MandyShaw · Accepted Answer · 2023-06-10 11:20:18Z

2

I've just managed to do this from the BigQuery UI using the following SELECT statement:

select table_name,view_definition
from myDataset.INFORMATION_SCHEMA.VIEWS

The key to getting it to work was the case sensitivity of 'INFORMATION_SCHEMA.VIEWS'.

answered Jun 10, 2023 at 11:20

MandyShaw

1,1653 gold badges15 silver badges31 bronze badges

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

1 Comment

The case-sensitivity in BigQuery's information schema objects is a bizarre design choice IMO 🫠