Is there a way in Snowflakes to get the list of tables used from given set of views

Question

I'm looking for a SQL script or some metadata table for views which have the source info.

Answer 1

You can use the function GET_OBJECT_REFERENCES to return the list of objects referenced by a view.

Please review the below documentation for more information and example:

https://docs.snowflake.com/en/sql-reference/functions/get_object_references.html#get-object-references