In DBT cloud ,is that possible to get the tables & views associated with the Models/sources

Help
1

The problem I’m having

In dbt Cloud ,Assume we have folder with many SQL scripts. Can you able search all file content to find a table or view ? without manually opening all the files

The context of why I’m trying to do this

What I’ve already tried

dbt ls | findstr /i “view_name”/“Table_name”

Some example code or error messages

Put code inside backticks
  to preserve indentation
    which is especially important 
      for Python and YAML!
3

yes it is possible
we cannot run dbt ls command in dbt cloud ide, we have to create a job and add the below command to the job and run the job
dbt ls --select models/<folder-1>/<sub-folder-1> config.materialized:table config.materialized:view --exclude test_type:generic test_type:singular

It will list all the models which are materialized as tables/ views under path models//

in my case i ran dbt ls --select models config.materialized:table config.materialized:view --exclude test_type:generic test_type:singular it gave me this. looks like its working

image
image1525×586 49.1 KB

4

I am getting the error Message
“No Matching handler found for rpc method
None(which=list)”

5

where are u executing the command in cloud IDE or through Job?

6

regret have executed in ide, can you please help me to create a job