A complete solution for open data platforms, enterprise data catalogs, data lakes and data management. Open source, mature, fully-featured and production ready.

DataHub

Hi all, wondering if there is a way to fetch all upstreams of a given entity (not just the first "level") using either the REST or graphql API

There is no way to do this via Rest <@U02KN8FME3Z>. Via graphql, you can fetch a fixed number- for example, on the lineage graph we fetch two layers. However, you cannot fetch an unbounded number of layers via graphql.

Gotcha! That should be fine for our use case. I'll poke around in the networking tab and see if I can find an example

So I tried using:
```    relationships(input: {types: ["Contains"], direction: OUTGOING, start: 0, count: 100}) {
      total
      relationships {
        entity {
          urn
        }
      }
    }```
But this only returns the first "level" of upstreams (charts in this case). Take for instance a Looker dashboard, can I query for tables that are upstream of it?

```    relationships(input: {types: ["Contains"], direction: OUTGOING, start: 0, count: 100}) {
      total
      relationships {
        entity {
          urn
          ... on Chart {
              relationships(input: {types: ["Consumes"], direction: OUTGOING, start: 0, count: 100}) {
                  total
                  relationships {
                     entity {
                        urn
                     }
                   }
                 }
            } 
        }
      }
    }```

You get the point :slightly_smiling_face: You can nested relationship calls to traverse multiple edges!

Awesome, thanks! Is there a place I can find all of the valid values for the types: field? I see contains/consumes

We have a list of lineage types that the UI uses here:
<https://github.com/linkedin/datahub/blob/master/datahub-web-react/src/app/lineage/constants.ts#L2>

DownstreamOf is used in context of Dataset-&gt;Dataset relationships
Consumes is used in the context of Chart-&gt;Dataset relationships
Contains is used in the context of Dashboard-&gt;Chart
IsPartOf is used in the context of DataJob-&gt;DataFlow