Getting Downstream Lineages of a Dataset with GraphQL API in Datahub version 0.12.0

troubleshoot
1

Original Slack Thread

Hi teams, the graphql api - searchAcrossLineage don’t return the lineages which is 3+ degree. I want to get all downstream lineages of a dataset, which api is for me ?

    searchAcrossLineage(input: {
        urn: "urn:li:dataset:(urn:li:dataPlatform:mysql,10_16_10_94_3306_root.ApolloPortalDB.App,PROD)",
        direction: DOWNSTREAM,
        types: [DATASET],
        query: "*",
        start: 0,
        count: 100,
        orFilters: [
            {
                and:[
                    {
                        field: "degree",
                        values: ["1", "2", "3+"]
                    }
                ]
            }
        ]
    }){
        total
        searchResults{
            entity{
                ... on Dataset{
                    urn
                }
            }
            degree
        }
    }
}
// response
{
    "data": {
        "searchAcrossLineage": {
            "total": 3,
            "searchResults": [
                {
                    "entity": {
                        "urn": "urn:li:dataset:(urn:li:dataPlatform:mysql,10_16_10_94_3306_root.information_schema.INNODB_FT_CONFIG,PROD)"
                    },
                    "degree": 1
                },
                {
                    "entity": {
                        "urn": "urn:li:dataset:(urn:li:dataPlatform:mysql,DgTest.TAG_TEST3,PROD)"
                    },
                    "degree": 1
                },
                {
                    "entity": {
                        "urn": "urn:li:dataset:(urn:li:dataPlatform:mysql,DgTest.Test2,PROD)"
                    },
                    "degree": 2
                }
            ]
        }
    },
    "extensions": {}
}```
Datahub version: 0.12.0![attachment](https://files.slack.com/files-pri/TUMKD5EGJ-F06AL9E002U/image.png?t=xoxe-973659184562-6705490291811-6708051934148-dd1595bd5f63266bc09e6166373c7a3c)![attachment](https://files.slack.com/files-pri/TUMKD5EGJ-F069ZV7696Y/image.png?t=xoxe-973659184562-6705490291811-6708051934148-dd1595bd5f63266bc09e6166373c7a3c)
2

Hey there! :wave: Make sure your message includes the following information if relevant, so we can help more effectively!

  1. Which DataHub version are you using? (e.g. 0.12.0)
  2. Please post any relevant error logs on the thread!
3

query looks good, Is the problem specific to this URN or does it affect all entities?