https://datahubproject.io logo
#integrate-tableau-datahub
Title
# integrate-tableau-datahub
b

blue-crowd-84759

05/11/2022, 4:09 PM
Hey all, I'm trying to ingest data from Tableau and BigQuery and so far I'm not able to see any connections between my Tableau datasets and my BQ tables, can someone help me with how/if I can map a published dataset to a BQ table so I can see the complete lineage for a Tableau chart?
o

orange-night-91387

05/11/2022, 7:45 PM
@hundreds-photographer-13496 Can you take a look? From what I can tell it seems that the Tableau connector should be pulling in table lineage for published datasets from Tableau per the documentation here: https://datahubproject.io/docs/generated/ingestion/sources/tableau/#lineage
h

hundreds-photographer-13496

05/12/2022, 7:49 AM
@blue-crowd-84759 it is expected that you would see lineage like this for tableau chart Bigquery table (Dataset)->Tableau published datasource (Dataset)(optional)->Tableau embedded datasource (Dataset)->Tableau chart after ingesting from tableau source. Would it be possible for you to trace backwards from the concerned tableau chart (should be quite easy if you use lineage view for chart) whether you see upstream lineages set as above. If you can share screenshot, it will be helpful to understand the exact problem. Quick question - are you using custom sql tables ?
b

blue-crowd-84759

05/12/2022, 2:54 PM
My Tableau data sources are a mix of embedded sources, custom SQL tables, and views, but I’m not seeing any of them have any upstream lineage, they all start like this irrespective of type
h

hundreds-photographer-13496

05/16/2022, 12:26 PM
Datahub tableau source extracts lineage from tableau metadata api. It is likely that for the depicted custom sql query, tableau itself could not extract lineage. (Refer https://help.tableau.com/current/pro/desktop/en-us/customsql.htm#supported-lineage) Can you confirm if tableau was able to figure out the lineage by trying out below query on tableau graphiql in your browser. In case, tableau itself couldn't understand lineage, there is nothing much datahub can do at this point. Sometimes, it is possible to rewrite same query in tableau so that tableau can figure out the lineage. Here is the graphql query you can use to check if tableau could detect upstream tables for custom sql - https://datahubproject.io/docs/generated/ingestion/sources/tableau/#custom-sql-data-source Just replace the idWithin filter to use id of your custom sql query. You can locate id of custom sql query from its datahub URN. If URN is this - urnlidataset:(urnlidataPlatform:tableau,4fb670d5-3e19-9656-e684-74aa9729cf18,PROD), the bold part represents id to use for idWithin filter. Ideally upstreamTables show up in response, if tableau could figure out the lineage.
thank you 1
11 Views