Hello, Im looking for a quick overview of any whe...
# integrate-tableau-datahub
m
Hello, Im looking for a quick overview of any where people have used dbt, data hub and tableau to show true lineage across tools if anyone can share an example please on whats possible Also do people feel there is still need and desire to have both datahub and Tableaus Catalog from Data Managment add-on?
l
how far upstream can you see in Tableau when you also have dbt? Would you be able to see the steps before dbt? That would be key for me
b
We’ve traced lineage from BQ (sources) -> dbt -> Tableau, but it’s been a bit of a struggle. Maybe it’s a function of the way we define our data sources in Tableau or how they are updated, but we inevitably get fanouts of data sources the moment we get to Tableau and it doesn’t seem to capture usage or lineage information too well for us. That said, it’s obviously an enormous improvement over the nothingburger we had before Haven’t tested the Data Management add-on so I can’t speak to that
m
If you use live connection, and your tableau developer doesn’t do crazy CustomSQL, the lineage is working fairly well. We have full lineage from Snowflake -> DBT -> Tableau. However there are some “incorrect” lineage generated by tableau. Main reason is that tableau Metadata API returns incorrect lineage information when you have super complex custom SQL. If you use live connection and not blending multiple SQL sources together, it tends to work fairly well.