I wanted to list or retrieve somehow which specific views selects data from a specific view or table in Snowflake. Something like:
SHOW VIEWS ... SELECTING FROM my_view
It would also be useful to know if it is possible to do that with Functions and Stored Procedures as well.
You could query the get_object_references() table function to get which view is referencing which other view.
Documentation reference: https://docs.snowflake.com/en/sql-reference/functions/get_object_references.html
Another alternative is to query the OBJECT_DEPENDENCIES view in the SNOWFLAKE.ACCOUNT_USAGE SCHEMA
Documentation Reference : https://docs.snowflake.com/en/sql-reference/account-usage/object_dependencies.html