<Reposting> here for visibility. Tableau is not re...
# integrate-tableau-datahuba
acoustic-quill-54426
02/07/2023, 5:26 PMReposting here for visibility. Tableau is not reporting lineage for hundreds of our customSQLTables. There is not much info on the root cause aside from this and I was wondering if anyone had to navigate around this e.g how to check what is exactly that’s not supported or a way to test the support of a query awthanks
b
billowy-sundown-55869
02/12/2023, 2:12 PMWe needed to change our urns to get this to work @acoustic-quill-54426. Is Datahub creating the upstream tables for you? It did for us, it was just duplicate and unmapped to the database table bc of mismatching urns.
a
acoustic-quill-54426
02/13/2023, 8:27 AMOur problem is not with datahub, but with tableau itself and its capability to extract lineage from custom sql tables. The upstream tables exist, but the ingestion does not report the lineage because tableau itself cant extract it
acoustic-quill-54426
02/13/2023, 8:28 AMafter some finagling on the Tableau sideI was hoping you had some insights on how to tweak the queries on tableau
acoustic-quill-54426
02/13/2023, 8:36 AMFor example, we have seen that casting with
::b
billowy-sundown-55869
02/13/2023, 1:19 PMI only pulled a smaller tableau project as we're QAing/Testing Datahub and didnt experience that issue yet. I'm guessing federated extracts will be an issue, at the very least. Will update if we experience or solve anything....
a
acoustic-quill-54426
02/13/2023, 1:35 PMThanks! FWIW we have submitted a case to Tableau and will be updating if we find something useful 👍
acoustic-quill-54426
03/13/2023, 4:14 PMtableau support was not of much help, so we are creating lineage ourselves https://datahubspace.slack.com/archives/C02GBGG90CU/p1678723909830749
5 Views