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

modern-artist-55754

03/22/2022, 11:16 PM
Just a question here, how do you guys get lineage with custom sql? I have seen some of the workbook setup in our tableau where analysts had connection to a database and created a custom sql with bunch of joins and CTE statements to back the chart. When i use GraphQL to query this workbook, the
upstreamTables
field is empty, only the
upstreamDatabases
gets populated.
h

hundreds-photographer-13496

03/23/2022, 5:43 AM
c

colossal-easter-99672

03/23/2022, 6:42 AM
Tableau parse only tables from simple queries in custom SQL. You need to write your own SQL parser (for your language) to get all tables used in SQL.
👍 1
m

modern-artist-55754

03/23/2022, 10:30 AM
@colossal-easter-99672 thanks for the info. That explains on some complex queries, I don't see upstreamTables returned from GraphQL call.
👍 1
3 Views