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.
3WHERE REGEXP_CONTAINS(view_definition, 'dataset_name.table_name')
Created: Oct 8th 2020
Made with ❤️ by @Yekalb
© 2024 Query Stash. All rights reserved
Stay up to date