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?

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
    
        }
      }
    }
  }
}

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?

Try adding a filter for the brows path like

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