Skip to content

Instantly share code, notes, and snippets.

@daanalytics

daanalytics/object_dependency.sql

Created April 21, 2023 14:25
Show Gist options
  • Save daanalytics/756e85811a07a384d00ab8af816e9f31 to your computer and use it in GitHub Desktop.
Save daanalytics/756e85811a07a384d00ab8af816e9f31 to your computer and use it in GitHub Desktop.
Download ZIP
Query the Object Dependencies
Raw
object_dependency.sql
SELECT *
FROM snowflake.account_usage.object_dependencies
WHERE referencing_object_name = 'CUSTOMER_LOYALTY_V'
AND referenced_object_domain = 'TABLE'
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment