find the list of files using table references

[rjames]

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.

[joellabes]

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+

[rjames]

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.

[joellabes]

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