Hi! not sure this is the right place to ask so please direct me to the right channel if appropriate. I want to find which tables on mysql databases contain either the field

player_uid

or

player_id

. This is fairly easyto do as shown in the screenshot. Problem is I’d also like to know the type, i.e. is

player_id

a number or a string. I came up with a GQL query for this:

{
  search(input: {type: DATASET, query: "player_uid", start: 0, count: 10}) {
    start
    count
    total
    searchResults {
      entity {
        urn
        type
        ... on Dataset {
          name
          schemaMetadata {
            fields {
              fieldPath
              type
            }
          }
        }
      }
    }
  }
}

the only issue is it shows ALL the fields in the table and I’d like to have only the one called

player_id

OR

player_uid,

anyone knows if this is possible?

i think this depends on what version your datahub is on. v0.9 onwards has advanced search fuctionality and so the syntax is slightly different

thx for replying @better-orange-49102, I’m on v0.10.0

this query returns results for me -> i tried it on the demo website -> but i think the search is glitched @astonishing-answer-96712 this query in graphql and the query i do using UI do not match the same number of results (reference our previous conversation https://datahubspace.slack.com/archives/CV2KB471C/p1675907821500209)

query test{
  searchAcrossEntities(input:{
    types: DATASET
    query: "*"
    orFilters:[
      {and: [{field: "fieldPaths" condition: CONTAIN values: ["state_name"], negated: false}]}
      {and: [{field: "fieldPaths" condition: CONTAIN values: ["siour"], negated: false}]}
    ]
  }){
    count
    searchResults{
      entity{
        ... on Dataset{
          urn
        }
      }
    }
  }
}

I’m new to datahub, why is

searchAcrossEntities

needed?

hmm you can use

search

instead

trying it

yeah the filter works like that afaik. Maybe im not quite understanding the new syntax as well, I'm on 0.8.45 myself. perhaps @astonishing-answer-96712 can direct someone else to give a better informed reply.

Thank you xL! Yeah, we’re working on resolving this issue right now, here’s docs on the fieldPath schema: https://datahubproject.io/docs/advanced/field-path-spec-v2/#examples