Filtering GraphQL search results by specific database and schema names

getting-started
1

Original Slack Thread

Hello! I am currently using the search() function in GraphQL and I do want to add a filter that it only gets the tables of a specific database name. Is that possible?

2

use query param in search gql to specify db_name/schema_name

  search(input: {type: DATASET, 
   query: "<db_name>.<schema_name>.*", start: 0, count: 50
      orFilters: [
      {
        and: [
        {
              field: "platform"
              values: ["redshift"]
              condition: CONTAIN
          }
        ]
      }
    ]
  }
  ) {
    start
    count
    total
    searchResults {
      entity {
        urn
        ... on Dataset {
            urn
            name
    
        }
      }
    }
  }
}```
3

My main concern here is what if I have 2 databases that has same database name, same database type, and same schema name. How do I differentiate them? Is it possible I can get them by their respective paths?

4

Try adding a filter for the brows path
like

        "field": "browsePathV2",
        "condition": "CONTAIN",
        "values": ["path-1"],
      }```