Hi, guys! I have question about lineage.
I work wi...
# getting-startedg
gifted-traffic-47138
08/17/2022, 5:50 AMHi, guys! I have question about lineage.
I work with Tableau dashboards that are connected to ClickHouse using a custom SQL query. In the screenshot you can see lineage.
Can I show in lineage the relationship between a Custom SQL Query and certain tables in Clickhouse?
d
dazzling-judge-80093
08/17/2022, 8:57 AMDo you miss tables which are not in Tableu as entity?
As I can see there is an option to capture those as well with the:
Copy code
ingest_tables_external: Trueg
gifted-traffic-47138
08/25/2022, 9:35 AMNo, this option does not work
I need to build a lineage between table in database and SQL query in Tableau. That is, manually configure the lineage for two entities: dataset and view
gifted-traffic-47138
08/25/2022, 9:37 AMIn general, the question is how to manually create a lineage?
d
dazzling-judge-80093
08/25/2022, 9:38 AMmaybe the easiest with file based lineage -> https://datahubproject.io/docs/generated/ingestion/sources/file-based-lineage
dazzling-judge-80093
08/25/2022, 9:39 AMhere is a sample file how it looks like -> https://github.com/datahub-project/datahub/blob/master/metadata-ingestion/examples/bootstrap_data/file_lineage.yml
dazzling-judge-80093
08/25/2022, 9:39 AMbasically, you can define lineages with a yaml file
t
thankful-vr-12699
09/09/2022, 3:19 PMI have the same question for dataset -> Power BI dashboard.
w
white-pillow-1041
06/05/2023, 6:55 PMGood afternoon, I am encountering a similar use case attempting to create lineage between a Snowflake view and Power BI dataset. The Lineage API / Emitter (and also mentioned File Lineage) only suggest support for dataset to dataset lineage, therefore is table or view to dataset lineage simply not supported? Or is there any alternative option?
8 Views