QueryStash
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')
Created: Oct 8th 2020
Made with ❤️ by @Yekalb
© 2024 Query Stash. All rights reserved
Resources
Examples
Stay up to date