BigQuery table dependencies in views

QueryStash

BigQuery table dependencies in views

If you have many views in your datasets making changes to tables that are dependencies can be annoying, this query will help you find all the views that use a particular table.

1SELECT *
2FROM dataset_name.INFORMATION_SCHEMA.VIEWS
3WHERE REGEXP_CONTAINS(view_definition, 'dataset_name.table_name')

SELECT *
FROM dataset_name.INFORMATION_SCHEMA.VIEWS
WHERE REGEXP_CONTAINS(view_definition, 'dataset_name.table_name')

Public

bigquery

QueryStash

Created: Oct 8th 2020

QueryStash

Made with ❤️ by @Yekalb

Twitter Facebook Email

Resources

Blog Pricing Your First Query Search Your Stash

Examples

Merge Statements Persistent Functions Spike Detection QUALIFY Statement BigQuery ML Models

Stay up to date