I used to be able to see lineage to my mssql boxes...
# integrate-tableau-datahub
c
I used to be able to see lineage to my mssql boxes but now I only see tableau datasets. Did this functionality change?
h
I don't believe there was any change done to exclude the lineage . Which datahub cli version are you using ?
c
the lastest available in pypi
@hundreds-photographer-13496 was testing down with mssql and tableau?
h
I don't remember having come across mssql and tableau. Are you facing any issues related to incorrect urns ? Related to earlier lineage Q - can you paste screenshot of upstream lineage with respect to tableau chart and point to location where the mssql box is mixing.
c
they show up as embedded data sources
urnlidataset:(urnlidataPlatform:tableau,f54a37dc-2213-f148-69f4-7a370c012bb7,PROD)
h
nothing upstream of embedded datasources ? maybe a published datasource connected to mssql box ?
Can you query tableau metadata api using tableau graphiql interface to confirm if tableau metadata catalog has identified tables/datasources upstream of your embedded datasource ?
Copy code
{
  embeddedDatasources(filter: {idWithin: ["f54a37dc-2213-f148-69f4-7a370c012bb7"]}) {
    __typename
    id
    name
    upstreamTables {
      id
      name
      isEmbedded
      database {
        name
      }
      schema
      fullName
      connectionType
      description
    }
    upstreamDatasources {
      id
      name
    }
    workbook {
      name
      projectName
    }
  }
}
c
Copy code
{
  "data": {
    "embeddedDatasources": []
  }
}
shows as empty
let me dig a bit with that
some are not showing as empty
h
If you have an environment with multiple tableau sites - make sure you have switched to the relevant site on tableau home page, before you go to tableau graphiql interface.
c
We have hundreds of different sites
h
Then please go to site of concerned embedded datasource first that we are querying, and then open tableau graphiql interface by changing its url. We've observed in the past that there is no way to change site from tableau graphiql interface. Now sure about any new developments.