Audit Artifact Dependencies

2 followers
0
Avatar

I'd like an output of all artifacts and their dependencies.

 

I know you can do this by selecting the "Toggle Dependencies" button artifact by artifact and get the breadcrumb trail.  But we have too many artifact to do them manually.  I'd like an export (csv, xlsx...)  

Best case, some sql hitting the repository, returning the artifact breadcrumb trail, where I can limit it by OWNER in the sql.

BJ Erickson

2 comments

  • Avatar
    Gido

    The feature you are looking for is available via REST API call Workbook Dependencies, which is part of an add on package Advanced Governance

    After installing the REST API Dependencies add-on, you can download the hierarchy of up- and downstream dependencies for a given workbook in JSON format.

    0
  • Avatar
    Joel Stewart

    Hi BJ, the most accessible method for this is through the Toggle Dependencies button as you have highlighted. 

    Within the database, only the immediate "parent" of the existing artifact is stored. Building the full chain of dependencies through a single query is cumbersome since SQL is not well suited for recursion. Furthermore, the dependencies in the metadata are stored differently for different connection types (i.e. workbook-to-workbook or import-to-workbook).

    How long are the dependencies in your environment? I'd be glad to share this feedback with our product team directly to request a product enhancement on your behalf.

    0
Please sign in to leave a comment.