find the list of files using table references

I have a table referenced in the source.yml file. I like to find the list of files in the project that uses the table. How can I find the dependency. Thanks in advance.

If you have generated your documentation site, you can use the lineage graph viewer. Right click on the green source node and click `Refocus on node. Here’s a cut-down version from our project:

Otherwise, you can use dbt ls on the command line: dbt ls --select source:intercom.admins+

Thank you joel. I was able see all the dependencies through lineage map. But i’m not able to run the command. It gives me an error.

1 Like

dbt ls isn’t supported by the rpc server that powers dbt cloud unfortunately, so that only works on local installations of dbt

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.